hintsandtips

Hints & Tips - May 2002

Using Excel a lot? These hints and tips from Sue Cooper should speed you up!! Thank you Sue.

Inserting the Date and Time

Press Ctrl + ; (semicolon) to insert the current date as set in your computer.

Press Ctrl + : (colon) to insert the current time as set in your computer.

Completing repetitive cell entries

Press Ctrl + ' (apostrophe) to repeat the cell above.

Right click a cell and choose "Pick from List" to complete a text entry in a cell.

Selecting from the Keyboard

To select a column press Ctrl + spacebar, a row Shift + spacebar and the whole workbook Ctrl + Shift + spacebar.

Deleting & Inserting Rows

To quickly delete and insert rows, first select the row (see above) and then press Ctrl and + (plus) to insert and Ctrl and - (minus) to delete.

If you have a time saving shortcut or a tip you would like to appear on this page please send it to us.