Excel Tips

Power Up Format Painter »

October 11, 2023

I have to paste formatting to many sections of a report.

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?

Very Hide a Worksheet »

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.

Unhide All Sheets »

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.

Hide and Unhide Data »

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?