Excel Dictionary
Excel Dictionary

@exceldictionary

7 Tweets 2 reads Dec 07, 2022
5 Excel Shortcuts I bet you didnโ€™t know but should.๐Ÿ˜‰
A Thread: ๐Ÿ’ฏ
1. CTRL SHIFT \
Tired of manually filtering and selecting unique values within a column? Try selecting the column and hitting CTRL SHIFT \. The CTRL SHIFT \ shortcut selects the cells within the column that don't match the active cellโ€™s value (or formula).
2. F8
Never click and drag to extend your selection again. F8 locks the selected cells and adds all adjacent cells to the current selection using the arrow keys. This adds adjacent cells to the current selection without using the mouse.
3. CTRL SHIFT [
Tracing cells referenced in formulas can be like finding a needle in a haystack. Save yourself the hassle, and use this shortcut. CTRL SHIFT [ finds and selects all of the cells directly and indirectly referenced in the active cell's formula.
4. CTRL SHIFT F
Need to quickly adjust fonts throughout your spreadsheet? Meet CTRL SHIFT F, you're new 'go-to' for all your font formatting needs. CTRL SHIFT F opens the Font tab of the Format Cells dialog box. This tab is used to control the selected cells' font attributes.
5. CTRL ALT 5
Ditch the mouse when selecting worksheet objects using these keys! CTRL ALT 5 automatically selects the first object in the worksheet. To select all the objects in your worksheet, press CTRL SHIFT SPACEBAR after CTRL ALT 5.
Objects include charts, images, etc.
To learn even more unique shortcuts, check out the Excel Dictionary Shortcut Guide containing over 330+ other invaluable shortcuts!
The guide also comes with a shortcut dictionary with full definitions, dialog box functionalities, and more!
Shop๐Ÿ‘‰bit.ly

Loading suggestions...