Excel Shortcuts

[AlmostSmart]

Does anynoe know of really cool Excel Shortcuts?

[urysohn]

Hand your major Excel-based project off to one of the interns or students. Saves you a ton of time.

I think you'll need to be a bit more specific...Are you looking for keyboard shortcuts, nifty macros people have written...??

[urysohn]

A couple of quick keyboard shortcuts. Basic ones for the most part, but if you're not already using them they can save a ton of time....

Working with Ranges
Copy: Ctl-c
Cut: Ctl-x
Paste: Ctl-v
Paste Special - Values: /esv
Undo: Ctl-z
Redo: Ctl-y
Selecting Ranges
Shift: Anchors
Ctl - Jumps to end (keyboard)
Ctl - Additional selection (mouse)
Getting to other Sheets
Ctl-PgUp: jump to next Worksheet
Ctl-PgDn: jump to prior Worksheet
/w1 : jump to Workbook 1
Anchoring Ranges
<F4>

[Cho Da]

http://www.microsoft.com/enable/products/keyboard/keyboardsearch.asp

[Pi Man]

ctrl-F4 = close workbook
ctrl-s = save
ctrl-shift-! = comma format
ctrl-shift-$ = dollar format
ctrl-shift-1 = % format
ctrl-; = today's date (as a value)
ctrl-shift-: = time (as value)
ctrl-f = find
ctrl-h = find/replace (never did get why it's "h"...)

[Darth Tater]

"H" for "hunt" of course--OK, really I have no idea, but it makes sense to me and helps me remember what to do when I need it. :duh:

[Dr T Non-Fan]

These are great tips for the "new" (read, born before Windows/Mac) hires. Anyone around long enough to have used 1-2-3 in DOS can keep their hand off a mouse for hours at a time.

[Dr T Non-Fan]

To contribute, and not discuss my age:
F9 = recalculate
F2 = edit
Alt-T, O, C, Alt-M = change the calculation from auto to manual
Alt-Tab = switch from Forum window to other window (Oops, this is a Windows shortcut.)
More of an Alt guy than a Ctrl guy. The menu bar can be activated with the Alt key, and the drop-downs are activated by pressing the underlined letters in the menu bar. From there any underlined letter will guide you through.
For example, Alt, I, R inserts a row. No need to contort one's hands for simultaneous pressing.

[4sigma]

This is really cool, though it's not exactly a shortcut.

In Excel, open a new workbook. Use "F5" to goto the range "X97:L97". hit Tab once, then while holding down Ctrl-Shift, click the chartwizard icon on the toolbar.

Once the screen changes, you can control your direction and velocity with the mouse. Explore a bit and you'll find a shrine with the credits.

[Dr T Non-Fan]

That's called an "easter egg." Still pretty cool, though one wonders what kind of time the programmers have to do this kind of stuff.

[Numbers Nerd]

One of the best (and frequently undocumented) features in Excel is the hidden toolbar opposites. Although not every button has an opposite, many of them do. If you can use a single button to right or left align data in a cell, you wouldn't need to have both alignment buttons on the Formatting toolbar. Instead of creating additional, custom toolbars, you can remove quite a few buttons on the existing toolbars to makes additional space for other commands currently available only via the menus or keyboard shortcuts.

How does it work? When you press the Shift key and hold the mouse pointer over a button that has an opposite, the image on the button changes. Release the Shift key and the original button image displays. To avoid actually executing the button command while you're exploring the opposites, keep the mouse button held down as you drag the mouse pointer off the toolbar. Here's a list of the opposites for buttons on the Standard and Formatting toolbars:
Open - Save
Print - Print Preview
Sort Ascending - Sort Descending
Underline - Double Underline
Left Align - Right Align
Center Align - Merge and Center
Increase Decimal - Decrease Decimal
Decrease Indent - Increase Indent

To customize the Standard and Formatting toolbars to remove buttons that have opposites, choose Tools, Customize to access the Customize dialog box. You can then drag the buttons off (and new on) the toolbars. One of the commands you might add is Cells, to quickly access the Format Cells dialog box.

Additionally, there are other commands that have button opposites you might be interested in:
Insert Rows - Delete Rows
Insert Columns - Delete Columns
Paste Formatting - Paste Values
Clear Contents - Clear Formatting
Trace Dependents - Remove Dependent Arrows
Angle Text Upward - Angle Text Downward

Note - These opposite shortcuts do not extend to the keyboard. For example, Ctrl+S saves the active file. The toolbar button opposite to Save is Open - you can't press Shift+Ctrl+S to Open.

(cut from Woody's Office Watch)
EXCEL'S HIDDEN TOOLBAR BUTTON OPPOSITES ~~~~~~~~~~~~~~~~~~~
(found in Excel 5, 95, 97 and 2000) by Laura Stewart

[Ben Kenobi]

In Excel, open a new workbook. Use "F5" to goto the range "X97:L97". hit Tab once, then while holding down Ctrl-Shift, click the chartwizard icon on the toolbar.

Which version of Excel? I'm trying this in Excel 2000 with no success.

[Pi Man]

i'm in Excel97, can't do it either; sounds like a hoax

That 'opposite thing' is COOL! I knever knew that!

[Mulan]

Excel 95 did not do it either, but I really didn't expect it to....

[Numbers Nerd]

The X97:L97 easter egg is not a hoax. It worked great when I had Excel 97. By far the coolest easter egg I've ever seen.

[Pi Man]

I HAVE '97 and it's not working; am i doing something wrong??

[an2001on]

I tried and it crashed my Excel97 SR2. Lucky enough I saved my work. :roll:

[Mtl guru]

Try x2000:l2000 :)
Works for me Excel 2000

[Pi Man]

i found that if i turned OFF the Lotus transition checkbox (Tools | Options), then this thing worked. I'm one of the old throwbacks that LIKES the lotus keys ("HOME" means A1, not current row column 1; and so on)

[4sigma]

Cool, eh? I think it doesn't work if you do anything else in Excel first. You have to do it when you first open your new worksheet.

[Huki]

These are great tips for the "new" (read, born before Windows/Mac) hires. Anyone around long enough to have used 1-2-3 in DOS can keep their hand off a mouse for hours at a time.
This one prompts the best Excel shortcut of all: Use Lotus 123 instead.

[Pi Man]

These are great tips for the "new" (read, born before Windows/Mac) hires. Anyone around long enough to have used 1-2-3 in DOS can keep their hand off a mouse for hours at a time.
This one prompts the best Excel shortcut of all: Use Lotus 123 instead.

ewwww... not even funny...

[Elisha]

I think this was the second time I did the "flight simulator" in Excel, but the first time I got the mouse/plane to pretty much hover on the credits. Hilarious.

It starts out something like: "At first there was nothing. Then there was Excel 97. And some nachos. Well, there were other versions. ..." You've got to read it sometime.

[Numbers Nerd]

Boot Excel 2000
Under file menu, do 'Save as Web Page'
Say 'Publish Sheet' and 'Add Interactivity'
Save to some htm page on your drive.
Load the htm page with IE. You should have Excel in the middle of the page.
Scroll to row 2000, column WC. Select row 2000, and tab so that WC is the active column.
Hold down Shift+Crtl+Alt and click the Office logo in the upper-left.
If you have DirectX, you will be playing what looks like spy hunter. Use the arrow keys to drive, space to fire, O to drop oil slicks, and when it gets dark, use H for your headlights.

(requires DirectX)

[Elisha]

Boot Excel 2000
Under file menu, do 'Save as Web Page'
Say 'Publish Sheet' and 'Add Interactivity'
Save to some htm page on your drive.
Load the htm page with IE. You should have Excel in the middle of the page.
Scroll to row 2000, column WC. Select row 2000, and tab so that WC is the active column.
Hold down Shift+Crtl+Alt and click the Office logo in the upper-left.
If you have DirectX, you will be playing what looks like spy hunter. Use the arrow keys to drive, space to fire, O to drop oil slicks, and when it gets dark, use H for your headlights.

(requires DirectX)

I must try that when I get home. 2000 at home, 97 at work.

[whisper]

One of the short cuts I use often is the "F4" key while editing formulas. It changes the cell reference to absolute references and back.

[Kitten]

I use <ctrl>-<shift>-<arrow key> all the time. Start at the top of a column of cells and hit <ctrl>-<shift>-<down arrow> and it selects the continuous cells including and below the cell you are in. I also like <ctrl>-<arrow key> to take me to the end of a row or column. :)

