Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel page setup Sheet Print Cells Error As...
hi community
can anyone kindly let me know what is the usage of the "Cells Error As..." in the Print dialog box at the Sheet Tab all about ?...when I clicked the droplist, it shows me few option to select, such as "blank", " --- " , "N/A""...and "displayed" as the default setting. Thanks for the helping :) -- oldLearner57 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel page setup Sheet Print Cells Error As...
I've never used that feature but I would assume that it will print anything
from the drop down list in in place of a cell error when printing. (For example if you had a divide by zero error or other error from formulas and you set it to 'displayed' it will print the error as shown in the cell, if you set it to blank it will print a blank, if you set it to N/A it will print N/A's in the cells with errors. "tikchye_oldLearner57" wrote: hi community can anyone kindly let me know what is the usage of the "Cells Error As..." in the Print dialog box at the Sheet Tab all about ?...when I clicked the droplist, it shows me few option to select, such as "blank", " --- " , "N/A""...and "displayed" as the default setting. Thanks for the helping :) -- oldLearner57 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel page setup Sheet Print Cells Error As...
hello Tim M
thanks for the info and yes!, you correct, it will print out accordingly to user selection :) thanks again -- oldLearner57 "Tim M" wrote: I've never used that feature but I would assume that it will print anything from the drop down list in in place of a cell error when printing. (For example if you had a divide by zero error or other error from formulas and you set it to 'displayed' it will print the error as shown in the cell, if you set it to blank it will print a blank, if you set it to N/A it will print N/A's in the cells with errors. "tikchye_oldLearner57" wrote: hi community can anyone kindly let me know what is the usage of the "Cells Error As..." in the Print dialog box at the Sheet Tab all about ?...when I clicked the droplist, it shows me few option to select, such as "blank", " --- " , "N/A""...and "displayed" as the default setting. Thanks for the helping :) -- oldLearner57 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions | |||
How can I print on the front and back of a page in excel? | Excel Discussion (Misc queries) | |||
print view & print, in excel, different size cells | Excel Discussion (Misc queries) | |||
Copy Page Setup from Sheet to Sheet? | Excel Discussion (Misc queries) | |||
excel margin issues on landscape - also cant print to a full page. | Excel Discussion (Misc queries) |