How do I limit rows and columns in all of my excel 2007 worksheets

P

Paula

I never use that many rows or columns-is there I place I can limit them? Or
if only can do for 1 sheet at a time, how do I do it? I know how to hide
them all, but when I do does that take up bites or space where they are
stored?

Thank you, Paula
 
M

Meebers

A single sheet with a single letter on it saved as a 2003 type file takes up
16kb. This is a fairly small file. Adding 2 more sheets raises it to 20K.
Adding data to the work sheet is what makes it grow in size. What are the
typical file sizes that you have been saving.?
 
P

Paula

1500 KB

Meebers said:
A single sheet with a single letter on it saved as a 2003 type file takes up
16kb. This is a fairly small file. Adding 2 more sheets raises it to 20K.
Adding data to the work sheet is what makes it grow in size. What are the
typical file sizes that you have been saving.?
Click to expand...
 

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

2007-Delete only 1 row of objects on worksheet, not all of them. 0
Hide columns based on row values 2
Function in Excel to count and list number of entries of text valuesin a row. 2
How do I unhide a row when ENTER is pressed in a certain cell? 6
How do I clear a form? 0
limit number of rows in worksheet from 6000+ to 600 2
Delete 1 row of objects, not all on sheet Excel 2007 11
Worksheet Automation and Size Limiting 0

Top