Excel Tips
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?
September 27, 2023
My workbook needs extra columns in order to show a graph. I’d like to hide this information from the person using the workbook.
September 26, 2023
That last trick for pasting column widths works well. How do I do the same thing for row heights?
Copy Column Widths to a New Range »
September 25, 2023
I have a small report in columns A:G. I made a copy of that report in column H. The column widths did not get copied over. It is a pain to individually look at each column width in A through G and then make the same column width in the new report.
Change the Width of All Columns with One Command »
September 22, 2023
I have a large model set up in Excel. Some of the columns are hidden. I want to globally change the width of all unhidden columns to a width of 4. If I choose all columns in the worksheet and use Home, Format dropdown, Column Width, the hidden columns will unhide.