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

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
using the =page! feature to transpose a row to column 0
Transferring only certain rows to seperate worksheet 8
limit number of rows in worksheet from 6000+ to 600 2
Lookup & return multiple rows based on cell value 3
Delete 1 row of objects, not all on sheet Excel 2007 11
Referencing column to row across worksheets 1
Function in Excel to count and list number of entries of text valuesin a row. 2

Top