Excel Tips, Tricks and Shortcuts

Microsoft Excel Blog | Avantix Learning

Check out our Excel training courses >

How to Freeze Row and Column Headings in Excel Worksheets

How to Freeze Row and Column Headings in Excel Worksheets

As many Excel worksheets can become quite large, it can be useful to freeze row and column headings or freeze panes so titles are locked in place when you scroll through your worksheet. In Excel, you can freeze both row headings and column headings or just one.

How to Insert Multiple Rows in Excel (4 Fast Ways with Shortcuts)

How to Insert Multiple Rows in Excel (4 Fast Ways with Shortcuts)

You can quickly insert multiple rows in Excel using the context menu, keyboard shortcuts or the Home tab in the Ribbon. The key to inserting multiple rows at once, rather than one by one, is to select the number of rows you want to insert first and then insert rows. Excel will insert the same number of rows you selected.

3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells

3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells

You can apply strikethrough to text or values in Excel to cross out or create a line through a cell or part of a cell. There are 3 common ways to apply strikethrough in your Excel worksheets – using a built-in keyboard shortcut, using the Font dialog box, or by adding a command to the Quick Access Toolbar.

How to Move a Pivot Table in Excel

How to Move a Pivot Table in Excel

Moving a pivot table is not as simple as moving other objects in an Excel worksheet or workbook. You will typically need to use the Move PivotTable command in the Ribbon to move a pivot table to a different area on a worksheet or to a different sheet in the same workbook.

Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.

Avantix Learning |18 King Street East, Suite 1400, Toronto, Ontario, Canada M5C 1C4 | Contact us at info@avantixlearning.ca

Summary
Article Name
Excel Tips and Tricks | Excel Training | Avantix Learning
Author
Publisher Name
Avantix Learning

Pin It on Pinterest