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
European Travel
Action Movies
Bible Basics
Houseplants
Romance Movies
Creativity
Family Travel


dailyclick
All times in EST

Autism Spectrum Disorders: 4: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 Words 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