20 Excel Shortcuts to Save You HOURS of Work

20 Must-Know Excel Shortcuts

Introduction to Excel Shortcuts

• The video introduces 20 essential Excel shortcuts aimed at saving time for users frequently working with spreadsheets.

• Viewers are encouraged to download the accompanying Excel file provided in the video description.

Freezing Panes

• To keep headers visible while scrolling, use the shortcut Alt + W + F + R to freeze the top row.

• Unfreezing can be done through the "View" option by selecting "Unfreeze Panes."

Navigation Shortcuts

• Use Ctrl + Arrow Keys (up, down, left, right) for quick navigation across large datasets.

• Ctrl + Shift + Arrow Keys allows selection of multiple cells or columns efficiently.

Copying and Filling Data

• Use Ctrl + R to copy data from the left cell into the selected cell and Ctrl + D to fill down from above.

• Pressing Alt + Down Arrow shows a dropdown of previous entries for quicker data entry.

Selecting Rows and Columns

• Select an entire row using Shift + Space, and select a column with Ctrl + Space.

• Add rows with Ctrl + Shift + Plus (+) and remove them using Ctrl + Minus (-).

Moving Rows and Comments

• Move selected rows by holding shift while dragging; undo actions with Ctrl + Z.

• Add comments in cells using Shift + F2, allowing for notes on specific data points.

Navigating Large Datasets

Jumping to Specific Rows

• Quickly navigate to a specific row (e.g., row 100) using the shortcut Ctrl + G, entering the desired row number in the pop-up window.

Utilizing Templates for Efficiency

• HubSpot offers free Excel graph templates that help visualize data effectively; these templates allow easy modification of charts based on user needs.

Excel Tips and Tricks for Efficient Data Management

Using Shortcuts for Quick Data Entry

• To quickly fill in data, use Ctrl + E to auto-fill names like "Charles" or "Verstappen."

• To copy a whole column, press Ctrl + Space, then use Ctrl + C to copy. Pasting with Ctrl + V may result in zeros if the original was a formula.

Copying Values Without Formulas

• Instead of pasting formulas, use Ctrl + Alt + V to open the Paste Special dialog box and select "Values" to paste only the numbers without formulas.

Formatting Cells Efficiently

• Change currency formats (e.g., from dollar sign to British pound) using Ctrl + 1 and selecting the desired format under currencies.

• Use the F4 key to replicate formatting changes across multiple cells.

Correcting Typos in Large Datasets

• Use Ctrl + H for Find and Replace functionality to correct typos efficiently, such as fixing "Texas" with two x's.

Filtering Data Easily

• Right-click on a cell value (like Texas), go under filter options, and select "Filter by Selected Cell's Value" for quick filtering.

• Convert your dataset into a table using Ctrl + T, then insert slicers for more interactive filtering options.

Finding Top Values in Data Sets

• Use the MAX function to find the highest value; for second and third highest values, utilize the LARGE function.

Verifying Formulas in Excel

• Pressing Control + ` (accent key) reveals all formulas within cells. For tracing precedents of formulas, use Alt + T U T.