Posted to microsoft.public.excel.programming

nickname[_2_] nickname[_2_] is offline

external usenet poster

Posts: 2

Stopping blank cells with formulae in from printing

I have created a new workbook and in cell B1 I have put the formulae
"=IF(ISBLANK(A1),"",44)". I have then used the fill down function to fill it
down to row 65536. When I go to file print preview its going to print 1821
blank pages. How can I stop it from printing cells that show no value but
contain formulae?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Stopping IF command from entering zero or 1 for blank cells	Nick S	Excel Worksheet Functions	3	November 20th 09 05:41 PM
Printing cells that are blank, because there is a formula	JeffK	Excel Discussion (Misc queries)	5	November 18th 09 09:51 PM
printing blank cells	cmh	Excel Discussion (Misc queries)	2	November 15th 06 08:11 PM
Stopping blank page printing	F*SH	Charts and Charting in Excel	0	July 24th 06 11:39 AM
counting from left to right and stopping when blank	harpscardiff	Excel Discussion (Misc queries)	6	August 19th 05 07:34 PM

All times are GMT +1. The time now is 08:39 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us