Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keeping cursor in same place on all worksheets in a workbook
I am a lotus 123 user currently struggling with excel
I would like to set a workbook so that the cursor stays in the same relative position on all worksheets of the workbook as I move from one to another - a function that exists in Lotus (worksheet/link) Can this be done? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keeping cursor in same place on all worksheets in a workbook
Click on the first sheet's tab and then while holding down the Shift key, click on the last sheet. All the tabs in your range should be white. Now you can create formulas, etc in all those sheets at once. -- Vito ------------------------------------------------------------------------ Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182 View this thread: http://www.excelforum.com/showthread...hreadid=495744 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protecting all worksheets of a workbook | Excel Discussion (Misc queries) | |||
How do I build a workbook from the worksheets another workbook? | Excel Discussion (Misc queries) | |||
how do i link a list of items in a workbook to worksheets in the . | Excel Discussion (Misc queries) | |||
Removing links to other worksheets from within a workbook | Excel Discussion (Misc queries) | |||
One header for all worksheets in workbook | Excel Discussion (Misc queries) |