Hello all and welcome to this week's Tip, a Basic User post on some useful spreadsheet navigation shortcuts. As a reminder, the weekly Tips are usually posted in the Excel Community blog, but one Tip a month is cross-posted here as a sample of the kind of content that's available.
There are many keyboard shortcuts that speed up the process of navigating around a workbook. Try these out:
Previous post - Filters TOTW indexNext post - Tables (basics) This blog is brought to you by the Excel Community where you can find additional blogs, extended articles and webinar recordings on a variety of Excel related topics. In addition to live training events, Excel Community members have access to a full suite of online training modules from Excel with Business. There is also an online forum where you can ask questions and share ideas with other community members.
Here's some beautiful keys...
Ctrl + Home - Takes you straight to A1 (or top left when you sues freeze panes)
Ctrl + End - Takes you to the bottom right corner - just luverly.... (This used to be Ctrl + End then Home but in 2010 is just Ctrl + End)
Also hold down Shift and use the arrows to highlight a block of cells. Most of these also work in Word (which is of course an awful -program mostly to be avoided) and the Web.
Ctrl + arrows will jump along a line a word at a time and then you can use shift and arrows to highlight and select. All of that then leads you too...
Ctrl + X - Cut
Ctrl + C - Copy
Ctrl + V - Paste
Not to mention ALT + Tab to switch between windows....