Select all of a certain column across multiple worksheets
 

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

Select all of a certain column across multiple worksheets
 

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

On Mon, 24 Aug 2009 16:43:02 -0700, "Charles Belov"
wrote:

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