Hi all! I'm using Excel 2007. I know when I had Excel 2003, there was a program setting that I saw in a magazine that could do this (and I did!), but I can't find it in the 2007 version!
I have a spreadsheet that uses formulas based on several pieces of data that I input from several sources. When I print the part of the spreadsheet, I don't always have all the data available to enter, so I have a cell that shows - #DIV/0! = as the data (because the underlying cell data is blank at this time). Without modifying the cell formula, is there a way to make a global Excel setting that would print just a blank cell if the formula is in error??
As always, thanks in advance for any and all answers!
I have a spreadsheet that uses formulas based on several pieces of data that I input from several sources. When I print the part of the spreadsheet, I don't always have all the data available to enter, so I have a cell that shows - #DIV/0! = as the data (because the underlying cell data is blank at this time). Without modifying the cell formula, is there a way to make a global Excel setting that would print just a blank cell if the formula is in error??
As always, thanks in advance for any and all answers!