Easy way to print settings in Microsoft Excel - KING OF EXCEL

Thursday, January 23, 2020

Easy way to print settings in Microsoft Excel

Easy way to print settings in Microsoft Excel

If there is any big or small data in Excel, setting up the print is very difficult initially. Taking today we will learn to print in some simple way.

Page break preview

Page break preview option is the easiest and best for Excel Print setting. This allows you to set the page correctly and can also set the page properly with the option of drag and drop.
Let's learn how to do print settings in Excel.

1. Click on view option from Excel Main Tab.
2. Click on the page break preview option
3. The page view will be truncated. Set Normal to 100% with Zoom option.

How to print settings in excel excel print Setting and Setup | Page Break Preview |

Shortcuts of all the options will also appear on the status bar.
How to print settings in excel excel print Setting and Setup | Page Break Preview |

If there is large data, then margin has to be set. And the page will have to be adjusted.
On clicking the page break preview option, some data is visible on the second page. You can drag the blue line to set it on a page. But can't drag too much. If you include a page by dragging more columns, the view in print can be very small. When adjusting the column from the blue line, the Adjust to value from the page option in the page setup window can be less than 100%, adjust it in your own way.

How to print settings in excel excel print Setting and Setup | Page Break Preview |

Page Layout - Custom Margin

There is some extra space in the four sides on the printed page. To reduce it
1. Click on the page layout option from the main tab of Excel
2. Click on the margin option. On clicking, the default option will appear in the drop down. (You can also use that option.)
3. Click on Last option custom margin.

How to print settings in excel excel print Setting and Setup | Page Break Preview |

4. A new window of page setup will open.
How to print settings in excel excel print Setting and Setup | Page Break Preview |

5. Set the margin from the top left, right, bottom, header and footer value.


Print option (Ctrl + P) can also open the window of print setup.

How to print settings in excel excel print Setting and Setup | Page Break Preview |

#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

Popular Posts