Excel Tips
Protect Cells That Contain Formulas »
October 28, 2022
I have to key in data in a large number of cells in a month-end financial statement. I don’t want to accidentally key in a number in a cell that contains a formula. How can I protect just the formula cells?
Preview Remove Duplicates Without Removing Them »
October 27, 2022
I want to preview which rows will be deleted before deleting them with Remove Duplicates.
October 26, 2022
I have a data set in which I would like to find every unique combination of customer and product.
Find Total Sales by Customer by Combining Duplicates »
October 25, 2022
I have an invoice register for the month. The report shows account, customer, invoice, sales, cost, and profit for each invoice. I want to combine customers in order to produce a report of sales by customer.
Combine Four Quarterly Reports »
October 24, 2022
I have four worksheets for Q1 through Q4. Each worksheet has months across the top and customers down the side. The months and customers are not the same. I want to combine them into a single report.
Use Consolidation to Combine Two Lists »
October 21, 2022
Jerry and Tina each compiled sales figures from paper invoices. I need to combine Jerry and Tina’s list into a single list. Some customers are in both lists.
Hide Zeros & Other Custom Number Formatting Tricks »
October 20, 2022
I don’t want zeros to appear in my document.
Use an Ampersand in a Header »
October 19, 2022
I added the custom header Profit & Loss Report to my report.
Use Find to Find an Asterisk »
October 18, 2022
My largest customer is Wal*Mart. When I use Find or Find and Replace to search for Wal*Mart, Excel also finds Wallingsmart. I know this happens because Excel sees * as a wildcard character. What if I really want to search for an asterisk?