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

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

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

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?

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

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?

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?

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

Many thanks

"Roger Govier" wrote in message
...
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?