Sign up for our Excel webinar, times added weekly: www.excelcampus.com/blueprint...
In this post I share 19 keyboard shortcuts for advanced Excel users. These techniques will help you save time and work sharp! You will learn how to:
1. Hide or filter out pivot items
2. Group rows and columns
3. Select visible cells
4. Show the active cell
5. Select corners of a selected range
6. Open the Go To Window
7. Find the next match or previous match
8. Enter a formula or value in all selected cells
9. Fill down or fill right
10. Copy formula text from above
11. Enter a line break in a cell
12. Modify cell styles
13. Select column or row differences
14. Select precedents and dependents
15. Open the Name Manager
16. Hide the Ribbon
17. Expand and collapse the formula bar
18. Autofit column width
19. Open the Selection Pane
If you’d like to see the accompanying blog post on my website, you can find it at this link: www.excelcampus.com/keyboard-...
Additional Resources:
7 Keyboard Shortcuts for Selecting Cells and Ranges in Excel: • 7 Keyboard Shortcuts F...
7 Uncommon Excel Shortcuts to Teach to Your Coworkers: • 7 Unique And Helpful E...
8 Keyboard Shortcuts for the VBA Editor in Excel: • 8 Awesome Keyboard Sho...
5 Keyboard Shortcuts to Paste Values in Excel: • 5 Quick Keyboard Short...
8 Keyboard Shortcuts for Number Formats in Excel (Win & Mac): • 8 Quick Keyboard Short...
#MsExcel #ExcelCampus
00:00 Introduction
00:33 Filter Out Items in Pivot Tables
01:07 Group Rows and Columns
01:36 Select Visible Cells
02:01 Show the Active Cell
02:12 Select Corners of Selected Range
02:31 Open the Go To Window
02:48 Find the Next or Previous Match
03:46 Enter Formula/Value in All Selected Cells
04:12 Fill Down
04:48 Copy Formula Text From Above
05:34 Line Breaks
06:01 Modifying Cell Style
06:31 Selecting Cells with Differences
07:08 Selecting Precedents and Dependents
08:11 Named Ranges
08:46 Expand or Collapse the Formula Bar
3 июл 2024
