blog:11_very_useful_excel_keyboard_shortcuts_you_may_not_know
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
blog:11_very_useful_excel_keyboard_shortcuts_you_may_not_know [2009-06-14 08:54] – created brb | blog:11_very_useful_excel_keyboard_shortcuts_you_may_not_know [2009-06-14 08:58] (current) – brb | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== 11 very useful | + | ====== 11 Very useful |
- | - f4 key - During formula typing, adjusts the reference type, abs to relative, otherwise repeats last action | + | |
- | - ctrl key+; key - Inserts current date | + | These shortcuts will save you many trips the excels menu |
+ | |||
+ | ===== ===== | ||
+ | |||
+ | - F4 - During formula typing, adjusts the reference type, abs to relative, otherwise repeats last action | ||
+ | - ctrl key+; - Inserts current date | ||
- ctrl key+ - Copies value from cell above to current cell | - ctrl key+ - Copies value from cell above to current cell | ||
- | - shift+f2 key - Edits a cell comment | + | - shift+F2 - Edits a cell comment |
- | - alt+f8 key - Opens macro dialog box | + | - alt+F8 - Opens macro dialog box |
- | - alt+= key - Auto sum selected cells and places value in cell beneath | + | - alt+= - Auto sum selected cells and places value in cell beneath |
- | - ctrl+shift+$ | + | - ctrl+shift+$ - Currency formats current cell |
- ctrl+shift+& | - ctrl+shift+& | ||
- ctrl+shift+! - Comma formats current cell | - ctrl+shift+! - Comma formats current cell | ||
- | - shift+ctrl+f | + | - shift+ctrl+f - Activates font drop down list |
- | - shift+ctrl+p | + | - shift+ctrl+p - Activates font point size drop down list |
Source: http:// | Source: http:// | ||
- | {{tag>}} | + | {{tag>excel}} |
~~LINKBACK~~ | ~~LINKBACK~~ | ||
~~DISCUSSION~~ | ~~DISCUSSION~~ | ||
blog/11_very_useful_excel_keyboard_shortcuts_you_may_not_know.txt · Last modified: 2009-06-14 08:58 by brb