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! |
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! |
All times are GMT +1. The time now is 04:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com