Change a Pivot Table to Tabular Form
You can switch a Pivot Table layout from the default Compact Form to a Tabular Form to view data in a traditional flat table layout. The Tabular Form layout makes …
Steve Scott
How to Lock Pivot Table Column Width
By default, a Pivot Table automatically adjusts column widths to fit new or updated content when refreshed or filtered. This default setting can disorganize your worksheet’s layout and be frustrating …
How to Undo Delete Sheet in Excel
You delete a sheet in Excel, and then, oops! You realize you shouldn’t have deleted it. How do you recover it? Excel does not have an ‘Undo (CTRL + Z)’ …
Convert Latitude Longitude to Address in Excel
You convert latitude and longitude coordinates into an address because it is easier for humans to understand an address than coordinates. For instance, ‘123 Main Street, New York’ is far …
How to Write Vertically in Excel
Sometimes, you may need to write or type vertically in Excel to fit data within narrow columns, organize data, or enhance the visual layout. For instance, in the example duty …
How to Add Months to a Date in Excel
When working with dates in Excel, you may need to add months to a particular date to calculate a future date. For example, as a project manager, you might need …
How to Filter Strikethrough in Excel
You can apply the strikethrough formatting to cells in an Excel dataset to indicate completed tasks, outdated information, etc. For example, in the dataset below completed tasks have a strikethrough …
How to Group Duplicates in Excel
Sometimes when you receive a dataset with duplicates you may need to group the duplicates so you can easily identify them and decide to remove or consolidate them. This way …
Delete Multiple Sheets in Excel
Sometimes you may need to delete multiple sheets in your workbook. For example, you may want to delete empty sheets or worksheets with outdated information. In this tutorial, I will …
How to Return to Normal View in Excel
Excel has three built-in workbook view options: Normal View, Page Break Preview, and Page Layout View. You can find these options on the Workbook Views group of the View tab. …
Point and Click Method in Excel
You can use the point-and-click method in Excel to create formulas by selecting cells with your mouse rather than typing cell references manually. With this method, you can create formulas …
XLOOKUP Vs INDEX MATCH in Excel
XLOOKUP and INDEX MATCH are Excel functions for performing lookups. The functions retrieve values from a table or range but differ in functionality, syntax, flexibility, availability, performance, ease of use, …