| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select multiple worksheets in Excel 2007 | Excel Discussion (Misc queries) | |||
| select multiple criteria multiple worksheets | Excel Worksheet Functions | |||
| multiple column comparison on 2 worksheets | Excel Worksheet Functions | |||
| Add last cell in last column of multiple worksheets? | Excel Discussion (Misc queries) | |||
| select lines from multiple worksheets and write to new worksheet | Excel Worksheet Functions | |||
Linear Mode
