How to restrict the number of rows & columns?

Hi,

can some one help me in konwing how to restrict the number of rows and
columns in an excel sheet

Sri...

Sri,

You cannot change the number of rows or columns, but you could hide any
beyond the ones you want to see.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"sridhar" wrote in message
...
Hi,

can some one help me in konwing how to restrict the number of rows and
columns in an excel sheet

Sri...

Please post in one newsgroup

You can't delete the rows in Excel.
But you can hide them if you want like this

This example will hide all rows below row 100

1) Select row 101(Click on 101 to select the whole row)
2) Ctrl-Shift-down Arrow to select all rows below row 100
3) Right click on the selection
4) Choose Delete first to be sure that all the cells are empty
5) Right click on the selection again and choose Hide

You can do the same for your columns


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"sridhar" wrote in message ...
Hi,

can some one help me in konwing how to restrict the number of rows and
columns in an excel sheet

Sri...

Before hiding rows/columns that you don't want used, format them so that
they're protected to prevent data entry (and unprotect any in the visible
area that you want users to be able to do something in), and protect the
worksheet after hiding them.

Cheers


"sridhar" wrote in message
...
Hi,

can some one help me in konwing how to restrict the number of rows and
columns in an excel sheet

Sri...






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.561 / Virus Database: 353 - Release Date: 13/01/2004

Three excellent suggestions g. Why are you doing this?

(a) To keep the user within a certain region? Fine idea, keep them
reined in.

(b) To reduce file size? Won't reduce it at all. Ron's suggestion to
delete the rows and columns before hiding them might help by removing
invisible memory hogs, but ti's the deletion, not the hiding, that saves
bytes.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

sridhar wrote:

Hi,

can some one help me in konwing how to restrict the number of rows and
columns in an excel sheet

Sri...