Top 10 Secrets of Microsoft excel spreadsheet, Tips and Tricks

Top 10 Secrets of Microsoft excel spreadsheet

, Tips and Tricks

Keyboard Shortcuts When it comes to Excel keyboard shortcuts are something which when learnt once goes a long way to save your precious time while working on Excel spreadsheets. Say for example, 1) When you want to select all cells all you need to do is press Ctrl + A. 2) In case you wish to go to cell A1 then you need to hit Ctrl + Home. 3) Similarly, when you want to go to the last cell in the range we press Ctrl + End. 4) When you wish to select from active cell to last cell in the range hit Ctrl+ Shift+ End. 5) Conversely in case you want to Select from active cell to A1 just press Ctrl+Shift+Home 6) When you want to go to next worksheet simply press Ctrl + Page Down. 7) Similarly, when you want to go to previous worksheet hit Ctrl + Page Up. Speed copying in Excel

If you seek to speed up copying a cell across a row or down a column you need to select the desired cell which needs to be copied. After that you move the mouse cursor till the time it relocates itself above the bottom right corner of the cell. Now you'll see that the cursor changes into a + sign. Then you need to hold down the left mouse button and drag it across either the row or column till the time all the cells you want to paste into are already selected. You'll see that if you release the button now your first cell will now be copied to all the selected cells.

Instant Charts in Excel Spreadsheets

Ok this very sweet. If you want to make a chart from a given table in Excel simply select the required cells in the table of numbers and hit F11. Presto we now have a chart!

Headers and Footers on Excel Spreadsheets

It is not rare known fact that we can print header and footer in an Excel spreadsheet. For that we need to click on the File menu and select Page Setup and then go to the Header/Footer tab. It can be customized to our fancy.

Quick calculator in Excel

Don't you think that Alt + Tabbing between you Excel sheet and your calculator is a royal pain? What if you could import a calculator in your Excel sheet itself? Won't that be amazing! All you need to do is select View, then go to Toolbars and select Customize in Excel. When you reach the Customize screen, choose the commands tab after that select Tools from Categories list. You can scroll down the list of icons till the time you find the calculator. For some strange reason it is labeled as Custom there but don't worry about it. You can drag it to your Toolbar; it is now set for your convenience.

Excel Skills Society is a movement started by Excel pros (located globally) with the aim of demystifying MS-Excel and its many power-packed features, and enhancing workplace productivity of every Excel pro (or, amateur).

POST COMMENT

Tips to Help You Find A Good Job Tips for PC Driver Updates with the Quickest Free Way lithium battery care and use tips Tips On Choosing Plastic Frames Glasses More Tips to Get White Teeth that Insanely White Tips to Avoid Holiday Weight Gain and Still Enjoy the Treats Tips On How To Choose A Proper Istd Leotard 4 Critical Tips You Must Know To Help Burn Belly Fat Fast Five Tips For Improving A Direct Mailing Campaign Hydration Tips For Glowing Skin Check Out Incredible MLM Sponsoring Tips Now Notebook Battery Tips Tips to Install a Motion Detector on a Light