Solved

Excel - Keys to move across sheets

Posted on 2011-02-25
236 Views
Hi,

Please confirm the key stroke to move across worksheets in Excel 2007. Forward and backward from worksheets

Thank you
0
Question by:tahirih

LVL 85

Accepted Solution

Rory Archibald earned 167 total points
ID: 34979054
Ctrl+PageUp and PageDown
0

LVL 7

Assisted Solution

David_Hagerman earned 167 total points
ID: 34979058
Ctrl Pg UP and Pg Down will page between sheets, here are a couple more keys as well

http://www.online-tech-tips.com/ms-office-tips/switch-between-worksheets-excel/
0

LVL 6

Assisted Solution

KnutsonBM earned 166 total points
ID: 34979061
Ctrl+Pg Down and Ctrl + Pg Up

See this site for more hotkeys:

http://office.microsoft.com/en-us/excel-help/excel-shortcut-and-function-keys-HP010073848.aspx
0

Featured Post

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…