| Like many users of Excel, I've found a few really | | | | Instant Charts in Excel Spreadsheets. |
| useful features which I use quite often. | | | | Fancy a quick chart from a table of figures in Excel? |
| Here are my top five. | | | | It's so easy. Just select any of the cells in the table of |
| Keyboard Shortcuts | | | | numbers and press F11. |
| Try the following Excel keyboard shortcuts. They can | | | | Try experimenting with it It's a fast easy way to get a |
| really make your life easier. | | | | quick chart. |
| Ctrl + ASelect all cells | | | | Headers and Footers on Excel Spreadsheets. |
| Ctrl + HomeGo to cell A1 | | | | Did you know you can print your Excel spreadsheets |
| Ctrl + EndGo to last cell in the range | | | | with Headers and Footers? |
| Ctrl+ Shift+ EndSelect from active cell to last cell in the | | | | Simply click on the File menu and select Page Setup. |
| range | | | | Now select the Header/Footer tab. Try experimenting |
| Ctrl+Shift+HomeSelect from active cell to A1 | | | | with the Custom Header and Custom Footer options |
| Ctrl + Page DownGo to next worksheet | | | | as well. |
| Ctrl + Page UpGo to previous worksheet | | | | Quick calculator in Excel |
| Speed copying in Excel | | | | How many times have you been working in Excel and |
| To quickly copy a cell across a row or down a column | | | | you have reached for the calculator in Windows. |
| simply select the cell you want to copy and then move | | | | Usually to check something Excel is telling you! |
| the mouse cursor until it is placed above the bottom | | | | So, why not put a button in Excel which will fire up the |
| right corner of the cell. The cursor will turn to a plus (+) | | | | calculator for you. |
| sign. | | | | Simply select View/Toolbars/Customize in Excel. |
| Now hold down the left mouse button and drag | | | | On the Customize screen, select the Commands tab |
| across either the row or column until you have | | | | and then select Tools from the Categories list. |
| selected all the cells you want to paste into. Release | | | | Scroll down the list of icons until you see the calculator. |
| the button and your first cell will be copied to all the | | | | It's labelled Custom (no I don't know why either!). Drag it |
| chosen cells. | | | | to your toolbar and there you have it. |