Track Dynamic Data with VBA or with Iterative Calculations
"My A1 cell changes value every minute because it imports data from a DDE server. To keep historical data, I would like to list...
Save Time with Excel Range Selections
One of the big differences between early-stage Excel users and gurus is that gurus can do simple things in Excel much more quickly than...
Quickly Find a Worksheet in an Excel Workbook With Many Sheets
I’m not opposed to using VBA. I think it’s great fun and it can be very useful. But in a business setting, if VBA...
How to Use Absolute and Relative Cell References in Excel Formulas
A reader sent me this question:
Could you send me more details about using $'s like the following: =AVERAGE($6:$6) averages all data in ROW 6....
How to Tab From Cell to Cell in an Excel Worksheet Form
As a general rule, it's a good idea to find a way to import data from some other source, rather than entering the data...
How to Find and Use Excel’s Best Hidden Features
Excel has many outstanding hidden features. Here are a few that I use frequently…
In Excel 2013 and above, when you close Excel's last...
How to Delete Blank or Unneeded Rows, Method 1
When you bring data from another source into an Excel worksheet, the data often includes rows that you’ll want to delete. Often, you’ll want...
How to Create Dynamic Chart Legends in Excel
When I saw a chart designed like the ones below in the Wall Street Journal, I knew I had to create one just like...
How to Change Text to Columns When You Copy and Paste in Excel
Today I needed to copy a bunch of numeric tables from a pdf file into Excel.
When I pasted the first table, all the data...
How to Set Up a Data-Validation List Box in Excel
Often, we need to set up a list box in Excel, a sorted list that allows us to choose an item from an Excel...