Forum Discussion
workbook file size seems too big
Click on U1002 then hold Ctrl + Shift and press the down arrow key to highligh all the empty rows
Then go to Home > Delete > Delete Sheet Rows.
Close and Save your file
Any hidden sheets?
When you press End Home what cell does the cursor jump to?
If it's way down in the bottom right corner you can try deleting all the empty rows and columns and then save your file.
Mr Wyn Hopkins
Thank you for your reply.
My workbook do not have hidden sheets.
when I press Ctrl End - it went to the bottom at P1048576.
How do I delete all the empty rows?
THANK YOU
- From that bottom cell hold down Ctrl & Shift then press the Up arrow key.
This will highlight all the rows
Then go to
Home > Delete.. Entire Sheet RoeMr Wyn Hopkins
Thank you for your reply.
My workbook is a monthly record of items returned by clients for whatever reason (status) and the actions taken. This will in turn be used for analysis to find ways to minimize damages.
Attached are images of my workbook.
For data entry - rows up to 1001
Columns C,D,G,H have drop down buttons for users to select data (all 1001 rows)
the drop down lists is from Q to U column and can go more than 1001 rows
how do I delete those unneeded rows/columns to lessen the file size?
the last column used is U
MANY MANY THANKS
Click on U1002 then hold Ctrl + Shift and press the down arrow key to highligh all the empty rows
Then go to Home > Delete > Delete Sheet Rows.
Close and Save your file