October 11, 2023
I have to paste formatting to many sections of a report.
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.
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.
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.
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?
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?