Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm currently working on a sheet tracking cash over/short in a register. I've
made 52 sheets (1 per week). The sheets contains the same information. If one of the crew quits I have to erase the person from all the sheets, and the other way around if we hire a new person. how do I change all at the same time? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Select sheet 1, then hold down Alt and Shift keys and select Sheet 52....this
will highlight both sheets and ALL the sheets in between..........then just make the change on the one sheet and all will follow........click off to another sheet to deselect... hth Vaya con Dios, Chuck, CABGx3 "brasch" wrote: I'm currently working on a sheet tracking cash over/short in a register. I've made 52 sheets (1 per week). The sheets contains the same information. If one of the crew quits I have to erase the person from all the sheets, and the other way around if we hire a new person. how do I change all at the same time? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change date based on time | Excel Discussion (Misc queries) | |||
Can series tool change formulas over time when used to copy them | Excel Worksheet Functions | |||
change format for time value | Excel Discussion (Misc queries) | |||
HOW CAN I CHANGE SET-UP ON MULTIPLE SHEETS AT 1 TIME? | Setting up and Configuration of Excel | |||
Calculate change over time | Excel Worksheet Functions |