Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I limit rows and columns in all of my excel 2007 worksheets
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I limit rows and columns in all of my excel 2007 worksheets
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.? "Paula" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I limit rows and columns in all of my excel 2007 worksh
1500 KB
"Meebers" wrote: 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.? "Paula" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I limit the Number of rows in an excel 2007 workbook | Setting up and Configuration of Excel | |||
Number of rows in Excel 2007 worksheets | Excel Discussion (Misc queries) | |||
Excel 2007 rows & columns | Excel Discussion (Misc queries) | |||
how do i limit my worksheet size to say 11 columns and 11 rows. | New Users to Excel | |||
How do I limit number of rows and columns on a spreadsheet | New Users to Excel |