 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2006Make the #N/A invisible
I have specified some formula in my Excel worksheets. But, when the cells are empty(with no data), it shows this sign #N/A in the cells. How I could make it invisible so that when a user print the sheet, it will only display the cells that contain data? In page setup->Sheet Print-> Cell erros as <blank> "rixanna" <fildzana@gmail.com> ???????:1157441242.065493.240390@m79g2000cwm.googlegroups.com... >I have specified some formula in my Excel worksheets. But, when the > cells are empty(with no data), it shows this sign #N/A in the cells. > > How I could make it invisible so that when a user print the sheet, it > will only display the cells that contain data? Another way is to amend your formulae so they don't produce the errors: =IF(ISNA(your_formula),"",your_formula) Hope this helps. Pete > In page setup->Sheet > Print-> Cell erros as <blank> [quoted text clipped - 6 lines] > > How I could make it invisible so that when a user print the sheet, it > > will only display the cells that contain data? > In page setup->Sheet > Print-> Cell erros as <blank> [quoted text clipped - 6 lines] > > How I could make it invisible so that when a user print the sheet, it > > will only display the cells that contain data? Thanks a lot..it really works!!! You are welcome "rixanna" <fildzana@gmail.com> ???????:1157446876.094201.93470@i3g2000cwc.googlegroups.com... >> In page setup->Sheet >> Print-> Cell erros as <blank> [quoted text clipped - 8 lines] > > Thanks a lot..it really works!!! I know how to get rid of N/A... don't use Excel. don't use Excel. don't use Excel. how is that for a solution? use MS Access or something similiar.. Access Data Projects _ROCK_ -Aaron > I have specified some formula in my Excel worksheets. But, when the > cells are empty(with no data), it shows this sign #N/A in the cells. > > How I could make it invisible so that when a user print the sheet, it > will only display the cells that contain data?
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.