How to restrict the number of rows & columns?

  • Thread starter Thread starter sridhar
  • Start date Start date
S

sridhar

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)
 
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
 
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
 
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
 
Back
Top