Last week, someone asked me how to make an Excel hyperlink to next empty cell. See how to set that up, in a couple of different situations.
Author: Debra Dalgleish
Excel Drop Downs from Dynamic Arrays
Select a region name in one Excel drop down list. Then, in the next drop down list, select from a list of employees who work in that region. You’ve seen this dependent drop down trick before, but watch my latest video below, to see a new twist on this technique.
Excel Pivot Power Free Add-in Update
If you’re using my Excel Pivot Power Free add-in, there’s a new version for you to download. There’s one new feature, one feature fix, and a couple of minor changes in the background. Continue reading “Excel Pivot Power Free Add-in Update”
How to Fix Excel Copy and Paste Problems
Copying and pasting can save you lots of time in Excel. Occasionally though, you might run into problems. See how to fix Excel copy and paste problems when you’re working with multiple selections. One problem is sneaky, and you might not even know it’s happening!
Keep Notes on Excel Formulas and Macros
Do you keep notes about the Excel formulas and macros that you create? What’s your documentation system, if you have one? Is it fancy or simple, and is it electronic or paper-based? Or is it all stored in your head?
Excel AutoFilter Macros
There are two types of AutoFilters in Excel – worksheet AutoFilters, and List (Table) AutoFilters. If you’re using Excel AutoFilter macros, be sure they’re designed for the type of Autofilters that are in your workbook.
How to Refresh an Excel Pivot Table
If you change any of the information in a pivot table’s source data, the pivot table won’t immediately show your latest changes. You have to refresh a pivot table, automatically or manually, to see the latest data. Continue reading “How to Refresh an Excel Pivot Table”
Excel Custom Function UDF Causing Problems
Excel macros ran really slowly in a workbook that someone sent to me. They said it was an Excel custom function (UDF) causing problems. The UDF ran for no apparent reason, and slowed other macros down. Here’s what I did to make things a bit faster.
Continue reading “Excel Custom Function UDF Causing Problems”
Excel at Your New Year Resolutions
Happy New Year’s Eve! If you’re setting goals for 2020, get these three free Excel templates to help you “Excel” at your New Year resolutions. There’s a weight loss tracker, a calorie counter, and a weekly meal planner.
Count Duplicate Number Sets in Excel
Recently, someone asked me how to count duplicate number sets. There were hundreds of rows, with 6 numbers in each row. Did any of the number sets appear in the list more than once? How would you solve this problem, and count duplicate number sets?