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
tahirihAsked:
Who is Participating?
 
RunriggerCommented:
Note, it will not move to the bottom of each "used" range if the depth of the used range is different on each sheet.

Just the same cell on all sheets.
0
 
RunriggerCommented:
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
0
 
tahirihAuthor Commented:
Yes, I am seeking the latter, I use a brush key stroke to get to the last cell that is filled in a range.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.