Excel Tips
Copy Without Changing Borders »
October 10, 2023
I have built a report in Excel and used numerous borders to outline the data. After entering a formula to calculate profit in E3, I want to copy the formula down to E4 through E7.
Copy Formatting to a New Range »
October 9, 2023
I have several similar report sections on a spreadsheet. When I get the first report nicely formatted, I would like to copy the format to the other reports.
Organize Your Worksheet Tabs with Color »
October 6, 2023
I have a lot of tabs in a workbook. Can I highlight the frequently used tabs in red?
October 5, 2023
I don’t want people unhiding my worksheets. I have one guy in accounting who always goes to Home, Format, Hide and Unhide, Worksheets to see what is hidden.
October 4, 2023
If you use Group Mode, you can hide a bunch of worksheets in one command.
Hide Error Cells When Printing »
October 3, 2023
I have a formula that does division. Occasionally, the divisor cell is zero, so I have a couple of #DIV/0! value errors. I need to print this sheet without the errors to get the report to a staff meeting. I don’t have time to rewrite all the formulas to test whether the divisor is zero. What can I do?
Group Columns Instead of Hiding Them »
October 2, 2023
I have a report with months and quarters. My manager sometimes wants the reports printed with months hidden and other times with the months showing. It is a pain to hide/unhide the four groups of monthly columns.
September 29, 2023
I need to hide data in a worksheet, but I don’t want to delete it. Is there a way to do this besides using the previous two techniques?
Hide Values Using a Number Format »
September 28, 2023
Why did you use the white font to hide those cells? Isn’t there a custom number format to hide values?