To locate the last cell that contains data or formatting, click anywhere in the worksheet, and then press CTRL+END. Note To select the very last cell in a row or column, press END, and then press the RIGHT ARROW key or the DOWN ARROW key.Top of Page.ip You can also click the first row heading, and then press CTRL+SHIFT+END. 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.