Find and reset the final cell on a worksheet

Find and reset the final cell on a worksheet

Whenever you save a workbook, Excel shops solely the a part of every worksheet that incorporates information or formatting. Empty cells could include formatting that causes the final cell in a row or column to fall exterior of the vary of cells that incorporates information. This causes the file dimension of the workbook to be bigger than vital and should end in extra printed pages if you print the worksheet or workbook.

To keep away from these points, you’ll be able to find the final cell that incorporates information or formatting on a worksheet, after which reset that final cell by clearing all the formatting that could be utilized in empty rows or columns between the info and the final cell.

Find the final cell that incorporates information or formatting on a worksheet

  • To find the final cell that incorporates information or formatting, click on anyplace within the worksheet, after which press CTRL+END.

Notice: To pick the final cell in a row or column, press END, after which press the RIGHT ARROW key or the DOWN ARROW key.

Clear all formatting between the final cell and the info

  1. Do one of many following:

    • To pick all columns to the appropriate of the final column that incorporates information, click on the primary column heading, maintain down CTRL, after which click on the column headings of the columns that you simply need to choose.

      Tip: You too can click on the primary column heading, after which press CTRL+SHIFT+END.

    • To pick all rows beneath the final row that incorporates information, click on the primary row heading, maintain down CTRL, after which click on the row headings of the rows that you simply need to choose.

      Tip: You too can click on the primary row heading, after which press CTRL+SHIFT+END.

  2. On the Dwelling tab, within the Modifying group, click on the arrow subsequent to the Clear button Button image , after which click on Clear All.

  3. Save the worksheet.

  4. Shut the worksheet.

    Whenever you open the workbook once more, the final cell of the info must be the final cell on the worksheet.

Want extra assist?

You possibly can at all times ask an professional within the Excel Tech Group, get assist within the Solutions group, or counsel a brand new function or enchancment on Excel Person Voice.

Prime of Web page

Leave a Reply