BLOG

Tom’s Tutorials For Excel: Showing Your Column Headers as Letters or Numbers


Share Button

Tom’s Tutorials For Excel: Showing Your Column Headers as Letters or Numbers You can show your column headers as letters or numbers. Here’s how to change column headers depending on your preferred look.

Posted in Tom's Tutorials for Excel
Tags: ,

Tom’s Tutorials For Excel: Knowing Any Workbook’s Last Saved Date and Time


Share Button

Tom’s Tutorials For Excel: Knowing Any Workbook’s Last Saved Date and Time You can get the last saved date and time for any workbook whether it is open or closed. In the following pictures, Book1 is the only workbook open in the Visual Basic Editor’s Project window. In the Immediate

Read more ›

Posted in Tom's Tutorials for Excel
Tags: ,

Tom’s Tutorials For Excel: Moving a Cell’s Lines of Text into Separate Columns


Share Button

Tom’s Tutorials For Excel: Moving a Cell’s Lines of Text into Separate Columns I previously posted this example showing how to enter separate lines of text into a single cell. This example shows how to move each line of a cell’s text into its own cell. The first picture shows

Read more ›

Posted in Tom's Tutorials for Excel
Tags:

Tom’s Tutorials For Excel: New in Version 2016, the “Tell me what you want to do” Field


Share Button

Tom’s Tutorials For Excel: New in Version 2016, the “Tell me what you want to do” Field New in Excel 2016, you can click into the “Tell me what you want to do” field as shown in the picture, or press Alt+Q from your worksheet, to enter a topic for

Read more ›

Posted in Tom's Tutorials for Excel
Tags:

Tom’s Tutorials For Excel: New in Version 2016, the Multi-Select Icon for Pivot Table Slicers


Share Button

Tom’s Tutorials For Excel: New in Version 2016, the Multi-Select Icon for Pivot Table Slicers New in Excel 2016 is the Multi-Select icon for pivot table slicers, a welcome convenience to the heretofore requirement of pressing the Ctrl key to select multiple labels. In the picture for example, I clicked

Read more ›

Posted in Tom's Tutorials for Excel
Tags:

Tom’s Tutorials For Excel: Summing a Range of Separate Pairs of Delimited Numbers


Share Button

Tom’s Tutorials For Excel: Summing a Range of Separate Pairs of Delimited Numbers Here are two formula options to sum a range of cells, when each cell holds a delimiter (in this example, a hyphen character), and you want to separately sum the cells’ numbers to the left and right

Read more ›

Posted in Tom's Tutorials for Excel
Tags:

Tom’s Tutorials For Excel: Customizing the Status Bar


Share Button

Tom’s Tutorials For Excel: Customizing the Status Bar You can right-click the status bar for additional edit, formatting, and analysis options. The following picture shows a Before and After comparison of the additional information you can choose for the status bar to show. In this example, the Minimum and Maximum

Read more ›

Posted in Tom's Tutorials for Excel
Tags:

Tom’s Tutorials For Excel: Using a Formula to Transpose a Vertical Range Horizontally


Share Button

Tom’s Tutorials For Excel: Using a Formula to Transpose a Vertical Range Horizontally As the picture shows by example, you can horizontally transpose a vertical range at any cell outside the vertical range with the formula =INDEX($A$2:$A$25,COLUMNS($A$2:A25)) Note the absolute and relative references.

Posted in Tom's Tutorials for Excel
Tags: ,

Tom’s Tutorials For Excel: Using a Ribbon Group’s Dialog Launcher


Share Button

Tom’s Tutorials For Excel: Using a Ribbon Group’s Dialog Launcher To see all the options for a Ribbon group, click the dialog launcher in the group’s bottom right corner.

Posted in Tom's Tutorials for Excel
Tags:

Tom’s Tutorials For Excel: Hiding Your Named Ranges


Share Button

Tom’s Tutorials For Excel: Hiding Your Named Ranges In the below picture, your workbook’s named ranges can be shown by clicking the down arrow next to the Name box. The following macro hides the named ranges, and as the next picture shows, you can work with hidden named ranges the

Read more ›

Posted in Tom's Tutorials for Excel
Tags: ,