Forum Home
Press F1
Thread ID: 45643	2004-05-29 05:20:00	Printing Formula in XL	B.M. (505)	Press F1

Post ID	Timestamp	Content	User
240289	2004-05-29 05:20:00	How does one print the formula pertaining to a cell in XL (Office 2000)? I Just want to print the formula, not the results of that formula. Cheers Bob	B.M. (505)
240290	2004-05-29 05:41:00	Tools - Options - View - tick "Formulas" Its a sheet-wide setting not a cell by cell setting.	godfather (25)
240291	2004-05-29 06:16:00	That certainly shows all the formula gf but I still cant print any as even if I choose to print just one cell the formula is truncated. The same applies to printing the page. :(	B.M. (505)
240292	2004-05-29 06:26:00	Quite obviously the formula will be larger than a standard cell width in most cases. Therefore just widen the column. However in Excel 2002 it automatically widens the column here. If it didn't then it would truncate though in most cases. Is there some reason why you cannot widen the column?	godfather (25)
240293	2004-05-29 07:10:00	I got the cell width out to full screen (1000 pixel) and the formula still didn't fit. (You can see why I want to print it and not re-invent it) :D (Normal cell width 48 pixels) Lotus 123 lets you print a formula without any problems so I thought XL would also. :(	B.M. (505)
240294	2004-05-29 08:04:00	I guess my comments would be, that any formula that will not display fully in a 1000 pixel cell at minimum font size is somewhat unusual in size! And, while I have been using Excel since version 2.0 (runtime Windows under DOS) I have never had the need or desire to print out a formula. However, as the formula fully displays in the formula bar when you click on the cell, have you considered a copy (from the formula bar) and Paste (perhaps into Word) for one-offs? It does work in that manner, I have tested it.. Or, remove the "=" from the front of the formula. Then apply text wrap (format - cell) to the cell and the entire formula text will word wrap in the cell.	godfather (25)
240295	2004-05-29 08:50:00	Quite right gf, the formula is somewhat unusual in size. A lot of the size is attributable to lookup commands that refer to other sheets but it’s not run of the mill stuff by any means. Yes, I can copy and paste it into Word and print it from there but I thought that there may be a simple way as there is with Lotus 123. Thanks for your time anyway. Cheers Bob	B.M. (505)
240296	2004-05-29 23:01:00	Hi Bob, you can fit 32,767 characters into a cell but only 1,024 characters are visible in the cell - all 32,767 display in the formula bar when the cell is selected. My understanding is that the print limits are the same as the visible cells so you would only be able to print 1024 characters per cell. That said, it's a hell of a long formula to exceed that many. :-)	parry (27)
240297	2004-05-30 00:12:00	Actually Parry I’m fully expecting to unravel the “Double Helix” all by myself, but completely by accident of course. :^O As an aside, I changed to XL from 123 because 123 didn’t like what I was trying to do but XL was fine. Only glitch is not being able to print the formula at the click of the mouse as you can with 123. Never mind, it can still be copied and pasted into Word and then printed. With a memory like mine it pays to record things, as if I were to have to start again for some reason I’d have commas and brackets missing everywhere. :D	B.M. (505)
240298	2004-05-31 04:03:00	This works for me on the odd occasions that I need to see a formula printed: Copy the formula to the next cell down (or somewhere appropriate). Put a ' (the thing that's on the same key as the " ) in front of the = and this then makes the formula into a text value, which will print as if it were text. If you want to display all the formula on the sheet you can go < Ctrl ~ > although I don't know how much of the formula will print as mine aren't that huge.	oggy (1250)
1 2