Instructions for quickly aligning Excel printed pages, printing to fit the paper, without losing columns

To work with tables best, we should use the Microsoft Office 2016 office suite. Office 2016 fully integrates Excel 2016, Word 2016, Power Point 2016. and many other tools. The Office 2016 interface is also easier to use for users, especially when combining this toolkit with Windows 10.

Not only that, you can also install Vietnamese language for Excel to use this software more easily. How to install Vietnamese Office 2016 helps you change the default English of this toolkit. After creating the table and entering data in Excel, you should align the Excel printed page. In addition to the rather cumbersome procedure to enter Page Setup, you can quickly align Excel printed pages with the following trick.

Instructions for quickly aligning Excel printed pages

Step 1: Open Excel, select View .

Instructions for quickly aligning Excel printed pages, printing to fit the paper, without losing columns Picture 1

Step 2: Select Page Layout.

Instructions for quickly aligning Excel printed pages, printing to fit the paper, without losing columns Picture 2

Step 3: Move the mouse to the ruler position above. Click and drag the line to the edge of the page.

Instructions for quickly aligning Excel printed pages, printing to fit the paper, without losing columns Picture 3

The border will be as narrowed as possible.

Instructions for quickly aligning Excel printed pages, printing to fit the paper, without losing columns Picture 4

Do the same with the remaining side border.

Instructions for quickly aligning Excel printed pages, printing to fit the paper, without losing columns Picture 5

You will receive a reasonably arranged page as shown.

Instructions for quickly aligning Excel printed pages, printing to fit the paper, without losing columns Picture 6

Above are instructions for quickly aligning printed pages in Excel. This trick will save you time aligning pages before printing.

In Excel, we also have great tricks like hiding formulas in Excel. This is a way to help you hide formulas in Excel , preventing viewers from seeing these formulas. In addition, you can also see other Excel tips on TipsMake.


Excel supports many mathematical functions to help users calculate faster, especially with basic functions in Excel such as SUM, MAX, MIN. To fully grasp the basic functions in Excel, you need to find It takes a lot of research and practice to be able to memorize and use it smoothly.


4 ★ | 1 Vote

May be interested

  • How to combine 2 columns Full name in Excel does not lose contentHow to combine 2 columns Full name in Excel does not lose content
    in excel, to be able to merge content in 2 columns into a single column without losing content, we need to use calculation functions.
  • How to rotate paper size in ExcelHow to rotate paper size in Excel
    rotating horizontal or vertical paper sizes on excel is a basic operation before printing or setting form formats for content. so how to rotate paper on excel?
  • Instructions for alignment in Excel - Adjust the margins for Excel before printingInstructions for alignment in Excel - Adjust the margins for Excel before printing
    you need to print excel documents, so the printed documents are beautiful and not skewed, you need to align the margins before printing. this article tutorials alignment in excel - adjust excel margins when printing.
  • How to print Excel on 1 A4 page - Display full content on 1 pageHow to print Excel on 1 A4 page - Display full content on 1 page
    when printing an excel file, if the content is long and converted to 2 printed pages, how can i display the excel document content on only 1 a4 page?
  • How to print multiple pages on one sheet of paper in Word 2010, 2013How to print multiple pages on one sheet of paper in Word 2010, 2013
    you can print from 2 to 16 pages on a sheet of a4 paper, this technique is used when printing small documents, helping to reduce printing costs. how to do it will be shared by free download right after this.
  • How to Print Multiple Single Sided Pages in Adobe ReaderHow to Print Multiple Single Sided Pages in Adobe Reader
    instead of printing a single-sided pdf page, you can print multiple pdf pages on one side of the paper. this way of printing is called n-up, where 'n' is the number of any pdf pages (2, 4, 6 ...) that you want to print on 1 side. for example, 6-up is when you print 6 pdf pages on 1 side of paper. printing multiple single-sided pdf pages allows us to reduce printing costs and limit waste.[1] x research source
  • Instructions on how to print 2 sides in excel wordInstructions on how to print 2 sides in excel word
    in this article tipsmake shows you how to print on both sides of the paper for printers that do not support the simple and fast duplex printing function.
  • How to align printed pages in ExcelHow to align printed pages in Excel
    excel is an office application that supports quite well in printing, and you can see the print results immediately on the computer screen you are using, in the following article, tipsmake will guide you how to align. page editing in excel, invite you to follow along.
  • How to print parity pages in ExcelHow to print parity pages in Excel
    printing parity pages in excel will not be as simple as printing parity in word because it does not have odd pages or even pages functionality. so to make a parity page print in excel, we need to follow a different method. before you can even print odd pages in excel, you need to check the page numbering
  • How to convert columns into rows and rows into columns in ExcelHow to convert columns into rows and rows into columns in Excel
    you need to convert excel columns into rows or convert data in excel rows into columns, if retraining takes a lot of time, just a trick that network administrator instructs below, you can turn the rows into columns or columns into rows extremely easy.