| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hierarchical Worksheet Tabs??? New Excel feature? | Excel Discussion (Misc queries) | |||
| Create invoice from Excel worksheet | Excel Discussion (Misc queries) | |||
| how do i create a path to a worksheet from outside of excel | Excel Discussion (Misc queries) | |||
| max rows on an Excel worksheet | Excel Discussion (Misc queries) | |||
| How do I limit the number of rows in an Excel worksheet. | Excel Worksheet Functions | |||
Linear Mode
