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.

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

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.

Inquire Tab

Most Popular

Muscular Dystrophy Association’s Let’s Play For A Cure targets gamers

The Muscular Dystrophy Association is launching a multi-week livestreaming event, Let’s Play For A Cure, to raise money for the charitable group from gamers. The...

HaptX wins $1.5 million NSF grant to create full-body haptics for VR

Virtual reality headsets are already advanced enough to make your brain believe you’re moving through an artificial 3D space, but VR hardware makers are...

Seismic raises $92 million to automate sales processes

Seismic, a startup developing a sales enablement and market orchestration platform, today raised $92 million at a valuation of $1.6 billion. (That’s up from...

Lenovo’s ThinkPad X1 Fold is a foldable PC that starts at $2,500

Editor's take: Hardware makers have been experimenting with bendable displays for close...

Recent Comments