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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Naming ranges on multiple worksheets 3
Auto transfer data rows to other sheets when certain entries occur 7
Copying Selective Data Between Worksheets 5
Inserting Columns Across Multiple Worksheets 4
add new data to specific columns in multiple worksheets 2
Prevent worksheet selection 2
Macro to format multiple worksheets 24

Top