Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting unneeded rows and columns
Is there a way to delete extra rows and columns from a worksheet? I have all
the data I need in the sheet and would like to eliminate the file size by getting rid of all the extra rows and columns. Example: The worksheet would be A1:F51, rows G on would be gone. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting unneeded rows and columns
You can't physically remove them but you can hide them although this doesn't
reduce the file size. Try resetting the used range (which can reduce file size): http://contextures.com/xlfaqApp.html#Unused Biff "mbing916" wrote in message ... Is there a way to delete extra rows and columns from a worksheet? I have all the data I need in the sheet and would like to eliminate the file size by getting rid of all the extra rows and columns. Example: The worksheet would be A1:F51, rows G on would be gone. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting Rows with data duplicated in 2 columns | Excel Worksheet Functions | |||
Charts should not be resized when deleting rows/columns. | Charts and Charting in Excel | |||
Disable Adding & Deleting Rows/Columns | Excel Discussion (Misc queries) | |||
Deleting excess rows and columns | New Users to Excel | |||
Disable Adding or Deleting Rows and Columns | Excel Discussion (Misc queries) |