How to restrict the number of rows & columns?

[sridhar]

Hi,

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

Sri...

 

[Bob Phillips]

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)

 

[Ron de Bruin]

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

 

[macropod]

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

 

[Jon Peltier]

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