Print

Training >> Browse Articles >> MS Office

+2

Five Top Tips for Excel

Mike Seddon

Like many users of Excel, I’ve found a few really useful features which I use quite often.

Here are my top five.

Keyboard Shortcuts

Try the following Excel keyboard shortcuts. They can really make your life easier.

Ctrl + A — Select all cells
Ctrl + Home — Go to cell A1
Ctrl + End — Go to last cell in the range
Ctrl+ Shift+ End — Select from active cell to last cell in the range
Ctrl+Shift+Home — Select from active cell to A1
Ctrl + Page Down — Go to next worksheet
Ctrl + Page Up — Go to previous worksheet

Speed copying in Excel

To quickly copy a cell across a row or down a column simply select the cell you want to copy and then move the mouse cursor until it is placed above the bottom right corner of the cell. The cursor will turn to a plus (+) sign.

Now hold down the left mouse button and drag across either the row or column until you have selected all the cells you want to paste into. Release the button and your first cell will be copied to all the chosen cells.

Instant Charts in Excel Spreadsheets.

Fancy a quick chart from a table of figures in Excel?

It’s so easy. Just select any of the cells in the table of numbers and press F11.

Try experimenting with it. It’s a fast easy way to get a quick chart.

Headers and Footers on Excel Spreadsheets.

Did you know you can print your Excel spreadsheets with Headers and Footers?

Simply click on the File menu and select Page Setup. Now select the Header/Footer tab. Try experimenting with the Custom Header and Custom Footer options as well.

Quick calculator in Excel

How many times have you been working in Excel and you have reached for the calculator in Windows — usually to check something Excel is telling you!

Earn Your Administrative Degree!

Campus or Online Programs
Featured Opportunity

An administrative degree can help you develop skills and help you pursue your dreams, so why not get started? Our degree finder can help you find programs online and in your area.

Get more information

So, why not put a button in Excel which will fire up the calculator for you?

Simply select View/Toolbars/Customize in Excel.

On the Customize screen, select the Commands tab and then select Tools from the Categories list.

Back to more Microsoft Excel Help

About the Author:

Mike Seddon is one of the founders of Kutchka. Their mission is to make life easier in the office by providing tools which help you get the best out of Microsoft Office. Each week through their newsletter they provide free tips for Microsoft Office users. Why not sign up yourself at http://www.kutchka.com


AdminSecret School Finder

Save time in your search for a degree program. Use AdminSecret's School Finder to locate schools online and in your area.


* In the event that we cannot find a program from one of our partner schools that matches your specific area of interest, we may show schools with similar or unrelated programs.

Recent Activity

Photo_user_blank_big
romanico received the quiz result of "21-50% correct: Good effort", 4 months ago.
Photo_user_blank_big
tmiller received the quiz result of "Satisfactory", 4 months ago.
003_max30
new2admin gave a thumbs down to The Article "6 Ways Finding a Dream Job Is Like Finding Your Soul Mate", 4 months ago.
Photo_user_blank_big
kinsh1987 received the quiz result of "Legal Secretary ", 4 months ago.
Contactphoto-img_20141211_175940_max30
LoraJ commented on: "Lora Coats", 5 months ago.