Wednesday, November 03, 2004
Sheet Shortcuts in Excel
Some great shortcuts to working with sheets in Excel.
Moving between sheets
CTRL + PGUP / PGDN
To find a particular sheet
Right click the sheet navigation arrows (at the far left of the sheet name tabs). This will bring up a list of all the sheet names. If there are more sheets then can fit in the list then a More Windows option will provide you with a dialog box to select from.
Copy sheets
Hold down CTRL, then drag a sheet tab right 1 sheet or left 2 sheets to copy it. A small plus will appear beside the mouse cursor indicating a new sheet will be created.
Rename sheet
Double click the sheet tab to edit the name.
Select multiple sheets
Hold down SHIFT whil using the CTRL +PGUP/PGDN shortcut.
Comprehensive list of Excel shortcuts
The Excel Guru's Free Tips and Hints.
Welcome
Welcome to the Excel Tips blog. Free Microsoft Excel Tips and Hints designed to increase your productivity.
Advertisement
Subscribe Me
Previous Posts
- Add spaces to a string in Excel using REPT functio...
- Excel Workbook Open Read Only Recommended
- VBA code to Unhide Sheets in Excel
- Using the F5 Function key
- Count the number of Unique Items in a Range
- Creating Drop Down Lists Using Validation
- Convert Text to Values and Values to Text
- Dynamic Range Names
- XDate Extended Date Functions Add-In
- Protect and Unprotect Sheets Macro
My Blogs and Websites
- Spy Journal Home
- Spy Journal Archives
Personal Blog- Excel Tips Blog
- Blog Tips Blog
- Tech Tips Blog
- Urban Space Novel
- Photo Archive
- Parklife Results
- Parklife Soccer Club Website
- KROSTech LAN Parties
- Jethro Management
- Jethro Consultants
- Oz Bush Poet
Excel Links
- ---RSS Feeds---
- Unofficial Microsoft Office Stuff
- KC on Exchange and Outlook
- Office Zealot
- Automate Excel
- Colo's Excel Junk room
- Daily Dose Of Excel
- The Planning Deskbook
- Excel Pragma
- Andrew's Excel Tips
- ---No RSS Feed---
- Excel Tip
- Mailbarrow
- Experts Exchange
- AJP Excel Information
- Beyond Technology
- Contextures
- ExcelTip
- Mr Excel
- Pearson Software Consulting
- Peltier Technical Services
- John Walkenbach - J-Walk
- Vangelder (wont work in Firefox)
- VBA Express
- xlDynamic
- The Excel Nexus
- Code Net
- Better Solutions
- Excel Business Tools
- Data Pig Technologies
- VBA Express
Other Links
Copyright Notice. All documents and text contained in this web site www.spyjournal.biz and sub pages is copyright material of Jethro Management (c) 2004 unless noted as being copyright material of someone else. No public reproduction of the content on this site in any form is permitted without express written permission.
Unless otherwise expressly stated, all original material of whatever nature created by Tim Miller and included in this weblog and any related pages, including the weblog's archives, is licensed under a Creative Commons License.