| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 117192 | 2011-04-06 22:59:00 | Excel 2010 help | Brucem (8688) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 1192674 | 2011-04-06 22:59:00 | Late last year I upgraded from Office Pro 2000 to 2010. In excel I am having a problem with spare pages in print preview. At present I am wanting to print what should be 3 pages (A4 Long, landscape) with all columns on one page, but I get 12 pages shown. I have tried deleting masses of columns outside my spreadsheet but to no avail. I can of course print pages 1, 5, 9. but would like to solve this. I have had it before with another spreadsheet. I have also noticed a small green triangle in the top left hand corner of some cells, what does it mean? As usual, MS help doesn't. Brucem |
Brucem (8688) | ||
| 1192675 | 2011-04-06 23:07:00 | Try selecting the pages or cells you wish to print - go to > Page Layout (on ribbon)> Select Print Area and go from there. That way you specify the print area and not all the unused cells on a blank spreadsheet. | SP8's (9836) | ||
| 1192676 | 2011-04-06 23:14:00 | The triangle seems to pop up for me when I alter a cell that was filled in series with a group of others. Seems to indicate something has changed or isn't in sequence with the surrounding cells. I usually just ignore it. For printing choose the print area as SP8 suggested, also in print properties you can selct "fit to" 1 pages wide and 3 pages high for example. |
dugimodo (138) | ||
| 1192677 | 2011-04-06 23:32:00 | Green triangle in cell = incorrect formula or something else wrong. Open help (blue question mark top right of screen while in Excel) type in - Green Triangle in cell - you'll get all the info there. Excel help is pretty good actually ... going to MS to find it can be a hassle. |
SP8's (9836) | ||
| 1 | |||||