Excel Tips


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?


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?


Use White Text to Hide Data »

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.


Copy Row Heights »

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.