Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |