| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
changing sheet size
We have a worksheet that is maxed out to 65536 rows & also lots & lots of
columns. No need for that we could use 1000 rows & 20 columns. How can we do this? TIA |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
changing sheet size
-- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "mmap hq" wrote in message ... We have a worksheet that is maxed out to 65536 rows & also lots & lots of columns. No need for that we could use 1000 rows & 20 columns. How can we do this? TIA |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
changing sheet size
If you look in Help under 'specs' you will find that Excel 2003 (and 1997,
2002) has a sheet size of 65,536 rows by 256 columns. Excel 2007's size is 1,048,576 rows by 16,384 columns But are you saying you want smaller? There is not way to do this either nor is there a need - it will not alter the file size. You could hide some rows & columns best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "mmap hq" wrote in message ... We have a worksheet that is maxed out to 65536 rows & also lots & lots of columns. No need for that we could use 1000 rows & 20 columns. How can we do this? TIA |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
changing sheet size
"Bernard Liengme" wrote in message ... -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email What has this to do with anything? "mmap hq" wrote in message ... We have a worksheet that is maxed out to 65536 rows & also lots & lots of columns. No need for that we could use 1000 rows & 20 columns. How can we do this? TIA |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
changing sheet size
Sorry, I hit send with an empty message!
-- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "mmap hq" wrote in message ... "Bernard Liengme" wrote in message ... -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email What has this to do with anything? "mmap hq" wrote in message ... We have a worksheet that is maxed out to 65536 rows & also lots & lots of columns. No need for that we could use 1000 rows & 20 columns. How can we do this? TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing size | New Users to Excel | |||
| Work sheet size relative to screen size | Excel Discussion (Misc queries) | |||
| Changing the size of checkbox | Excel Discussion (Misc queries) | |||
| how to set sheet size to reduce file size | Excel Discussion (Misc queries) | |||
| changing paper size | Setting up and Configuration of Excel | |||
Linear Mode
