What are your favorite keyboard short cuts?

[Smitty]

alt 0163

Too bad it's a pisser to get it to work on a laptop without a 10-key pad!

 

[Jon von der Heyden]

On wide sheets,
Alt+PgUp
Alt+PgDn

I also use Go To special a lot, so
ALT+E+G+S+O (for constants)
ALT+E+G+S+F (for formulas)

F3 to bring up the Name list when writing formulas

Alt+F8 to run a macro

Ctrl+* to select a region on the worksheet

There are others, but many have already been quoted earlier...

Denis

Hi Denis
You can use F5 to go to the GoTo dialog instead of ALT+E+G

For me the most valuable is CTRL+S. You won't believe how many of my colleagues frequently lose work because they fail to save!
My next favourite is F1 for a littlle help along the way. Esppecially in the VBE, where it automatically pops up on the subject based on the word selected in the coode pane.

 

[SydneyGeek]

Hi Denis
You can use F5 to go to the GoTo dialog instead of ALT+E+G

For me the most valuable is CTRL+S. You won't believe how many of my colleagues frequently lose work because they fail to save!
My next favourite is F1 for a littlle help along the way. Esppecially in the VBE, where it automatically pops up on the subject based on the word selected in the coode pane.

Hi Jon,

Yep -- I know about F5 too but you know the thing about old habits...

There's some good stuff in this thread -- could be a candidate for a sticky.

Denis

 

[kgkev]

I hate the F1 short cut. I have a slow machine and help takes a while to load. I seem to knock it regulaly.

I have added this macro to my personal.xls!

Private Sub Workbook_Open()
    Application.OnKey "{F1}", ""
End Sub

I use
Ctrl + Shift + arrow keys most.
as well as Alt + Mouse click to select multiple cells.


Also Windows + D , Windows+R & Windows+E are my most used not excel shortcuts

 

[arkusM]

I'm sure this will be outdated soon, but I wanted a list for my benefit.
So I am sharing, thanks everyone for these great gems!
- Mark

