|
Move or copy a sheet to another book |
| Print | |
E-mail |
|
Wednesday, 24 May 2006 14:07 |
|
Go to Edit > Move or Copy sheet and then select the book you would like to move or copy to.
|
|
Change the autocorrect settings |
| Print | |
E-mail |
|
Wednesday, 24 May 2006 14:01 |
|
To change the autocorrect settings, go to Tools > AutoCorrect Options.
|
|
Turn off automatic calculation of formulas |
| Print | |
E-mail |
|
Wednesday, 24 May 2006 13:50 |
|
Go to Tools > Options > Calculation and click on Manual under the Calculation section. From that point onwards, hen you then wish to calculate press F9.
|
|
Check your worksheet for errors |
| Print | |
E-mail |
|
Wednesday, 24 May 2006 13:40 |
|
Go to Tools > Error Checking and your sheet will be checked for errors.
|
|
Wednesday, 24 May 2006 13:38 |
|
Go to Format > Cells, click on the Border tab and choose your border type.
|
|
Rename a worksheet |
| Print | |
E-mail |
|
Wednesday, 24 May 2006 13:27 |
|
Go to Format > Sheet > Rename to rename your current worksheet.
|
|
Wednesday, 24 May 2006 11:54 |
|
To sort data, select the cells you would like to sort, and then go to Data > Sort and select how you would like the data to be sorted.
|
|
Keyboard shortcut: Edit a cell comment |
| Print | |
E-mail |
|
Wednesday, 24 May 2006 11:33 |
|
Press Shift + F2 while a cell is selected to edit a cell comment.
|
|
Keyboard shortcut: Insert an Autosum formula |
| Print | |
E-mail |
|
Wednesday, 24 May 2006 11:27 |
|
Press Alt + = to automatically start off a sum formula.
|
|
Keyboard shortcut: Cancel a current entry |
| Print | |
E-mail |
|
Wednesday, 24 May 2006 11:23 |
|
To cancel your current entry, press Esc.
|
|
Keyboard shortcut: Inserting the current date |
| Print | |
E-mail |
|
Thursday, 18 May 2006 08:11 |
To insert the current date
CTRL + SEMICOLON (;)
|
|
Move to the next/previous sheet |
| Print | |
E-mail |
|
Wednesday, 17 May 2006 16:11 |
Press Ctrl + Page Down to move to the next sheet.
Press Ctrl + Page Up to move to the previous sheet.
|
|
Work in full screen |
| Print | |
E-mail |
|
Wednesday, 17 May 2006 16:03 |
If you want more room to work on your spreadsheet, simply click on View > Full Screen.
|
|
Insert a diagram into your spreadsheet |
| Print | |
E-mail |
|
Wednesday, 17 May 2006 15:58 |
Click on Insert > Diagram... then select a diagram type from the diagram gallery.
|
|
Insert a row/column |
| Print | |
E-mail |
|
Wednesday, 17 May 2006 15:54 |
Right click on the row number/column letter where you would like to insert a new one, then click on Insert Cell and a cell will be inserted before/above the cell you selected.
|
|
Alter the size of a row/column |
| Print | |
E-mail |
|
Wednesday, 17 May 2006 15:49 |
Hover over the seperator between the row/column you wish to alter (the mouse cursor will change to a seperator with arrows either side of it), then simply hold down the left mouse button and drag in whichever direction you wish to expand that row/column.
|
|
Content prediction |
| Print | |
E-mail |
|
Wednesday, 17 May 2006 15:44 |
If you have entered a number, or the date into a cell, and would like to increment this by 1 for every cell thereafter, then select the cell and in the bottom right hand corner of it there is a small black square. Hover over this and hold down the left mouse button and drag it down or to the right for as many cells that you wish to let Excel fill in, then simply let go of the left mouse button and all the hard work is done for you.
|
|
Cell formatting |
| Print | |
E-mail |
|
Wednesday, 17 May 2006 15:38 |
Right click a single cell, a row, or even a column and click Format Cells. This allows you to style a cell, row or column with a particular font or data type (e.g. currency).
|
|
Keyboard shortcut: Enter the date into a cell |
| Print | |
E-mail |
|
Friday, 07 April 2006 11:41 |
|
To enter the date into a cell on your worksheet, press Ctrl and ; (semicolon).
|
|
Keyboard shortcut: Insert a new worksheet |
| Print | |
E-mail |
|
Friday, 07 April 2006 11:37 |
|
To insert a new worksheet into your Excel document, press Shift and F11.
|
|
|
|
|
