- To select all columns to the right of the last column that contains data, click the first column heading, press <ctrl><shift><right>
- To select all rows below the last row that contains data, click the first row heading, press <ctrl><shift><down>
- On the Home tab, in the Editing group, click the arrow next to the Clear button, and then click Clear All
- Click the Microsoft Office Button , and then click Save
- Click the Microsoft Office Button , and then click Close
- When you open the workbook again, the last cell of the data should be the last cell on the worksheet
Monday, 6 June 2016
Excel - reset the last cell on a worksheet
Labels:
Excel
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment