Excel Tips
Slimming Selection Post Merge »
May 3, 2017
Merged cells are evil. I often am selecting a range of data, but then accidentally touch a merged cell. Bam! My selection rectangle just became three columns wide. I usually curse and start selection again, but there is a keyboard shortcut to narrow the selection back to the original width.
Prevent Scientific Notation on Import »
May 1, 2017
Stop Excel from converting your data to scientific notation when you import data from a CSV or TXT file.
April 28, 2017
How to separate a column of Excel data in to two columns. How to parse data in Excel.
April 26, 2017
Pam would like to arrange her worksheet tabs alphabetically. This is not a command in Excel, but using a short macro, you can add it to your Quick Access Toolbar.
April 25, 2017
Excel - Can you use the Find dialog to find a worksheet name?
Macro Create Sheets from Cells »
April 24, 2017
You have a column of text. For each text in the column, you want to insert a new worksheet and name that worksheet for the value in the cell.
April 21, 2017
How to show Month-To-Date sales in a pivot table. This is a Dueling Excel episode.
April 20, 2017
Excel Pivot Tables will let you group similar text entries. Say you wanted to group Chicago, Cleveland, and Detroit into a territory called Midwest. This article shows you how.