Sheet1

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma,Arial; BACKGROUND-COLOR: #fffbf0" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 76px"><COL style="WIDTH: 443px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="TEXT-ALIGN: right">Modifier 1</TD><TD style="TEXT-ALIGN: right">Modifier 2</TD><TD style="TEXT-ALIGN: center">Key</TD><TD>Description</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="TEXT-ALIGN: right">Alt</TD><TD style="TEXT-ALIGN: right">Shift</TD><TD style="TEXT-ALIGN: center">=</TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="TEXT-ALIGN: right">Alt</TD><TD style="TEXT-ALIGN: right">Space</TD><TD style="TEXT-ALIGN: center">x</TD><TD>maximize window</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: right">Shift</TD><TD style="TEXT-ALIGN: center">0</TD><TD>Unhide Row</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: right">Shift</TD><TD style="TEXT-ALIGN: center">8</TD><TD>Select used Range</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: right">Shift</TD><TD style="TEXT-ALIGN: center">9</TD><TD>Unhide Column</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: right">Shift</TD><TD style="TEXT-ALIGN: center">#</TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: right">Shift</TD><TD style="TEXT-ALIGN: center">+</TD><TD>Insert cell</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: right">Shift</TD><TD style="TEXT-ALIGN: center">Arrow</TD><TD>Select data to end of </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD> </TD><TD style="TEXT-ALIGN: right">Alt</TD><TD style="TEXT-ALIGN: center">;</TD><TD>Select Visible Cells only</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD> </TD><TD style="TEXT-ALIGN: right">Alt</TD><TD style="TEXT-ALIGN: center">=</TD><TD>Adds Sum Formula</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD> </TD><TD style="TEXT-ALIGN: right">Alt</TD><TD style="TEXT-ALIGN: center">down arrow</TD><TD>Drop box list of data</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD> </TD><TD style="TEXT-ALIGN: right">Alt</TD><TD style="TEXT-ALIGN: center">E G S F</TD><TD>Select Formulas (hit keys in sequence)</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD> </TD><TD style="TEXT-ALIGN: right">Alt</TD><TD style="TEXT-ALIGN: center">E G S O</TD><TD>Select Constants (hit keys in sequence)</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD> </TD><TD style="TEXT-ALIGN: right">Alt</TD><TD style="TEXT-ALIGN: center">F11</TD><TD>Open/Switch to VBE Editor</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">18</TD><TD> </TD><TD style="TEXT-ALIGN: right">Alt</TD><TD style="TEXT-ALIGN: center">F4</TD><TD>Close the window/Quit the Application</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">19</TD><TD> </TD><TD style="TEXT-ALIGN: right">Alt</TD><TD style="TEXT-ALIGN: center">F8</TD><TD>Macro Names</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">20</TD><TD> </TD><TD style="TEXT-ALIGN: right">Alt</TD><TD style="TEXT-ALIGN: center">Tab</TD><TD>Change to another open application</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">21</TD><TD> </TD><TD style="TEXT-ALIGN: right">Alt</TD><TD style="TEXT-ALIGN: center">0163</TD><TD>yields: £</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">22</TD><TD> </TD><TD style="TEXT-ALIGN: right">Alt</TD><TD style="TEXT-ALIGN: center">0128</TD><TD>yields: €</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">23</TD><TD> </TD><TD style="TEXT-ALIGN: right">Alt</TD><TD style="TEXT-ALIGN: center">0222</TD><TD>yields: Þ</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">24</TD><TD> </TD><TD style="TEXT-ALIGN: right">Crtl</TD><TD style="TEXT-ALIGN: center">[</TD><TD>Goto referenced cell</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">25</TD><TD> </TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: center">1</TD><TD>Cell Format</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">26</TD><TD> </TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: center">-</TD><TD>Delete cell</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">27</TD><TD> </TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: center">*</TD><TD>Select Used Range</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">28</TD><TD> </TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: center">;</TD><TD>Adds today's data (no formula)</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">29</TD><TD> </TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: center">+</TD><TD>Insert cell (without shift for keypad use)</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">30</TD><TD> </TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: center">a</TD><TD>Select all</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">31</TD><TD> </TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: center">c</TD><TD>Copy</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">32</TD><TD> </TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: center">D</TD><TD>Copy Down</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">33</TD><TD> </TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: center">End</TD><TD>Goto last used cell</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">34</TD><TD> </TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: center">Home</TD><TD>Goto Cell A1</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">35</TD><TD> </TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: center">n</TD><TD>New file</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">36</TD><TD> </TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: center">o</TD><TD>Open file</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">37</TD><TD> </TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: center">PageDwn</TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">38</TD><TD> </TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: center">PageDwn</TD><TD>Goto column right</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">39</TD><TD> </TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: center">PageUp</TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">40</TD><TD> </TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: center">PageUp</TD><TD>Goto column left</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">41</TD><TD> </TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: center">R</TD><TD>Copy Right</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">42</TD><TD> </TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: center">S</TD><TD>Save</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">43</TD><TD> </TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: center">Space</TD><TD>Select entire Column</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">44</TD><TD> </TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: center">v</TD><TD>Paste</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">45</TD><TD> </TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: center">w</TD><TD>Close file</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">46</TD><TD> </TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: center">x</TD><TD>Cut</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">47</TD><TD> </TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: center">y</TD><TD>Redo</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">48</TD><TD> </TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: center">z</TD><TD>Undo</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">49</TD><TD> </TD><TD style="TEXT-ALIGN: right">Ctrl</TD><TD style="TEXT-ALIGN: center">~</TD><TD>Show formulas</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">50</TD><TD> </TD><TD style="TEXT-ALIGN: right">Shift</TD><TD style="TEXT-ALIGN: center">F11</TD><TD>New sheet to work Book</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">51</TD><TD> </TD><TD style="TEXT-ALIGN: right">Shift</TD><TD style="TEXT-ALIGN: center">Menu Item</TD><TD>(Sans Excel 2007) Alternate options for menu bar buttons</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">52</TD><TD> </TD><TD style="TEXT-ALIGN: right">Shift</TD><TD style="TEXT-ALIGN: center">Space</TD><TD>Select entire row</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">53</TD><TD> </TD><TD style="TEXT-ALIGN: right">Windows</TD><TD style="TEXT-ALIGN: center">e</TD><TD>Opens Windows Explorer</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">54</TD><TD> </TD><TD style="TEXT-ALIGN: right">Windows</TD><TD style="TEXT-ALIGN: center">d</TD><TD>Shows Desktop</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">55</TD><TD> </TD><TD style="TEXT-ALIGN: right">Windows</TD><TD style="TEXT-ALIGN: center">r</TD><TD>displays the "run" Dialog</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">56</TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: center">F5</TD><TD>"Goto" Dialog Box</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">57</TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: center">F9</TD><TD>Calculate</TD></TR><TR style="HEIGHT: 51px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">58</TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: center">F9</TD><TD style="TEXT-ALIGN: left">High light part of a formula in a cell and hit F9 to see the result,
then esc to keep the formula. WARNING hitting enter will hard
code the result. </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">59</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 85px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">60</TD><TD> </TD><TD> </TD><TD> </TD><TD>Copying formats from one column to the next:
Select the source column
Click the paintbrush
Click the right arrow (to copy formats right) etc.
- Double clicking "format painter" allow multiple uses of the format</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">61</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 68px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">62</TD><TD> </TD><TD> </TD><TD> </TD><TD>Multiple entry:
Select some cells
Enter a value or formula
Ctrl+Enter</TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

 

[Greg Truby]

I've never understood why they put both [windows]+D (desktop) and [windows]+M (minimize all). It seems redundant. I've also taken to using [windows]+L (lock screen) since we have a few wiseguys in the office that - if you leave your machine unlocked - have been known to hop on to your unprotected machine and send out e-mails with messages like "I feel like a pretty pink ballerina today!"

 

[arkusM]

I've never understood why they put both [windows]+D (desktop) and [windows]+M (minimize all). It seems redundant. I've also taken to using [windows]+L (lock screen) since we have a few wiseguys in the office that - if you leave your machine unlocked - have been known to hop on to your unprotected machine and send out e-mails with messages like "I feel like a pretty pink ballerina today!"

Doh! Busted.

 

[Domski]

As another non-Excel one Ctrl+Escape is one I use to bring up the Start menu, probably redundant in Vista.

Dom

 

[Oaktree]

Having been yet unable to find a keyboard shortcut to increase/decrease the number of decimals, I use the sequence:

CTRL+SHIFT+!
CTRL+1
Alt + d
0
Enter

to get the #,##0 number format a lot

Also, Shift + F9 to recalc only the active sheet is great for ad hoc models flooded with lookup functions

 

[kgkev]

I've never understood why they put both [windows]+D (desktop) and [windows]+M (minimize all). It seems redundant. I've also taken to using [windows]+L (lock screen) since we have a few wiseguys in the office that - if you leave your machine unlocked - have been known to hop on to your unprotected machine and send out e-mails with messages like "I feel like a pretty pink ballerina today!"

Pressing Windows+D again returns all screens to the previous state.

Windows + M Doesn't


We have a server running windows 2000 and Win+L doesn't work. I forget every time I go to walk away.