Guidance on how to align Excel correctly
Aligning margins in Excel or Word is essential, helping us to have better text and data pages, more standard formats after completion and after printing Excel. However, there are quite a few people who are familiar with manual Excel alignment, adjusting alignment margins and forgetting how to set alignment in Excel. In this article, Network Administrator will show you how to align standard in Excel.
Steps to align in Excel standard format
Step 1:
You open Excel on the computer. First to be able to align Excel margins, we need to change the default unit of Excel to cm . We will click on Button on the same interface and select Excel Options .
Step 2:
Next, in the new Excel Options window, click on Advanced in the left menu. To the right interface, scroll down to the content below the Display section. Here, we will proceed to change the unit from inch to cm. In the Ruler units section, click on the arrow and select Centimeters . Finally click OK .
Step 3:
Next to align the margin, in the Excel interface, select the Page Layout tab, select Margins and select Custom Margins right below.
Step 4:
The Page Setup window appears. Here, we select the Margins tab, then format the alignment in items including Left (left), Right (right), Top (top), Bottom (bottom), Header (first title), Footer (last title ) depending on the purpose of aligning each person.
Once the alignment is complete, click Print Preview to see the full page content after aligning it. If it is standard with the margin you want to align, click OK to save.
As such, we have completed each step of standard alignment for Excel. The document after printing will follow the margin size that we have set. If you want to change the margin for Excel, you only need to change the 6 sizes in the Page Setup.
Video tutorials align on Excel
Refer to the following articles:
- Summary of expensive shortcuts in Microsoft Excel
- These are the most basic functions in Excel that you need to understand
- You want to print text, data in Microsoft Excel. Not as simple as Word or PDF! Read the following article!
I wish you all success!
You should read it
- Default print margins in Excel
- Instructions for alignment in Excel - Adjust the margins for Excel before printing
- Summary of expensive shortcuts in Microsoft Excel
- MS Excel - Lesson 5: Excel formulas and functions
- MS Excel 2003 - Lesson 2: Format spreadsheet data
- Guidelines for importing Chemistry formulas in Excel
- Tips for adding in Excel you need to know
- How to align printed pages in Excel
- Instructions on how to copy formulas in Excel
- How to fix the SUM function doesn't add up in Excel
- Instructions for searching and replacing in Excel tables
- What is ### error in Excel? how to fix ### error in Excel
Maybe you are interested
Excel 2016 - Lesson 12: Formatting pages and printing spreadsheets in Excel
How to turn off auto formatting in Excel
Here's What to Do Before Sharing an Excel Spreadsheet
How to use the TREND function in Excel
How to create Progress Bar in Excel, conditional progress bar
How to change auto save time on Excel, Auto Save Excel File