Excel Tips
Change All Red Font Cells to Blue Font »
October 13, 2023
I’ve marked a few hundred cells in a large workbook using a red font. My manager is superstitious and wants all the red cells changed to blue. The red cells are not contiguous. I did not use cell styles to apply red.
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?