Excel Tips
October 12, 2023
I have a thousand rows of data. I want to apply red and blue to every other row. Nothing in the Format as Table looks exactly like I want it to look and I don’t want to define my own table style.
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.