Link to home
Start Free TrialLog in
Avatar of tahirih
tahirih

asked on

Excel Workbook - Cursor Move All Sheets

Hi,

I have a workbook open, with about 100 sheets. Is there a way to select all of them, and then have a keystroke on one sheet that will transfer to all (e.g. Ctr down to move to the bottiom of the row)

Thank you
Avatar of Runrigger
Runrigger
Flag of United Kingdom of Great Britain and Northern Ireland image

Right click on one of the tabs and select the "Select Al Sheets" option.

When ever you make a move on the emoboldened sheet (the active one), the cursor will move to exactly the same position on all other sheets
ASKER CERTIFIED SOLUTION
Avatar of Runrigger
Runrigger
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tahirih
tahirih

ASKER

Yes, I am seeking the latter, I use a brush key stroke to get to the last cell that is filled in a range.