Not a solution, but an additional problem. You say how to make a printout fit on one page, but this presumes the programme has a clue of WHAT you want to do a print preview on. You may highlight a group of cells to be printed, but “Print Preview” ignores this, and therefore you can’t adjust your print settings because it’s showing you a different set of cells to print
If, however, you highlight the cells, bring up “Print”, you can tell it to print just the highlighted cells. However, now the print dialogue gives you NO way to correct the print formatting, and it may cut off the edges of your printout because it will quite happily put cells out behind the margins (where it won’t print).
This is the ONE thing where I find MS Excel works far better; printing highlighted cells without major hackery (such as just deleting everything else in the file but the specific thing you want to print). It’s exceedingly frustrating, as I have NO desire to use MS Excel.
And it isn’t like the code to correct the formatting doesn’t exist; it’s right there in the “Print Preview” dialogue. The programme just meeds to point to those options. Alternatively, “Print Preview” needs an option to preview just the highlighted cells (probably even simpler, since it would be the same drop-down box already available in the “Print” dialogue.
