| 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 | ||
| 240299 | 2004-05-31 04:55:00 | Oggy is right, use the label ' and it becomes text. Doesn't Lotus 123 come up with the slash key "/" in the latest Windows OS!. Les 3 |
leshibbard (873) | ||
| 240300 | 2004-05-31 08:44:00 | Well that was a bit different guys. Bit of humour here. :) It printed perfectly, the only problem being it was across the top line of six pages. :^O (I suppose I could cut and paste using scissors and Sellotape and then paper my office wall.) One must always maintain a sense of humour when dealing with computers. ;) In 123 you actually get to Printing Formulas through ( Tools - Audit ) I think Les. |
B.M. (505) | ||
| 240301 | 2004-05-31 11:21:00 | One way that you can do it which may give you what you want is to break the formula up with carriage-returns (alt-A). Then remove the '=' at the start of the formula and it should display in the cell creating the appropriate row height for it's needs - if not alter the height and print |
TeejayR (4271) | ||
| 240302 | 2004-06-06 11:59:00 | It maybe a little too late to your problem. Anyway, I just discover a way to show the formula for printing: To view formula in a worksheet: •Press Ctrl + ` (located just above the Tab key), also known as Formula View. Note that when you press these keys the columns become larger. Press these keys again reverts back to value, also known as value view •Resize each column so that all formulas are viewable •Preview the print job – it is best to change the Page Orientation to Landscape before printing, also change the Scaling to Fit to 1 page wide by 1 page tall •Click the Sheet tab and check the Gridlines and Row and Column headings checkboxes so that the worksheet, when printed, can help you decipher the formulas •Click OK in the Page Setup window. Cheers |
bk T (215) | ||
| 1 2 | |||||