Home |
Search |
Today's Posts |
#1
|
|||
|
|||
changing cells in multiple worksheets
can i change a cell (say i9:) which is a date in 1-13-02 format to january
13, 2002 format in multiple worksheets within a folder |
#2
|
|||
|
|||
Select the cell you wish to change, then hold down Ctrl button and left-click
on all the sheet tabs you wish the change to affect. Then re-format the cell as normally done and it will change on all the sheets you have highlighted. Vaya con Dios, Chuck, CABGx3 "boyd" wrote: can i change a cell (say i9:) which is a date in 1-13-02 format to january 13, 2002 format in multiple worksheets within a folder |
#3
|
|||
|
|||
boyd
"Worksheets in a folder" Worksheets are in workbooks. If this is what you mean then Chuck has your answer. Workbooks(files) are in folders. If this is what you mean, you will have to open each workbook, do your formatting, save and close. You could use VBA to open all workbooks one at a time and do your stuff. See Ron de Bruin's site for code to open workbooks in a folder and work on each. http://www.rondebruin.nl/copy3.htm Gord Dibben Excel MVP On Sun, 22 May 2005 20:45:01 -0700, "boyd" wrote: can i change a cell (say i9:) which is a date in 1-13-02 format to january 13, 2002 format in multiple worksheets within a folder |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Expanding conditional formating with reference cells changing | Excel Discussion (Misc queries) | |||
Extracting data from multiple worksheets into a list | Excel Worksheet Functions | |||
copying cells from other worksheets | Excel Discussion (Misc queries) | |||
How to sum values in multiple worksheets | Excel Worksheet Functions | |||
Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions |