Align text correctly in Excel

However, there are many people who are familiar with manual alignment, adjusting the ruler ruler but forgot how to set the alignment in Excel.

Step 1: How to align margins in Excel

You open Excel on a computer. First, to be able to align the margins, we need to change Excel's default unit of measurement to centimeters. We will click the Button on the same interface and select Excel Options.

Align text correctly in Excel Picture 1

Step 2: How to align margins in Excel

Next, in the new Excel Options window view, click on Advanced in the left menu. Go to the right interface, scroll down to the content below the Display section. Here, we will proceed to convert the units from inches to centimeters. In the Ruler units section, click the arrow and choose Centimeters.

Align text correctly in Excel Picture 2

Finally click OK.

Step 3: How to align margins in Excel

Next to align the margins, in the Excel interface, select the Page Layout tab, select Margins and then select Custom Margins right below.

Align text correctly in Excel Picture 3

Step 4: How to align margins in Excel

The Page Setup window appears. Here, we select the Margins tab, and then format the alignment in the categories including Left (left), Right (right), Top (top), Bottom (bottom), Header (header), Footer (end title). ) according to each person's alignment purposes.

Align text correctly in Excel Picture 4

When you have finished aligning the alignment, click on Print Preview to view the whole page content after aligning. If it is aligned with the margin you want to align, click OK to save.

Thus, we have completed each step of alignment for Excel. The document will print according to the margin size we have set. If you want to change the margins for Excel, you only need to change 6 sizes in Page Setup.

excel margins excel

Lesley Montoya

Update 13 April 2020

You should read it

May be interested

How to create Text Box in Excel
text box on excel is similar to creating on word, helping you create artistic text frames, attracting content viewers.
Guide to full Excel 2016 (Part 7): Format spreadsheet data
if you have seen the article about microsoft word, then you also have some basic knowledge about text alignment. please refer to the article of formatting spreadsheet data in excel 2016 in this article!
Text - Text in CSS
the article explains how to format text in css.
Show you how to align the printed Excel file with A4 paper
before printing, we need to align the data to fit in the a4 size of the print media. this will be a very detailed and extremely helpful tutorial for you
How to align an Excel page so that when it fits on A4 page
unlike word, excel is a spreadsheet format that extends horizontally and vertically, so sometimes the data on an excel sheet extends beyond an a4 sheet of printed paper. therefore, when you want to print an excel document that fits perfectly into an a4 page, you need to follow the following tips of tipsmake.com.
How to align text in Word 2019, 2016, 2013
text alignment in word is very important to meet standard presentation requirements. let's learn with tipsmake how to align text in word from versions 2019 to 2003, helping to create beautiful, standard documents.
How to insert Excel into CAD quickly and correctly
instead of calculating in cad, we usually calculate the size of the drawing through excel and insert the excel file into the cad. if you do not know how to insert excel into cad, you should follow the tutorial below!
How to align correctly in Word
alignments in word have standard rules issued to agencies, institutions and schools to align the word margins properly.
How to indent the line in Excel
when you enter data into a spreadsheet, excel automatically aligns with cells containing numbers to the right of the cell, and text input cells are automatically located to the left of the cell.
Complete Word 2016 tutorial (Part 20): Align, align, and group objects
when using word, sometimes you need to use multiple objects such as images, shapes, text box, graphics. you can organize these objects by aligning, grouping, organizing and rotating them in different ways. this will make your document look more creative, beautiful and special. please follow the article below for details!