Monday, April 27, 2009

Select visible cells only in Excel 2007

There are two ways to do this. If you don't need to use it much, then you can get to it directly through the links on the menu. On the Home tab, go to "Find & Select" on the right. In that menu, select "Go To..." Click "Special..." Here is where you can choose the "Visible cells only" option. Click OK, and that will select the visible cells only. This method is also outlined in Microsoft help pages, and can be found here.

If you need to do this often, going through all of those steps may get annoying. The good news is that you can create a shortcut for it on your quick access menu. To do this, right-click on the menu bar and select "Customize Quick Access Toolbar...". In the "Choose command from:" drop down list, change the option to "All Commands". This will show all available shortcuts that you can place in your toolbar. Scroll down in that list to find the "Select Visible Cells" shortcut, which looks like 4 black boxes. Select it, then click Add>>. This will add it to your quick access toolbar. Now click OK. Look in the upper-right and you should now see the visible cell selection shortcut icon next to the save, undo, and redo links in the quick access toolbar. You can use this same method to add (or remove) additional shortcuts to your toolbar.

1 comment:

Alper Paksoy said...

Thank you very much. I had somehow missed previously that this shortcut could be added to the quick access toolbar.

Alper