MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Time Savers

Posted by IML on April 23, 2001 11:42 AM

Sorry to be so broad, but does anyone care to share their favorite little excel time saver? Have you found something "new" that was a big help and you wondered how you lived before knowing it? A few recent "discoveries" of mine:

1) Toggle between different worksheets by right clicking on the tab scrolling buttons (cpod I think, on this board)
2) Enter a non formula date by hitting semi-colon with the control key down (Dave Hawley web site - tips and tricks)
3) Update a graph by dropping and dragging new data onto it (Mr. Excel quick answers)
4) Virtually anything under Edit - Goto - Special


Posted by Mark W. on April 23, 2001 12:09 PM

Ian, a list of all keyboard shortcuts (listed
by category) is available via the Help topic,
"Use shortcut keys in Microsoft Excel".

Posted by Barrie Davidson on April 23, 2001 1:11 PM

Here's some I use regularly.

Ctrl+Tab, to move from file to file.
Ctrl+Pageup(or PageDown), to move to different sheets within the same file.
Ctrl+Z, undo.
Ctrl+C, copy.
Ctrl+V, paste.
Ctrl+-(the minus sign), to delete a highlighted row or column.
Ctrl++(the plus sign), to insert a row or column.
Shift+Spacebar, to highlight a row.
Ctrl+Spacebar, to highlight a column.

Posted by BJ on April 23, 2001 2:19 PM

I like all the above plus anything to do with the ALT key.

Posted by Dave Hawley on April 23, 2001 11:28 PM


Here's are a few more.

To get the Syntax for a formula.
Type the formula eg; =Vlookup then push Ctrl+Shift+Enter

Go to the Insert>Names>Define

Copy the results of a filtered list
Alt+; Then Ctrl+C

If anybody comes up with vitually unknown good one I'll put it on my Website with credit to the person.


OzGrid Business Applications