Posts

About This Shortcut This shortcut toggles filters on and off for a range of data. Note: in Excel 2016, this shortcut doesn’t appear to work if slicers are on the worksheet. Related videos The videos below demonstrate this shortcut.

About This Shortcut This shortcut toggles bolding on and off for the current selection. On Windows, Ctrl 2 also toggles bolding. Related videos The videos below demonstrate this shortcut. Shortcuts to find and replace Why pivot tables? Shortcuts for formatting

Related videos The videos below demonstrate this shortcut. Shortcuts for extending selections

Related videos The videos below demonstrate this shortcut. Shortcuts for formulas How to find and highlight formulas

When theformula baris visible, this provides space to view 8 more rows. When the formula bar is hidden, this shortcut shows 10 more rows in a worksheet. We don’t know an equivalent shortcut on the Mac.

About This Shortcut This shortcut toggles italics on and off for the current selection. On Windows, Ctrl 3 also toggles italics. Related videos The videos below demonstrate this shortcut. Shortcuts for formatting Shortcuts to find and replace

Use to add or remove a field from a pivot table.

About This Shortcut This shortcut toggles Scroll Lock on and off.

About This Shortcut This shortcut toggles strikethrough formatting on and off for the current selection. Note that the Windows shortcut will also work in more recent versions of Mac Excel. The first time you use the shortcut, Strikethrough formatting will be applied. The second time you use the shortcut, Strikethrough formatting will be removed. This is what is meant by the idea of “toggling” formatting on and off. The first time applies strikethrough formatting, the second time removes strikethrough formatting....

About This Shortcut This shortcut toggles the visibility of the total row in an Excel Table. It’s equivalent to using the “Total Row” checkbox on the Table tab of the ribbon.

About This Shortcut This shortcut toggles underlining on and off for the current selection. On Windows, Ctrl 4 also toggles underlining. Related videos The videos below demonstrate this shortcut. Shortcuts for formatting Shortcuts to find and replace

If you’ve ever wondered whether learning Excel formulas is worth your time, this list is for you! Formulas are the heart of spreadsheets, so your skill with them can help you in many ways. Read below for 10 reasons you should take time to increase your skill with formulas. Formulas are important in many jobs. Formulas are a powerful way to capture and save a working solution (examples). They let you repeat the solution again whenever you like, always with perfect accuracy....

Which countries have the longest life expectancy? Here is the data used to plot this chart: How to make this chart