Excel Visible Cells in 2007

by on
in Excel Training,Microsoft Office Training,Office Technology

 

Q. I used to use a button called Select Visible Cells in Excel 2003. I can’t find it anywhere in Excel 2007. Help!

A. In both Office 2007 and 2010, you’ll find the Quick Access Toolbar at the top left corner of all your application screens. Click on the down arrow to the right and choose More Commands. Change the Choose commands from: field to All Commands and locate Select Visible Cells. You can also use the shortcut Cells Alt+; (semi-colon).

{ 1 commentsῂ read them below or add one }

vba August 29, 2012 at 5:07 pm

Learn vlookup, excel hlookup, sumif , vba etc.We are excel consultant and access programmer with expertise in advanced Excel formulas, modeling, macros, and VBA.

Reply

Leave a Comment