How do I create an Excel worksheet with a limited no. of rows?

W

WarTech

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

Roger Govier

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 click>Hide.

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

Regards

Roger Govier
 
P

Phil Sharpe

Many thanks

Roger Govier said:
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 click>Hide.

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

Regards

Roger Govier
 
Top