Excel Tips, Tricks and Shortcuts
Microsoft Excel Blog | Avantix Learning
How to Convert Pounds to Kilograms or Kilograms to Pounds in Excel (kg to lb)
You can convert pounds to kilograms (lb to kg) or kilograms to pounds using formulas with operators or functions in Excel.
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 Delete Blank Rows in Excel (5 Fast Ways to Remove Empty Rows)
You can delete blank rows in Excel using several tricks and shortcuts. Check out these 5 fast ways to remove blank or empty rows in your worksheets.
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.
How to Hide Rows and Columns in Excel (including Unused Rows and Columns)
You can hide rows and columns in Excel using the context menu, using a keyboard shortcut or by using the Format command on the Home tab in the Ribbon. If you have hidden rows or columns, you can unhide them as well.
How to Delete a Pivot Table in Excel
A pivot table can be deleted in an Excel workbook in several ways. You can delete a pivot table, convert a pivot table to values or clear data and customizations from a pivot table to reset it. When a pivot table is created from source data in a workbook,
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 Enter Data in an Excel Filtered List into Visible Cells (2 Ways)
It’s a common issue for Microsoft Excel users to attempt to use AutoFill to fill data in a filtered list and it doesn’t work as expected. The fill data is entered into all cells, including the hidden or invisible cells. The solution is to enter data into visible cells only …
How to Convert Text to Numbers in Excel (5 Ways)
Here are 5 different ways to quickly convert numbers stored as text to numbers in a Microsoft Excel worksheet. You can use a Smart Tag, Paste Special or …
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 | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | info@avantixlearning.ca