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