If you have many worksheets in your workbook, then you want to select the current sheet as a base sheet and go to any previous particular sheet.
As far as I know, the common way is to use a mouse pointer clicking on the current worksheet, press the “Ctrl” key button, and then move a mouse pointer to click on the “Sheet tabs” of worksheet, as you need.
However, Excel program has a trick that allows you to get the same thing as mentioning above. It is a shortcut way, which there are the three keys on the keyboard combine together for making it out.
Shortcut key step by step:
• Press the [Ctrl] key and hold down
• Press the another key [Shift] button and hold down too
• Press the [Page Up] key button
• Release all the three key buttons
That is alright. Does that help and meet to your sake?
Benefit:
Please be noted that:
See more tip:
As far as I know, the common way is to use a mouse pointer clicking on the current worksheet, press the “Ctrl” key button, and then move a mouse pointer to click on the “Sheet tabs” of worksheet, as you need.
However, Excel program has a trick that allows you to get the same thing as mentioning above. It is a shortcut way, which there are the three keys on the keyboard combine together for making it out.
Shortcut key step by step:
• Press the [Ctrl] key and hold down
• Press the another key [Shift] button and hold down too
• Press the [Page Up] key button
• Release all the three key buttons
That is alright. Does that help and meet to your sake?
Benefit:
- Save time.
- Shorter way.
- Best for select from the first selected Excel worksheet and go to the previous worksheet consequently. There is No way to jump from one worksheet to another worksheet.
Please be noted that:
When this shortcut key works on the Excel worksheets, you can see the “Sheet tabs” being indicated by transparency.
Function Key
|
Result Description
|
|---|---|
[Ctrl]+[Shift]+[Page Up]
| Excel Shortcut Key Select The Current And Previous Sheet In A Workbook. |
See more tip:
Comments
Post a Comment