View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Francois via OfficeKB.com Francois via OfficeKB.com is offline
external usenet poster
 
Posts: 109
Default How to limit number of rows and column in worksheet?

Hrishi wrote:
Generally when we creat 'new' - blank Worksheet, it has 65536 rows and upto
'IV' columns by default.
We could see some excle worksheet customized to have only limited rows and
columns as per requirements.
Similarly suppose i want only 100 rows and wirst 25 coulmns only how to
limit this.



You can hide the rows / columns you don't need.

Highlight the rows

right click the mouse

choose hide

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200706/1