|
Answer» Below are the STEPS to reduce the file size:
- Find the last cell that contains data in the SHEET. Delete all rows and columns after this cell
- To delete the rows, press the key Shift+Space then press Ctrl+Shift+Down on your keyboard
- Rows will get selected TILL the last ROW. Press Ctrl+- on the keyboard to delete the BLANK rows
- To delete the column, Press the key Ctrl+Space then press Ctrl+Shift+Right Arrow key on your keyboard
- Columns will get selected till the last row
- Press Ctrl+- on the keyboard to delete the blank columns
Below are the steps to reduce the file size:
|