EBM Commonly Used Shortcut Keys
|
| |
|
|
|
|
| Action |
Keystroke |
|
Action |
Keystroke |
| Essential |
|
|
Formatting Cells |
|
| Toggle Screens |
Alt Tab |
|
Go into Cell |
F2 |
| Copy / Cut |
Ctrl C / Ctrl X |
|
Bold |
Ctrl B |
| Auto Sum |
Alt = |
|
Italics |
Ctrl I |
| Fill Down |
Ctrl D |
|
Underline |
Ctrl U |
| Fill Right |
Ctrl R |
|
Open Format Cells |
Ctrl 1 |
| Save |
Ctrl S |
|
General Formating |
Ctrl Shift ! |
| Anchor Cells |
F4 |
|
Currency Formating |
Ctrl Shift $ |
| Undo / Redo |
Ctrl Z / Ctrl Y |
|
Percent Formating |
Ctrl Shift % |
| |
|
|
Open Paste Special |
Ctrl Alt V |
| Auditing |
|
|
Paste Special Formulas |
Alt H V F |
| Show Formulas |
Ctrl ~ |
|
Paste Special Values |
Alt H V V |
| Go to Precedents |
Ctrl [ |
|
Paste Special Transpose |
Alt H V T |
| Go to Dependents |
Ctrl ] |
|
Open Border Selection |
Alt H B |
| |
|
|
Remove Border |
Ctrl Shift _ |
| Navigation |
|
|
|
|
| Move between Sheets |
Crtl PgUp / Ctrl PgDn |
|
Formatting Worksheet |
|
| Go To |
Ctrl G |
|
Group / Ungroup Cells |
Shift Alt à / Shift Alt ß |
| Move to Cell A1 |
Ctrl Home |
|
Highlight Row |
Shift Space |
| Move to end of current data |
Ctrl + Arrow Key |
|
Highlight Column |
Ctrl Space |
| Move to the end of your data |
Ctrl End |
|
Add Row |
Ctrl Shift + |
| Move to Last Sheet |
Hold Ctrl click right w/mouse |
|
Delete Row |
Ctrl Shift - |
| Scroll Multiple Sheets |
Hold Shift click right w/mouse |
|
Select All |
Ctrl A |
| |
|
|
Highlight to end of data |
Ctrl Shift Arrow |
| Tables |
|
|
Find (See Advance Options) |
Ctrl F |
| Add Filters |
Alt A T |
|
Hide Row |
Ctrl 9 |
| Clear Filters |
Alt A C |
|
Hide Column |
Ctrl 0 |
| Enter Dropdown Menu |
Alt Down |
|
|
|
| Select / Unselect in Dropdown |
Space Bar |
|
Other |
|
| Create Table |
Ctrl T |
|
Highlight Discontinuous Ranges |
Shift F8 |
| |
|
|
Right Click |
Shift F10 |
| |
|
|
Repeat Last Command |
Ctrl Y |
| *See full list at https://exceljet.net/keyboard-shortcuts |
|
|
|
| |
EBM Commonly Used Formulas
|
| |
|
|
|
|
| Action |
Keystroke |
|
Action |
Keystroke |
| Lookup Functions |
|
|
Lookup Functions |
|
| Returns first match in a range or an array. |
=xlookup |
|
First letter capitalized |
=Proper |
| Vertical Lookup |
=Vlookup |
|
Returns characters from the left |
=left |
| Horizontal Lookup |
=Hlookup |
|
Returns characters from the right |
=right |
| Sum if meets criteria |
=Sumif(s) |
|
Returns characters from the middle |
=mid |
| Combine cells (create uniqueID) |
=Concatenate |
|
Returns length of string |
=len |
| Combine cells |
=(cell)&(cell) |
|
Removes spaces in string |
=trim |
| |
|
|
Returns starting position |
=find |
| If Statements |
|
|
|
|
| Returns preset value if error |
=iferror() |
|
Array Formula |
|
| Returns preset value if #n/a |
=ifna() |
|
Enter any forumla array |
Requires: Ctrl Shift Enter |
| Logical If statement |
=if() |
|
Return value/ref at intersection |
=Index |
| Counts cells that meet condition |
=countif |
|
Returns relative position |
=Match |
| Greater than / less than / Equal to |
">" / "<" / ">=" / "<=" |
|
Convert horizonal to vertical |
=Transpose |
| Does not Equal |
<> |
|
Index Match |
Tutorial |
| Return Text |
"abcde" |
|
|
|
| |
|
|
|
|
| *See full list at https://exceljet.net/formulas |
|
|
|
Comments
0 comments
Article is closed for comments.