Go To Special

Go To Special is a somewhat neglected, but sometimes very useful option that allows us to position ourselves in individual places in an Excel table according to their properties. These can be empty rows, formulas, precedents, dependents, cells with data validation, etc. In this text, you will learn how to start this option, and you will also see two examples of its application in practice.

The easiest way to start the Go To Special option is to first call its “older sister”, the Go To option, by pressing the F5 key or using the CTRL+G combination. After that, in the lower left corner of the window, you need to click on the Special button. Alternatively, we can do this from the Home ribbon, by selecting appropriate option from the Find & Select menu.

After you start this option, a dialog window will appear in which you need to select the property of the cells you want to select. Properties can be constants (constant values, such as numbers or text), formulas, empty cells, objects, precedents, dependents… By selecting options and then clicking OK, we will position ourselves above the cells that have the required properties.

Let’s see how this works in practice. Start the Go To Special option and then select the display of constants, then numbers. After confirming the selection, only those cells in the table with numbers will be selected.

How to delete all empty rows in a table? Select the table and then start the Go To Special option. Select Blanks. With this action you will select all empty rows. Further, it is enough to run the delete rows option and all empty rows will be deleted.