Learn how to to configure printing settings, work with print preview, and get accurate prints of your spreadsheets.

<p>Today, we are going to teach you everything you need to know about how to adjust spreadsheet printing settings, use print preview, and get excellent accurate prints of your spreadsheets that will leave your colleagues happy.</p>
<p><img decoding="async" loading="lazy" class="aligncenter size-full wp-image-31487 img-popup" src="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/Blog_all_about_print_preview_Excel_workbooks.jpg" alt="All about print preview in Excel sheets" width="1472" height="742" srcset="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/Blog_all_about_print_preview_Excel_workbooks.jpg 1472w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/Blog_all_about_print_preview_Excel_workbooks-300x151.jpg 300w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/Blog_all_about_print_preview_Excel_workbooks-1024x516.jpg 1024w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/Blog_all_about_print_preview_Excel_workbooks-768x387.jpg 768w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/Blog_all_about_print_preview_Excel_workbooks-634x320.jpg 634w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/Blog_all_about_print_preview_Excel_workbooks-353x178.jpg 353w" sizes="(max-width: 1472px) 100vw, 1472px" /></p>
<h2>What is print preview in Excel spreadsheets?</h2>
<p>Print preview is a feature in printing settings that displays the actual sample of how the document you are printing will look on paper. It helps you adjust all the printing settings correctly so the print is accurate and contains all the content you need without distortions, cuts, or lost formatting.</p>
<p>Previewing prints in spreadsheets is equally useful, if not even more. Spreadsheets are much more tricky, considering that they tend to be richer in contents, don’t have pre-defined borders and structure, and accurate scaling needs to be done together with other adjustments to keep the contents compact but readable.</p>
<h2>Where is print preview located?</h2>
<p>Print preview can be found in the settings of the Excel spreadsheet editor. In ONLYOFFICE Docs, the settings are available from both the main toolbar, next to the Redo/Undo and Save buttons, and from the menu in the File tab.</p>
<figure id="attachment_31503" aria-describedby="caption-attachment-31503" style="width: 736px" class="wp-caption aligncenter"><a href="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/1.png"><img decoding="async" loading="lazy" class="img-popup wp-image-31503" src="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/1.png" alt="All about print preview in Excel sheets" width="736" height="406" srcset="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/1.png 1440w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/1-300x165.png 300w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/1-1024x565.png 1024w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/1-768x423.png 768w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/1-323x178.png 323w" sizes="(max-width: 736px) 100vw, 736px" /></a><figcaption id="caption-attachment-31503" class="wp-caption-text">Settings menu with preview</figcaption></figure>
<p>To get an initial preview, you don’t need to make any preparations, as the preview with default preferences is available right away. You also don’t need to save settings each time to see the updated preview, as it is automatically refreshed every time you change something.</p>
<h2>How to set and preview print in Excel sheets</h2>
<p>When preparing your page, the following parameters are available:</p>
<ul>
<li>Print Area;</li>
<li>Print Range;</li>
<li>Individual sheet settings;</li>
<li>Page size;</li>
<li>Page orientation;</li>
<li>Scaling;</li>
<li>Titles;</li>
<li>Margins.</li>
</ul>
<p>Let’s see how to use these parameters to make your page look accurate and see how it looks in the print preview in Excel sheet.</p>
<h4>1. Select the Print Area (optional)</h4>
<p>This step is optional, however, this may help you predefine the section of the spreadsheet you need to print and cut out all unnecessary parts.</p>
<p>Print area is located in the Layout tab. First. Select the area in the spreadsheet you want to include in your page, then click Print Area button and set it with the corresponding command. When it is applied, you will see the dotted line border in the sheet indicating the chosen print area.</p>
<figure id="attachment_31514" aria-describedby="caption-attachment-31514" style="width: 736px" class="wp-caption aligncenter"><a href="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/2.png"><img decoding="async" loading="lazy" class="img-popup wp-image-31514" src="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/2.png" alt="All about print preview in Excel sheets" width="736" height="501" srcset="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/2.png 1166w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/2-300x204.png 300w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/2-1024x696.png 1024w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/2-768x522.png 768w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/2-262x178.png 262w" sizes="(max-width: 736px) 100vw, 736px" /></a><figcaption id="caption-attachment-31514" class="wp-caption-text">A table with selected print area</figcaption></figure>
<figure id="attachment_31525" aria-describedby="caption-attachment-31525" style="width: 736px" class="wp-caption aligncenter"><a href="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/3.png"><img decoding="async" loading="lazy" class="img-popup wp-image-31525" src="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/3.png" alt="All about print preview in Excel sheets" width="736" height="604" srcset="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/3.png 894w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/3-300x246.png 300w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/3-768x631.png 768w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/3-217x178.png 217w" sizes="(max-width: 736px) 100vw, 736px" /></a><figcaption id="caption-attachment-31525" class="wp-caption-text">Preview of the table with Print Area applied</figcaption></figure>
<p>You can make another selection and add it to previously defined area by clicking Add to Print Area in the same menu.</p>
<h4>2. Define the general print range</h4>
<p>In the settings, the first parameter you need to define is the print range. It is different from the Print Area feature: here, you can choose between printing all sheets, current sheet, or current selection.</p>
<p>It does, however, interact with the Print Area selection, so pay attention to it to avoid possible conflicts. If you don’t want to use the selected area and want to, for example, render the whole sheet instead, check the box “Ignore print area” below the Print Range setting.</p>
<p>Note: If you leave the box unchecked giving that you used Print Area feature before that, there are two scenarios. If the defined area is within your range (if you picked the whole spreadsheet as a range, for example), the preview will show only what you picked for the print area. If it is outside of it (for example, you chose “Current selection” and the selection is outside the area), the preview will prefer this selection over the pre-selected area.</p>
<h4>3. Apply sheet settings</h4>
<p>When you choose “All sheets” in the drop-down list for range, you need to apply individual settings for each of the sheets, in case they are different from default. This is applicable to all settings described after this step.</p>
<p>To choose the sheet to apply new settings to, choose it in the drop-down menu.</p>
<h4>4. Set up page size</h4>
<p>Select one of the available page size standards from the drop-down menu if you have such a preference for your page.</p>
<figure id="attachment_31536" aria-describedby="caption-attachment-31536" style="width: 736px" class="wp-caption aligncenter"><a href="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/4.png"><img decoding="async" loading="lazy" class="img-popup wp-image-31536" src="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/4.png" alt="All about print preview in Excel sheets" width="736" height="504" srcset="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/4.png 829w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/4-300x206.png 300w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/4-768x526.png 768w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/4-260x178.png 260w" sizes="(max-width: 736px) 100vw, 736px" /></a><figcaption id="caption-attachment-31536" class="wp-caption-text">Page size presets drop-down menu</figcaption></figure>
<h4>5. Change page orientation</h4>
<p>By default, your page is set to have a Portrait orientation. If you need to demonstrate a horizontally-orient table, we recommend you to choose Landscape version so none of your content is cut.</p>
<figure id="attachment_31547" aria-describedby="caption-attachment-31547" style="width: 736px" class="wp-caption aligncenter"><a href="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/5.png"><img decoding="async" loading="lazy" class="img-popup wp-image-31547" src="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/5.png" alt="All about print preview in Excel sheets" width="736" height="493" srcset="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/5.png 1177w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/5-300x201.png 300w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/5-1024x686.png 1024w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/5-768x515.png 768w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/5-266x178.png 266w" sizes="(max-width: 736px) 100vw, 736px" /></a><figcaption id="caption-attachment-31547" class="wp-caption-text">Landscape page orientation</figcaption></figure>
<h4>6. Apply scaling</h4>
<p>Sometimes your data doesn’t fit on the page even after adjusting page orientation and limiting the print range. You can check the preview carefully to see if any parts of the sheet were cut and scroll it to see what contents were automatically relocated to the next page.</p>
<figure id="attachment_31558" aria-describedby="caption-attachment-31558" style="width: 736px" class="wp-caption aligncenter"><a href="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/6.png"><img decoding="async" loading="lazy" class="img-popup wp-image-31558" src="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/6.png" alt="All about print preview in Excel sheets" width="736" height="602" srcset="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/6.png 905w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/6-300x245.png 300w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/6-768x628.png 768w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/6-218x178.png 218w" sizes="(max-width: 736px) 100vw, 736px" /></a><figcaption id="caption-attachment-31558" class="wp-caption-text">Scaling set to 400%</figcaption></figure>
<p>If you still need to have everything on the same page but can’t afford to hide any data from the range, apply scaling. Here, you can either stay with actual size by default, fit the whole range to the page, or fit all columns or rows. Alternatively, you can use custom scaling options to set width and height, and choose the percentage of scaling.</p>
<p>If you have a long or wide table that can’t fit on one page don’t want to scale it too much to keep your data readable, you can add table titles to every page so it is easier to find what is where.</p>
<p>Choose “Repeat rows at top” or “Repeat columns at left” to show the corresponding titles. You can manually select the range to repeat, or select the desired item from the list of available options: maintain frozen rows, and only repeat the first row/column.</p>
<figure id="attachment_31569" aria-describedby="caption-attachment-31569" style="width: 736px" class="wp-caption aligncenter"><a href="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/7.png"><img decoding="async" loading="lazy" class="img-popup wp-image-31569" src="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/7.png" alt="All about print preview in Excel sheets" width="736" height="1177" srcset="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/7.png 896w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/7-188x300.png 188w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/7-640x1024.png 640w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/7-768x1228.png 768w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/7-111x178.png 111w" sizes="(max-width: 736px) 100vw, 736px" /></a><figcaption id="caption-attachment-31569" class="wp-caption-text">Repeated headings in the table that exceeds the page height</figcaption></figure>
<h4>7. Set margins</h4>
<p>You can set the margins manually, changing the Top, Bottom, Left, and Right fields.</p>
<figure id="attachment_31580" aria-describedby="caption-attachment-31580" style="width: 736px" class="wp-caption aligncenter"><a href="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/8.png"><img decoding="async" loading="lazy" class="img-popup wp-image-31580" src="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/8.png" alt="All about print preview in Excel sheets" width="736" height="460" srcset="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/8.png 1175w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/8-300x188.png 300w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/8-1024x641.png 1024w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/8-768x480.png 768w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/8-285x178.png 285w" sizes="(max-width: 736px) 100vw, 736px" /></a><figcaption id="caption-attachment-31580" class="wp-caption-text">Page with left and top margins set to 0.00 cm.</figcaption></figure>
<h4>8. Customize the layout</h4>
<p>In the settings, you can also change the default spreadsheet elements to show, such as the cell grid and row/column headings (you can refer to them as coordinates).</p>
<p>Additionally, you can add custom headers and footers to the pages to accompany the documents with complimentary information, such as data sources, authors, dates, and anything else.</p>
<figure id="attachment_31591" aria-describedby="caption-attachment-31591" style="width: 736px" class="wp-caption aligncenter"><a href="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/10.png"><img decoding="async" loading="lazy" class="img-popup wp-image-31591" src="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/10.png" alt="All about print preview in Excel sheets" width="736" height="595" srcset="https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/10.png 895w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/10-300x243.png 300w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/10-768x621.png 768w, https://static-blog.onlyoffice.com/wp-content/uploads/2022/06/10-220x178.png 220w" sizes="(max-width: 736px) 100vw, 736px" /></a><figcaption id="caption-attachment-31591" class="wp-caption-text">Excel sheet with visible gridlines and added footer</figcaption></figure>
<h4>9. Study the final preview</h4>
<p>You can always scroll print preview of the Excel file to make sure that the applied settings work fine for all the pages and to check if some content was placed to another page without your intent.</p>
<p>Carefully study the preview on this final step, as this is the last chance you have before you send the document to the printer.</p>
<p>Everything ok? Go ahead and hit “Print”!</p>
<p>Print spreadsheets effortlessly with ONLYOFFICE Docs:</p>
<p style="text-align: center;"><a class="red button" style="margin: 45px; width: 130px;" href="https://www.onlyoffice.com/registration.aspx?utm_source=blog&amp;utm_medium=article&amp;utm_campaign=print_preview" target="_blank" rel="noopener noreferrer">START FREE IN CLOUD</a> <a class="red button" style="margin: 45px; width: 130px;" href="https://www.onlyoffice.com/download-desktop.aspx?utm_source=blog&amp;utm_medium=article&amp;utm_campaign=print_preview" target="_blank" rel="noopener noreferrer">GET DESKTOP EDITORS</a></p>
<div class="useful-links">
<h3>Useful links</h3>
<p><a href="/blog/?p=28416&#038;utm_source=blog&#038;utm_medium=article&#038;utm_campaign=print_preview" rel="noopener" target="_blank">How to curve texts in presentations</a></p>
<p><a href="/blog/?p=28241&#038;utm_source=blog&#038;utm_medium=article&#038;utm_campaign=print_preview" rel="noopener" target="_blank">How to create checklists in documents</a></p>
<p><a href="/blog/?p=26795&#038;utm_source=blog&#038;utm_medium=article&#038;utm_campaign=print_preview" rel="noopener" target="_blank">Transitions in presentations: a big guide</a></div>


All about print preview in Excel sheets

Recent posts

How ONLYOFFICE’s reseller Dhorde provides clients with a better document collaboration solution

10 digital planners for every taste 2023

Official ONLYOFFICE connector for Confluence Cloud released