5 Excel Shortcuts I bet you didnโt know but should.๐
A Thread: ๐ฏ
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).
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.
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.
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.
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.
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.
Loading suggestions...