[Ctrl]+[Shift]+[Page Up] Select Current And Previous Sheet In Workbook

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:

• 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:

• [Shift]+[F4] Excel Shortcut Key To Seek Easily The ‘Last Find’ Cell
• [Ctrl]+[Arrow Keys] Move To The Edge Of Next Region Cells Data Entering
• [Tab] Move One Cell To The Right / [Shift+Tab] Move To The Left-Excel