Select all of a certain column across multiple worksheets

C

Charles Belov

Is there an easy way to simultaneously select (or do a find-and-replace) on
column H on every worksheet of an entire multi-sheet workbook, without
having to select that column on each individual worksheet by hand?

Charles Belov
SFMTA Webmaster
http://www.sfmta.com/webmaster
 
G

Gord Dibben

Right-click on first sheet tab and "Select all sheets"

In activesheet select the column............will be selected on all sheets.


Gord Dibben MS Excel MVP
 
Top