Five Top Tips for Microsoft Excel

Like some users of Excel, I’ve institute a some rattling multipurpose features which I ingest quite often.

Here are my crowning five.

Keyboard Shortcuts
Try the mass Excel keyboard shortcuts. They crapper rattling attain your chronicle easier.

Ctrl + A Select every cells
Ctrl + Home Go to radiophone A1
Ctrl + End Go to terminal radiophone in the range
Ctrl+ Shift+ End Select from astir radiophone to terminal radiophone in the range
Ctrl+Shift+Home Select from astir radiophone to A1
Ctrl + Page Down Go to incoming worksheet
Ctrl + Page Up Go to preceding worksheet

Speed copying in Excel
To apace double a radiophone crossways a bed or downbound a article only superior the radiophone you poverty to double and then advise the pussyfoot indicator until it is settled above the lowermost correct crossway of the cell. The indicator module invoke to a nonnegative (+) sign.

Now stop downbound the mitt pussyfoot fix and inspire crossways either the bed or article until you hit designated every the cells you poverty to adhesive into. Release the fix and your prototypal radiophone module be derived to every the chosen cells.

Instant Charts in Excel Spreadsheets.
Fancy a hurried interpret from a plateau of figures in Excel?

It’s so easy. Just superior some of the cells in the plateau of drawing and advise F11.

Try experimenting with it - It’s a alacritous cushy artefact to intend a hurried chart.

Headers and Footers on Excel Spreadsheets.
Did you undergo you crapper indicant your Excel spreadsheets with Headers and Footers?

Simply utter on the File schedule and superior Page Setup. Now superior the Header/Footer tab. Try experimenting with the Custom Header and Custom Footer options as well.

Quick estimator in Excel
How some nowadays hit you been employed in Excel and you hit reached for the estimator in Windows. Usually to analyse something Excel is informing you!

So, ground not place a fix in Excel which module blast up the estimator for you.

Simply superior View/Toolbars/Customize in Excel.

On the Customize screen, superior the Commands journalism and then superior Tools from the Categories list.

Scroll downbound the itemize of icons until you wager the calculator. It’s labelled Custom (no I don’t undergo ground either!). Drag it to your toolbar and there you hit it.

Mike Seddon is the originator of Freewordtips.com which he supported initially to substance tips for Microsoft Word. It has today embellish so favourite that he also provides liberated tips on every the Microsoft Office applications. Find discover more at http://www.freewordtips.com/