[sleg]

This is the most complete list of shortcuts I have seen. They also have a VERY cool set of utilities that you can download. I don't know how I would get by without it! http://www.asap-utilities.com/

[Gates Is Antichrist]

http://www.asap-utilities.com/
Thanks for what appears to be a great tip!

I would also note that his "Useful Links" on the lower right are definitely not clunkers (for a rare and refreshing change IMNSHO). cpearson, ozgrid, and j-walk are semi-famous among VBA junkies like myself; and his next 2 links could possibly be valuable for anyone (though I can't vouch for them).

[peabrain]

Regarding the X97:L97 easter egg, I recall having to do this immediatly after launching excel. That may help. I dont think that you have to restart the computer, but I'm not sure, I cant remember, my name is peabrain. I do recall the sermon on the mount stating somethin like: "In the begining there was nothing, well there was pizza...."

[Pi Man]

no need to reboot for it to work. Also, you can exit the simulator by hitting 'escape'.

[wtt]

A couple of quick keyboard shortcuts. Basic ones for the most part, but if you're not already using them they can save a ton of time....

Working with Ranges
Copy: Ctl-c
Cut: Ctl-x
Paste: Ctl-v
Paste Special - Values: /esv
Undo: Ctl-z
Redo: Ctl-y
Selecting Ranges
Shift: Anchors
Ctl - Jumps to end (keyboard)
Ctl - Additional selection (mouse)
Getting to other Sheets
Ctl-PgUp: jump to next Worksheet
Ctl-PgDn: jump to prior Worksheet
/w1 : jump to Workbook 1
Anchoring Ranges
<F4>
They are short-cuts for other Microsoft Office product as well.

[Phil]

Does anyone know a keyboard shortcut for toggling "Wrap Text" for a cell? I use this constantly but I don't see a link to it even in the Customize Toolbars dialogs. It's 3 keys plus a careful mouse click to do it manually.

Thanks.

[Old Timer]

3 Keys? the mouse?

Ctrl-1, then depending on which tab was used last, it could be some number of ctrl-pgup or ctrl pgdn, then alt-w.