What are your favorite keyboard short cuts?

[SydneyGeek]

IT won't buy a proper graphics programm for me - "no justifiable business case" is their argument.

Yeah, it's often hard to make a justifiable business case for being more productive. Usually makes someone else look bad...

Denis

 

[Pete Suzzgood]

Re: Keyboard shortcut to make a [maximized] window switch monitors?

Does anyone know if it's possible to move a window to another monitor without having to manually [unmaximize,] drag over with mouse or slowly move over with arrow keys [, then re-maximize]? That would be awesome. Thanks either way,

zack
Windows XP
Excel 2003 SP2
<!-- / message -->

 

[Blade Hunter]

Re: Keyboard shortcut to make a [maximized] window switch monitors?

One of my faves it CTRL-`

Switch between formula and result view.

 

[TheBroker]

Re: Keyboard shortcut to make a [maximized] window switch monitors?

Lots of them

Alt + E + A + A - Clear all selected data

Alt + E+A+F - Clear all formats

Alt + I + R/C - Insert row/column

Alt + W+V+G - Remove gridlines

Alt + H+H+N - Clear formatting
Alt + H + FF/FS - Change font style or size.

Ctrl + Minus - Delete row/column
Shift + Space - Select row
Ctrl + space - Select column
Ctrl + Enter - A really handy formula to fill cells
Ctrl+ Shift + 1/2/3/4/5 - Change number formatting
Ctrl + F1 - Show/Hide Ribbon
Alt + O + H + R - Rename sheet
Shift + F11 - Insert sheet
Alt + E + L - Delete sheet

 

[Nalani]

Here's a link to a whole list of just about every shortcut you can think of, put out by David McRitchie 10 years ago but updated just last month (as stated at the bottom)

http://www.mvps.org/dmcritchie/excel/shortx2k.htm

 

[TroyYoung]

My favorites are as follows,

-Windows Key + D *returns you to desktop

-Windows Key + M *Minimises all windows if pressed again it will reopen all windows great for when the boss walks past

-Windows Key + R *opens to run command prompt

-Windows Key + E *Opens windows Explorer


None of the above really have anything to do with Excel but are very handy shortcuts when especially the D and M ones.

 

[Michael M]

The one that I depend on a lot:
Ctrl + C followed by
Alt + ESV for pasting values only.

As well as all those that have come before....if I can remember them when I need them.

Regards
Michael M

 

[JLouis]

I read on the site once where there is a shortcut to run a workbook open event and see the changes you have made to the code without opening and closing the workbook. Anyone remember what that one was?

 

[Long Nose]

I would like to mention a seemingly undocumented feature in Excel 2003: you can copy a selection "as a picture" by holding down the shift key while clicking on the Edit menu item.
You will then see a choice to "Copy Picture...", right below the Cut option in the dropdown menu list. This can be advantageous whenever, say, you are pasting into a Powerpoint slide and some of your pasted object is cut off (all to frequent an occurrence!).

Is there a MS Excel 2007 equivalent?

 

[pgc01]

Is there a MS Excel 2007 equivalent?

Yes, but you copy as Picture using the paste button

- select an object or a range
- press the Paste dropdown and, at the end, you see "As Picture" where you have the Copy as Picture.

That's also where you then have the Paste As Picture, but this time it's where you would expect it to be.