If you notice your Excel file is taking a long time to open or to save, it could be because there are thousands of cells that contain some kind of formatting without you realising.
If you tap Ctrl + End on your keyboard, that will take you to the last formatted cell. If it takes you well beyond the cells you have data in, you will need to remove all of these 'formatted' cells to reduce the file size.
- Select the cell that is one row down and one column to the right of your data.
- Tap Ctrl+Shift+<down arrow> then Shift+<space bar> . This will highlight all rows below your data. Right-click the selected rows and choose Delete.
- Again, select the cell that is one row down and one column to the right of your data.
- Tap Ctrl+Shift+<right arrow> then Ctrl+<space bar>. This will highlight all columns to the right of your data. Right-click the selected region and choose Delete.
- Save your workbook. Tapping Ctrl+End should take you to the last cell of your data.