?
Solved

Excel Workbook - Cursor Move All Sheets

Posted on 2011-02-22
3
Medium Priority
?
259 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:tahirih
  • 2
3 Comments
 
LVL 11

Expert Comment

by:Runrigger
ID: 34953044
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
 
LVL 11

Accepted Solution

by:
Runrigger earned 2000 total points
ID: 34953052
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
 

Author Comment

by:tahirih
ID: 34953085
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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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.

Join & Write a Comment

Usually, rounding is performed by some power of 10 - to thousands, hundreds, tens, or integer - or to one, two, or more decimals. But rounding can also be done to a power of two, say, 16 or 64, or 1/32 or 1/1024, even for extreme values.
Excel allows various different methods to link Excel files to each other. This includes relative paths, mapped drives (or the local drive) and UNC paths. UNC paths are the least robust of the three.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question