Thread by @FluentInFinance

12 must-know Microsoft Excel shortcuts so you never use a mouse again! Don't use Excel again without knowing these 12 shortcuts:

1) Formatting Shortcuts:

• Ctrl + Shift + $ (currency format)
• Ctrl + Shift + % (percent format)
• Ctrl + Shift + # (date format)
• Ctrl + B A (bold format)
• Ctrl + I (italic format)
• Ctrl + U (underline format)
• Ctrl + 5 (strike format)
• Ctrl + 1 (format cells box)

2) Pivot Table Shortcuts:

• ALT + N + V (create pivot table)
• ALT + J + T + L (view/Hide Field List)
• Alt + H, S, C (unhide / clear filter on an item)

3) Display Formulas in cells:

• Ctrl + ~

Example:
If you have a cell that contains a formula, you can use Ctrl + ~ to switch between the formula view and the value view of the cell. This allows you to see the underlying formula used to calculate the cell value.

4) Repeat the Last Action:

• Ctrl + Y

Example:

You have just applied a formatting style to a cell, use Ctrl + Y to quickly apply the same formatting to another cell.

5) Insert current date / Insert current time:

• Ctrl + ; (date)
• Ctrl + Shift + ; (time)

Example: When tracking the progress of a project, add the date each time a task is completed. Use Ctrl + ; to quickly insert the current date.

6) Autosize columns:

• Alt + H + O + I

Example:

If you have multiple columns, and some of the columns contain text or numbers that are too wide to display in full, then use Alt + H + O + I to quickly adjust the width of the columns to display the full content of the cells.

7) AutoSum:

• Alt + =

Example:
The AutoSum shortcut is useful for quickly calculating the sum of a range of cells without having to manually type in the formula

8) Move Between Workbook Sheets:

• Ctrl + Page Up
• Ctrl + Page Down

Examples:
This allows you to quickly move between sheets in a workbook, without having to manually click on each sheet tab.

This saves time compared to manually clicking on each sheet tab to navigate.

9) Move Between Different Workbooks:

• Ctrl + Tab

Example:
This shortcut allows you to quickly switch between different Excel workbooks that are open on your computer, allowing you to reference data from each as needed.

10) Freeze Panes- Rows & Columns:

• Alt + W + F + F

Example:

If you have data with headers in the top row, and you want to keep the headers visible while scrolling, use Alt + W + F + F to freeze the top row, so the headers remain visible while scrolling through the data.

11) Fill down / Fill right:

• Ctrl + D (down)

Example: This is useful for quickly copying data or formulas from the top cell to the cells below.

• Ctrl + R (right)

Example: This is useful for quickly copying data or formulas from the leftmost cell to the cells to the right.

12) Insert a hyperlink:

• Ctrl + K

Example:
This shortcut is useful for quickly creating a hyperlink to a website, file, or another location in your spreadsheet.

Microsoft Excel is an important skill in today's job market. If you found this thread helpful, please:

• RT the FIRST tweet to share it🔁
• Follow me @FluentInFinance for more
• Sign-up for my FREE newsletter to learn more valuable skills: TheMoneyNewsletter.com!