It is rarely a good idea to print to the printer without viewing the printout in Print Preview mode. The page breaks are based on paper size, margins size, and scaling options. The default orientation for printing is portrait, while most users are concerned with fitting as many columns to the page as possible while letting the rows run wild.
Taming the Printing BeastĮxcel’s default print settings rarely work to your advantage. Excel must slice the sheet the best way it thinks to translate that 16.5 mile-long piece of paper into tiny, manageable sheets. The virtual sheet size does not come close to matching the real-world paper size. Granted, this is just a fun mental exercise, but it showcases the key reason that printing is an issue. This doesn’t even factor in the taxes, ink/toner and the myriad of printers you will burn through during the print process.
If you printed it on 8½ × 11-inch paper (no margins), it would take: To keep the math simple, let’s set each cell on the sheet to a 1-inch by 1-inch size ( about 2.5cm). So, how big is an Excel sheet? I mean, if you were to print THE WHOLE sheet on a single piece of paper, how large would it be? No margins no page breaks just one giant piece of paper. Excel is working with 16K columns and 1M rows. You must remember Excel is not working with a traditional sized piece of paper. It is the epitome of WYSIWYG (for you youngsters, it means “ What You See Is What You Get”). There is a direct dimensional relationship between virtual paper and real paper.
This means that whatever we place on the virtual paper (text, images, tables, borders, etc.) will map 1:1 ( one to one) on the real paper. In a word processor, we are presented typically with a virtual piece of Letter or A4 sized paper.
Excel print selection one page how to#
Most users learn how to print when using a word processor, like Microsoft Word.
0 kommentar(er)
