Home OS Windows How to locate and reset the last cell on an Excel worksheet

How to locate and reset the last cell on an Excel worksheet

Whenever you shut a Microsoft Excel file and re-open it, the file, by default, jumps to the ultimate cell containing information or formatting. However, in case you don’t love this default conduct, you presumably can create a macro. It will mechanically reset the ultimate cell on an Excel file for you. See, the proper means to proceed with it.

Reset the ultimate cell on an Excel worksheet

When you revise your Excel file and attempt to put it apart, the app, together with revisions, moreover saves any half containing information or formatting. As such, any empty cells containing formatting and lying exterior the differ of cells containing information may get included. This may finish in an increase inside the file measurement of the workbook. It may additionally finish in further printed pages in case you print the workbook. To steer clear of this, reset that ultimate cell by switching to the Clean Excess Cell Formatting command, on the market on Excel’s Inquire tab.

  1. Go to File
  2. Select Options.
  3. Choose Add-ins.
  4. Select COM Add-ins inside the Manage
  5. Check Inquire
  6. Under the Inquire tab, select Clean Excess Cell Formatting.

Let’s see the methodology in somewhat little bit of factor!

Go to the File tab on the Ribbon menu of your Excel file.

Click the File tab to go to Options (seen on the bottom of the sidebar).

When the Excel Options window opens, choose Add-ins chance inside the sidebar.

Com Addins Section

Then, select COM Add-ins from the Manage subject on the acceptable.

Look for the Inquire add-in, select it after which click on on OK. The Inquire tab ought to now be seen inside the ribbon.

Clean Excess Formatting

Now, to take away the surplus formatting out of your current Excel file, go to the Inquire tab and choose the Clean Excess Cell Formatting chance.

Once further formatting is eradicated, click on on Yes to keep away from losing changes and exit.

It is advisable to create a backup copy of the current file sooner than making the changes since, pretty just some numbers of cases have been reported the place the methodology had led to an increase inside the file measurement, and there was no approach to undo the change.

Read subsequent: How to get your hands on the proportion change in Excel?

Hope this helped.

Most Popular

Recent Comments