Home |
Search |
Today's Posts |
#1
|
|||
|
|||
i want to edit the same information in ten different files
I have 20 different worksheets. Each week I want to change the date in all
the worksheets. Is there an easier way than to individually change each and every worksheet. I am very new to excel so simple instructions would be great. |
#2
|
|||
|
|||
Us a formula that points back to the one primary cell:
A formula like: ='sheet 1'!a1 or even =if('sheet 1'!a1="","",'sheet 1'!a1) If the cells on each worksheet have the same address, you could group those sheets (select the first and ctrl-click on the subsequent worksheet tabs). Then just change it once. But be careful. Any change you make to any of these grouped sheets will be made to all the sheets in the group. Just rightclick on one of the grouped sheets and select ungroup sheets when you're done. (Excel tries to remind you by adding [Group] in the title bar.) caroline wrote: I have 20 different worksheets. Each week I want to change the date in all the worksheets. Is there an easier way than to individually change each and every worksheet. I am very new to excel so simple instructions would be great. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I am unable to edit a comment in excel | Charts and Charting in Excel | |||
Automatic update of information in a spreadsheet | Excel Discussion (Misc queries) | |||
Scan and edit document in excel 2003. | Excel Discussion (Misc queries) | |||
Sharing information between Access and Excel | Excel Discussion (Misc queries) | |||
How to switch to edit the cell | Excel Discussion (Misc queries) |