Forum Discussion
workbook file size seems too big
I have a workbook with only one worksheet, in that worksheet - 4 columns with drop down control buttons up to 140 rows and 4 columns of drop down list with data up to 300 rows and the file size is 11.8 MB !
there is no pictures/images of any kind in the workbook, just 2 modules of vba control codes.
I wonder if this can be reduced somehow, it takes about 12 seconds to open the workbook, I am worried if more data is added...
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
6 Replies
- Hi Lorenzo,
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 Roe
