subject: Top 10 Secrets of Microsoft excel spreadsheet, Tips and Tricks [print this page] 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).
