Category: Formatting

Go To Special

The ‘Go To’ and ‘Go To Special’ functions can help you audit your worksheet and also act as a tool to update values and make changes to your spreadsheet with the minimum fuss.   From the Home tab, they can be accessed under ‘Find & Select’ from the Editing group.     There are also Read More …

Hide gridlines in Excel

A dashboard or summary in Excel often looks smoother without the gridlines in the background, here’s how to remove them.   The quickest way to toggle between showing and hiding them is the following shortcut: Alt, W, V, G.   The ribbon equivalent is to go to the View tab and de-select Gridlines.