View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier
 
Posts: n/a
Default How do I create an Excel worksheet with a limited no. of rows?

Hi

The sheet will always be 256 columns by 65536 rows.
You can Hide rows and columns to give the appearance of a smaller sheet.
Got to row 21, click on the row number, hold down Ctrl+Shift and Arrow down,
this will select rows 21:65536, right clickHide.

Go to column U, and repeat but use Arrow right to select columns U:IV

Regards

Roger Govier


WarTech wrote:
OK - what I should have said was: How?

"Gary''s Student" wrote:


yes
--
Gary''s Student


"WarTech" wrote:


I need to create a small worksheet in Excel 2002 with say 20 rows & 20 columns.
Is this possible?