Do you use Excel to help with all of your holiday planning? It’s a great tool for shopping lists, holiday budgets, dinner preparation, and even holiday games!
Continue reading “Excel for the Holidays 2023-Planning-Games-Trees”
Author: Debra Dalgleish
How to Remove Duplicate Items in Excel List
There’s a built-in tool in Microsoft Excel that makes it easy to remove all the duplicate values from a list. You can remove duplicates based on the items in one column, or multiple columns.
Continue reading “How to Remove Duplicate Items in Excel List”
How to Sum Filtered Excel Data – AGGREGATE or SUBTOTAL
When an Excel list is filtered, how can you show a total sum or count for numbers in the visible rows only? There are two Excel functions for that task — SUBTOTAL (all Excel versions) and AGGREGATE (Excel 2010 and later). See how these functions work, and decide which one to use.
Continue reading “How to Sum Filtered Excel Data – AGGREGATE or SUBTOTAL”
Video: Dependent Combo Boxes – Excel Data Entry
Make it easy to enter valid data in an Excel workbook. Choose “Fastener” in one combo box drop down. The next combo box shows a list of fastener parts, with part ID and part name.
This video shows how to use this simple data entry tool, and you’ll get a peek behind the scenes, on how it works.
Continue reading “Video: Dependent Combo Boxes – Excel Data Entry”
Hide Excel Hyperlink-Show Monthly-Conditional Format
In your job, are there Excel tasks that need to be done at month end? Here’s how I use a hidden hyperlink to help with my month end routine. Continue reading “Hide Excel Hyperlink-Show Monthly-Conditional Format”
How to Prevent Duplicate Entries in Excel Column
In some workbooks, you might need to block duplicate entries in a column. For example, we don’t want 2 employees to have the same ID number. See how to set up a custom rule for that, with data validation. And keep reading, to see why COUNTIF can cause problems for you.
Continue reading “How to Prevent Duplicate Entries in Excel Column”
Quickly Move Sheet in Large Excel File
Do you ever find yourself scrolling through an endless number of worksheet tabs, while you’re working in a large Excel file? It’s happened to me, more times than I can count, while working in my own files, or client workbooks. Here’s a quick tip that might help you save some time!
Should You Merge Cells or Combine Text in Excel
In our everyday life, the words Merge and Combine have almost the same meaning. However, when you’re working in Microsoft Excel, there are important differences in their meanings!
Continue reading “Should You Merge Cells or Combine Text in Excel”
Excel Footer Font Fix and Custom Footer Macro
When you’re printing financial reports in Excel, do you set them up to print one page wide? That feature saves paper, but it can make the header and footer text too small to read, especially if it’s in a small font size already. Here’s how you can avoid that problem. And there’s a macro to create a custom worksheet footer too!
Continue reading “Excel Footer Font Fix and Custom Footer Macro”
Spreadsheets in the News 2023-06-29
It’s almost the end of June, and there’s a long weekend coming up! To celebrate, let’s take a look at some of the spreadsheet news from the past month. Here are 3 stories that caught my eye, and let me know if there was other noteworthy news that I missed!