ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Keeping cursor in same place on all worksheets in a workbook (https://www.excelbanter.com/excel-worksheet-functions/61721-keeping-cursor-same-place-all-worksheets-workbook.html)

Phil Burgess

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?

Vito

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



All times are GMT +1. The time now is 03:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com