July 8, 2023 • 0 Comments
Excel Dynamic Arrays
Exciting new features and functions in Excel. Dynamic Arrays, Ten Times the Power in One-Tenth...
Read More
Category:
October 2, 2019 • 0 Comments
Productivity
It’s unworthy of excellent professionals to lose hours like slaves buried in spreadsheet projects Paraphrased...
Read More
May 7, 2019 • 0 Comments
Word Wrap in Excel
Word Wrap in Excel? I thought we entered data in cells and performed calculations or...
Read More
May 5, 2019 • 0 Comments
Microsoft Excel Flash Fill Trick & Downloadable File
For example, you have your customer’s First and Last Names in separate columns, in this...
Read More
July 1, 2018 • 1 Comment
Auto Sum Macro
Excel’s AutoSum feature is very flexible and powerful. However, there are times when you may...
Read More
July 1, 2018 • 0 Comments
How to Save Personal Macro Workbook When Excel is Open
The normal procedures for making and saving changes in the PERSONAL.XLS file is to: Unhide...
Read More
July 1, 2018 • 0 Comments
A Macro to Open a New Workbook, then Hide and Save it
There times when you desired to create a new workbook, and then save it as...
Read More
January 24, 2018 • 0 Comments
Excel Print Ranges
This article was originally written in about 1995 when printing was a key task in...
Read More