Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing data entries
Hello:
I have created a spread sheet based on year as the file folder, month as the workbook, day/date as the work sheet. with-in these parameters the worksheets in lay out are identical. If I need to make a change to a column or row heading, is there a way I can do this and have applied to all worksheets at the same time, without having to do it 365 time. also, is the a year fun ction that i can set yp that would automatically make the appropiate changes in day and date on the worksheets? thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing data entries
Mark M
For the first part, try "Grouping" your worksheets. Select the first worksheet and hold down "shift" and select the last one. What you do on one will been done on all grouped sheets. Be sure to "Ungroup" when you are finished making your adjustments. Mike Rogers "Mark M" wrote: Hello: I have created a spread sheet based on year as the file folder, month as the workbook, day/date as the work sheet. with-in these parameters the worksheets in lay out are identical. If I need to make a change to a column or row heading, is there a way I can do this and have applied to all worksheets at the same time, without having to do it 365 time. also, is the a year fun ction that i can set yp that would automatically make the appropiate changes in day and date on the worksheets? thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do have the data I'm importing look for similar entries | Excel Worksheet Functions | |||
Summing the last 7 non-blank entries in a row of data | Excel Discussion (Misc queries) | |||
Remove double data entries | Excel Discussion (Misc queries) | |||
Using Data Validation - how do I allow other entries | New Users to Excel | |||
MRU list - entries keep changing | Excel Discussion (Misc queries) |