Delete Unused Rows and Cells
- Thread starter JuliusV
- Start date
Hi
If it means you have empty rows a then some more data. You can pick a column select whole range , F5 special , mark blanks, ok , then write something which is not repeated elsewhere and press control enter.
then you can filter for what you have just written and you have rows ready to delete
If it means you have empty rows a then some more data. You can pick a column select whole range , F5 special , mark blanks, ok , then write something which is not repeated elsewhere and press control enter.
then you can filter for what you have just written and you have rows ready to delete
NARAYANK991
Excel Ninja
Hi ,
Excel worksheets have a standard number of rows and columns ; these will vary depending on the version of Excel that you use.
However , based on your usage of these rows and columns , Excel will save only what is relevant , and therefore your workbook size will be dependent on how much of the available worksheet capacity you have actually used.
To have an idea of whether your worksheets extend beyond what you think is normal , on each worksheet press CTRL END ; this will place the cursor in the last used cell on that worksheet ; thus , the range from cell A1 through to this last used cell ( where ever it may be ) is the actual used range , which Excel will save.
In case you think this used range has been inflated beyond normal limits , you can reset it , so that your file size is reduced.
See the following links for more information :
https://support.microsoft.com/en-us/kb/244435
http://www.accountingweb.com/article/resetting-last-cell-excel-worksheet/221618
https://support.office.com/en-sg/ar...orksheet-c9e468a8-0fc3-4f69-8038-b3c1d86e99e9
Yet another way to reduce your file size on the hard disk , is to save it as a .xlsb file , which will reduce the time it takes to load when you open it.
See the following links for more information :
http://blog.datasafexl.com/excel-articles/advantages-of-xlsb-excel-binary-format/
http://superuser.com/questions/390742/downsides-to-microsoft-excel-2007-xlsb-binary-format
Narayan
Excel worksheets have a standard number of rows and columns ; these will vary depending on the version of Excel that you use.
However , based on your usage of these rows and columns , Excel will save only what is relevant , and therefore your workbook size will be dependent on how much of the available worksheet capacity you have actually used.
To have an idea of whether your worksheets extend beyond what you think is normal , on each worksheet press CTRL END ; this will place the cursor in the last used cell on that worksheet ; thus , the range from cell A1 through to this last used cell ( where ever it may be ) is the actual used range , which Excel will save.
In case you think this used range has been inflated beyond normal limits , you can reset it , so that your file size is reduced.
See the following links for more information :
https://support.microsoft.com/en-us/kb/244435
http://www.accountingweb.com/article/resetting-last-cell-excel-worksheet/221618
https://support.office.com/en-sg/ar...orksheet-c9e468a8-0fc3-4f69-8038-b3c1d86e99e9
Yet another way to reduce your file size on the hard disk , is to save it as a .xlsb file , which will reduce the time it takes to load when you open it.
See the following links for more information :
http://blog.datasafexl.com/excel-articles/advantages-of-xlsb-excel-binary-format/
http://superuser.com/questions/390742/downsides-to-microsoft-excel-2007-xlsb-binary-format
Narayan