Select visible cells button

Select visible cells button in Excel

A common requirement when using Excel is to only copy the visible cells in a spreadsheet. So if you have a few hidden columns you may want to copy the columns around it without also copying the hidden cells. You can do this via the GOTO SPECIAL tool but it requires multiple clicks. In order to create a ‘select visible cells button’ in Excel you can one of the following steps.

Option 1: Shortcut keystrokes

Highlight the cells and click ALT & ;

Option 2: Shortcut Button

First right click in your Quick Access Toolbar (look for the undo/ redo buttons) and click on Customise Quick Access Toolbar as shown below.

Select-visible-cells-button-in-Excel

Change the option to ALL COMMANDS and then scroll down until you find the ‘Select Visible Cells’ button.

Click the Add button.
Select-visible-cells-button-in-Excel

The button will now be added to you Quick Access Toolbar and in future you can

  • highlight a group of cells,
  • click this button and
  • then click copy and only the visible cells will be copied.