Home » Computers » Software

Microsoft Excel Cheat Sheet: Tips and Shortcuts

Aug 17, 2007
Microsoft Excel is one of the most versatile programs within the Microsoft Office suite. If you are self taught and have not had any basic excel training you may not be aware of the many shortcuts available within the application. This article will provide some tips and highlight some of the many useful keyboard shortcuts to make it even quicker and easier to use.

Here are a few simple tips to make using Excel easier:

Copying content from Word
When you want to copy content from a Word document or a Web page into Excel, and you want that content to have the same formatting as what is in your spreadsheet already, double-click on the cell before pasting in the contents.

Changing rows into columns
To change rows into columns or vice versa follow the steps below:

Select the row or column you want to change

Press CTRL+C to copy it or CTRL+X to cut it

Put the cursor in the top cell where you want to transpose the contents

In the edit menu select PasteSpecial and then select Transpose.

Basic calculations without entering formulas
The AutoCalc tool in Excel will give you the results of some basic functions without you having to spend time entering formulas. If you highlight a group of figures the sum of these figures will be displayed towards the bottom right hand corner of the screen. By right clicking on this sum you have the choice of having displayed several other basic functions. The list of functions available is Average, Count, CountNums, Max, Min and Sum.

Line breaks within a single cell
When entering multiple times of text, for example an address, within a single cell you want to be able to control where the line breaks appear within this text. Pressing enter at the end of a line will just take you to the next cell down and using wrap text in combination with pressing the spacebar is very time consuming and will need correcting if you adjust the width of the cell. The easiest way to achieve this it to type the first line of text and then press ALT+ENTER. This will force an end of line at that point without taking you to the next cell.

The keyboard can often work faster than the mouse and using it can be preferable when you're in the middle of performing a number of keystrokes and don't want to waste time trying to lay your hands on the mouse.

Here is a list of quick keyboard shortcuts. Rather than trying to remember them all, why not just concentrate on the ones that you use on a regular basis.

Copying, Pasting and Deleting
Copy value from cell above CTRL+SHIFT+"
Delete to end of line CTRL+DEL
Paste CTRL+V

Border lines off CTRL+SHIFT+_
Border lines on CTRL+SHIFT+&
Underline CTRL+U

Moving within worksheets
Move left one screen ALT+PAGEUP
Move right one screen ALT+PAGEDOWN
Move to beginning of worksheet CTRL+HOME
Move to end of worksheet CTRL+END

Selecting items
Select to beginning of worksheet CTRL+SHIFT+HOME
Select to end of worksheet CTRL+SHIFT+END
Select worksheet CTRL+A
About the Author
Author is a trainer with a Microsoft Office training company, the UK industry leader in its sector. For more information on Excel training, visit http://www.MicrosoftTraining.net.
Please Rate:
(Average: Not rated)
Views: 166
Print Email Share
Article Categories
    • Artists
    • Gambling
    • Humanities
    • Humor
    • Movies
    • Music
    • Photography
    • Tattoos
    • Television
    • Classic Cars
    • Motorcycles
    • Recreational Vehicles
    • SUVs
    • Trucks
    • Vans
    • Branding
    • Business Opportunities
    • Careers and Jobs
    • Corporate
    • Customer Service
    • Direct Mail
    • Entrepreneurship
    • Ethics
    • Financing
    • Franchising
    • Home-Based Business
    • Human Resources
    • Import and Export
    • Leadership
    • Management
    • Market Research
    • Marketing and Advertising
    • Negotiation
    • Network Marketing
    • Networking
    • Organizational
    • Presentation
    • Project Management
    • Public Relations
    • Small Business
    • Strategic Planning
    • Team Building
    • Telemarketing
    • Training
    • Ask an Expert
    • College and University
    • Home Schooling
    • K-12
    • Languages
    • Online Education
    • Psychology
    • Accounting
    • Credit
    • Currency Trading
    • Debt Consolidation
    • Insurance
    • Investing
    • Leasing
    • Loans
    • Mortgage
    • Mutual Funds
    • Personal Finance
    • Stock Market
    • Structured Settlements
    • Taxes
    • Wealth Building
    • Coffee
    • Cooking
    • Gourmet
    • Recipes
    • Wine and Spirits
    • Acne
    • Aerobics
    • Alternative Medicine
    • Beauty
    • Cancer
    • Cosmetics
    • Depression
    • Diabetes
    • Diseases and Conditions
    • Fitness Equipment
    • Fitness
    • Hair Loss
    • Heart Disease
    • Medicine
    • Men's Health
    • Muscle Building
    • Nutrition
    • Skin Care
    • Supplements and Vitamins
    • Weight Loss
    • Women's Health
    • Yoga
    • Arts and Crafts
    • Babies
    • Collecting
    • Elderly Care
    • Genealogy
    • Hobbies
    • Parenting
    • Pets
    • Pregnancy
    • Woodworking
    • Feng Shui
    • Gardening
    • Home Appliances
    • Home Security
    • Interior Design
    • Landscaping
    • Affiliate Programs
    • Article Marketing
    • Auctions
    • Audio
    • Banner Advertising
    • Blogging
    • Broadband
    • Domain Names
    • E-Books
    • E-Commerce
    • Email Marketing
    • Ezines and Newsletters
    • Forums
    • Internet Marketing
    • Link Popularity
    • Pay-Per-Click
    • Podcasting
    • RSS
    • Search Engine Marketing
    • Search Engine Optimization
    • Security
    • Social Media
    • Spam
    • Video
    • Viral Marketing
    • Web Design
    • Web Development
    • Web Hosting
    • Copyright
    • Cyber Law
    • Intellectual Property
    • National, State, Local
    • Patents
    • Regulatory Compliance
    • Trademarks
    • Buying
    • Selling
    • Baseball
    • Basketball
    • Boating
    • Cycling
    • Extreme Sports
    • Fishing
    • Football
    • Golf
    • Hockey
    • Hunting
    • Martial Arts
    • Running
    • Scuba Diving
    • Soccer
    • Swimming
    • Tennis
    • Dating
    • Divorce
    • Marriage
    • Weddings
    • Astrology
    • Buddhism
    • Christianity
    • Faith
    • Hinduism
    • Islam
    • Judaism
    • Meditation
    • Metaphysical
    • New Age
    • Cable and Satellite TV
    • Cell Phones
    • Communication
    • Gadgets and Gizmos
    • GPS
    • Satellite Radio
    • Video Conferencing
    • VoIP
    • Addictions
    • Coaching
    • Goal Setting
    • Motivational
    • Stress Management
    • Time Management
    • Clothing
    • Electronics
    • Fashion
    • Gifts
    • Jewelry
    • Causes and Organizations
    • Environment
    • History
    • Holidays
    • Men's Issues
    • Nature
    • Philosophy
    • Politics
    • Women's Issues
    • World Affairs
    • Air Travel
    • Camping
    • Cruises
    • Destinations
    • Outdoors
    • Article Writing
    • Book Reviews
    • Copywriting
    • Fiction
    • Non-Fiction
    • Poetry
    • Quotes
    • Screenplay
    • Tools and Resources