Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change sheets without moving cells
Our Accountant asked me this question and what he says is that he wants to
stay in, for example, b12 in each sheet he has set up in his workbook. For example, B12 is balance and each sheet is a different branch of the bank. Can anyone help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change sheets without moving cells
Bryce
A quick way, select B12 in sheet1, then select all the sheets you want, Hold Shift and click the last sheet tab that you are interested in. Hold down Control and press Page Down to move to the sheet on the right and Page Up to move back. Otherwise write a macro and assign a shortcut key Regards Peter "Bryce Mayo" wrote: Our Accountant asked me this question and what he says is that he wants to stay in, for example, b12 in each sheet he has set up in his workbook. For example, B12 is balance and each sheet is a different branch of the bank. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving around Excel sheets | Excel Discussion (Misc queries) | |||
Arrow Keys Moving Window Frame instead of Moving Between Cells | Excel Discussion (Misc queries) | |||
have a name change cells between sheets | Excel Worksheet Functions | |||
Moving cursor to identical cells across multiple sheets | Excel Discussion (Misc queries) | |||
Moving through sheets | Excel Discussion (Misc queries) |