Solved

Excel - Keys to move across sheets

Posted on 2011-02-25
3
236 Views
Last Modified: 2012-08-13
Hi,

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

Thank you
0
Comment
Question by:tahirih
3 Comments
 
LVL 85

Accepted Solution

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

Assisted Solution

by:David_Hagerman
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

by:KnutsonBM
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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

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…

708 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now