logo
g Text Version
Beauty & Self
Books & Music
Career
Computers
Education
Family
Food & Wine
Health & Fitness
Hobbies & Crafts
Home & Garden
Money
News & Politics
Relationships
Religion & Spirituality
Sports
Travel & Culture
TV & Movies

dailyclick
Bored? Games!
Nutrition
Postcards
Take a Quiz
Rate My Photo

new
Action Movies
Bible Basics
Houseplants
Romance Movies
Creativity
Family Travel
Southwest USA


dailyclick
All times in EST

Low Carb: 8:00 PM

Full Schedule
g
g Desktop Publishing / Ebooks Site

BellaOnline's Desktop Publishing / Ebooks Editor

g

Common Keyboard Shortcuts for Excel

Guest Author - Chris Curtis

If you become practiced at using keyboard shortcuts, you will find that your proficiency in Excel will improve and your work will be accomplished more quickly. These keyboard techniques are called shortcuts because they take less time to execute a command then using the mouse to click on an icon or selecting a menu command. One way to make using shortcuts a habit is to start by selecting one or two commands that you use frequently and instead of reaching for the mouse, use the short cut instead. Once those have become a habit, select a couple more.

Open a New Document
• Press CTRL+N

Open an existing document
• Press CTRL+O – Launches Word’s Open Dialog Box Default Folder (usually My Documents)

Close a document
• Press CTRL+W

Save a document
• Press CTRL+S

Copy
• Select cell or range of cells or object to be copied.
• Press CTRL+C

Cut
• Select cell or range of cells or object to be cut.
• Press CTRL+X

Paste
• Activate cell where copied or cut text is to be placed.
• Press CTRL+V

Bold
• Select range of cells to make bold.
• Press CTRL+B

Italicized
• Select range of cells to make italicized.
• Press CTRL+I

Underline
• Select range of cells to make underlined.
• Press CTRL+U

Open the Go To Dialog Box
• Press F5

Open the Go To Dialog Box
• Press CTRL + G

Open the Find Dialog Box
• Press CTRL + F

Open the Replace Dialog Box
• Press CTRL + H

Select Column
• Press CTRL+SPACEBAR
• Note Active cell must be in the column you wish to select

Select Row
• Press SHIFT +SPACEBAR
• Note Active cell must be in the row you want to select

Select Range of Cells
• Activate the 1st cell in the range where you want to begin the selection
• Hold the shift key down
• Click in the last cell of the range selection (lower right hand corner)

Select All (entire document)
• Press CTRL+A


Undo the last action
• Press CTRL+Z

Redo the last action
• Press CTRL+Y

Print
• Press CTRL+P

Print Preview
• Press Alt+F
• Press V

Create a Bar Chart
• Select range of data to be charted
• Press F11

Go to beginning of the row
• Press Home

Go to Cell A1
• Press CTRL + Home


Add Common+Keyboard+Shortcuts+for+Excel to Twitter Add Common+Keyboard+Shortcuts+for+Excel to Facebook Add Common+Keyboard+Shortcuts+for+Excel to MySpace Add Common+Keyboard+Shortcuts+for+Excel to Del.icio.us Digg Common+Keyboard+Shortcuts+for+Excel Add Common+Keyboard+Shortcuts+for+Excel to Yahoo My Web Add Common+Keyboard+Shortcuts+for+Excel to Google Bookmarks Add Common+Keyboard+Shortcuts+for+Excel to Stumbleupon Add Common+Keyboard+Shortcuts+for+Excel to Reddit




Using Named Ranges (Excel)
Controlling Pagination - Excel
Eight Ways to Add Numbers in Excel
RSS
Related Articles
Editor's Picks Articles
Top Ten Articles
Previous Features
Site Map


For FREE email updates, subscribe to the Desktop Publishing / Ebooks Newsletter


Past Issues


print
Printer Friendly
bookmark
Bookmark
tell friend
Tell a Friend
forum
Forum
email
Email Editor


Content copyright © 2014 by Chris Curtis. All rights reserved.
This content was written by Chris Curtis. If you wish to use this content in any manner, you need written permission. Contact Laura Nunn for details.

g


g features
Becoming a Fiction Editor

Making a Background Transparent Using Photoshop

Merging Letters in Word 2007

Archives | Site Map

forum
Forum
email
Contact

Past Issues
memberscenter


vote
Poetry
Daily
Weekly
Monthly
Less than Monthly



BellaOnline on Facebook
g


| About BellaOnline | Privacy Policy | Advertising | Become an Editor |
Website copyright © 2014 Minerva WebWorks LLC. All rights reserved.


BellaOnline Editor