Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 23rd 05, 04:45 AM
boyd
 
Posts: n/a
Default 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   Report Post  
Old May 23rd 05, 04:16 PM
CLR
 
Posts: n/a
Default

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   Report Post  
Old May 23rd 05, 10:10 PM
Gord Dibben
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Expanding conditional formating with reference cells changing CCoop Excel Discussion (Misc queries) 2 May 4th 05 02:36 PM
Extracting data from multiple worksheets into a list mnirula Excel Worksheet Functions 16 February 25th 05 08:52 PM
copying cells from other worksheets yesbob Excel Discussion (Misc queries) 1 February 7th 05 05:18 PM
How to sum values in multiple worksheets Robert Lawrence Excel Worksheet Functions 3 January 29th 05 05:15 AM
Countif with multiple criteria and multiple worksheets JJ Excel Worksheet Functions 1 December 28th 04 06:37 PM


All times are GMT +1. The time now is 11:31 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017