F5 key in Excel

F5 key in Excel

March 13, 2022 0 Door Bjorn Meijer

The F5 key in Excel is a bit of a neglected child within Excel. The possibilities behind this key are very useful, but often unknown.

The F5 key has already been discussed in the post for the delete empty rows.

In this post we will look at several examples that allow you to perform complex actions in a simple way with the F5 key.

Empty overwritten template

Suppose you keep a weekly record of your energy levels in an Excel document, but you accidentally worked in the template and did not save an empty copy of it. If you are not aware of the operation of the F5 key, this can (depending on the size of the template) be a hell of a job to empty the template. This can be done easily with the F5 key.

Window F5 (Go to)
Window F5 (Go to)
  1. Make a copy of the template and save it somewhere you can find it.
  2. Press the F5 key (Go to).
  3. Press the button sspecial.
  4. Select the option Cinstants and select the option Gstalls.
  5. click on OK and all cells with numbers are selected. Cells with formulas, texts, etc. are not selected.
  6. Press the Delete key and your template is empty again.
Empty template using hotkey F5
Empty template using hotkey F5

Remove all comments from worksheet

Comments in cells are identified by the red triangle in the top right corner of a cell. Do you have a worksheet that you want to remove the comments from in a worksheet? Then proceed as follows:

  1. Press the F5 key (Go to).
  2. Press the button sspecial.
  3. Select the option remarkgand.
  4. Press the button OK.
  5. Right-click on a selected cell.
  6. From the shortcut menu, choose the option onmremove acknowledgments.
Delete comments using F5
Delete comments using F5

As you can see in the F5 key (Go To) window, there are many options to select from. With the help of this selection it is again possible to perform other operations.