Select all of a certain column across multiple worksheets

  • Thread starter Thread starter Charles Belov
  • Start date Start date
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
 
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
 
Back
Top