changing sheet size

M

mmap hq

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
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AutoFilter May be Misbehaving 7
Update worksheet when changing another sheet 7
Formatting Rows 5
Excel Excell .xls File Growing Fast 0
VBA - retrieve data on last create named range from previous inserted named range 0
Rows to repeat at top 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
protecting sheet 1

Top