Excel Tips, Tricks and Shortcuts

Microsoft Excel Blog | Avantix Learning

How to Fill Blank Cells in Excel (with Zeros, Dashes or Other Values)

You can quickly fill blank cells in a range of data in Excel with dashes, zeros or other number or text values. Blank cells can be problematic if you want to use a data set as the source for a pivot table.

How to Convert Cm to Inches in Excel (or Inches to Cm)

You can convert cm to inches (or inches to cm) using formulas with operators or functions in Excel. This is useful since the regional settings on a computer affect the default measurement system used in Excel and other programs.

How to Hide Comments or Notes in Excel Workbooks

You can hide comments and notes in Excel workbooks. In addition to adding comments in Excel, there is a little known function called the N function that you can use to enter notes directly within a formula. The N function has been around for a long time so you can use it in older versions of Excel.

How to Delete Blank Rows in Excel (5 Ways)

You can delete blank rows in Microsoft Excel worksheets manually or you can use several tricks to remove multiple blank rows quickly. Check out 5 different ways to easily delete blank rows in your data.

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 Change Commas to Decimal Points and Vice Versa in Excel (5 Ways)

Depending on your country or region, Excel may display decimal points or dots instead of commas for larger numbers. The decimal point (.) or comma (,) is used as the group separator in different regions in the world. You can change commas to decimal points or dots or vice versa in your Excel workbook temporarily or permanently.

How to Group by Month and Year in a Pivot Table in Excel

You can group by month, year or other date period in a pivot table in Excel. One option is to group by date periods in a pivot table using the Grouping feature. Alternatively, you can also create calculations in source data to extract the month name and the year from a date field and use the fields in your pivot table.

How to Break, Update or Change Links to Excel Charts or Worksheets in Microsoft Word

If you want to break, update or change links to Excel charts or worksheets in Microsoft Word, you’ll need to use the Edit Links to Files command. Unfortunately, this command is difficult to find. To make it easier to access, you can add Edit Links to Files to the Quick Access Toolbar.