Ask Sawal

Discussion Forum
Notification Icon1
Write Answer Icon
Add Question Icon

How to center on excel?

3 Answer(s) Available
Answer # 1 #
  • Select the cells that have the text you want aligned.
  • On the Home tab choose one of the following alignment options:
  • To vertically align text, pick Top Align , Middle Align , or Bottom Align .
  • To horizontally align text, pick Align Text Left , Center , or Align Text Right .
[5]
Edit
Query
Report
Rosario Flora
Vedette
Answer # 2 #

Click Page Layout > Margins > Custom Margins. In the Page Setup dialog box, under Center on page, select Horizontally and Vertically. This will center the sheet on the page when you print.

[4]
Edit
Query
Report
Lokesh Taylor
OIL PIPE INSPECTOR
Answer # 3 #

This Excel tutorial explains how to center text across multiple cells in Excel 2016 (with screenshots and step-by-step instructions).

Question: I want to center text across multiple cells in Microsoft Excel 2016 but I don't want to have to merge the cells. How can I do this?

Answer: Select the cells that you wish to center the text across.

Right-click and then select "Format Cells" from the popup menu.

When the Format Cells window appears, select the Alignment tab. Click on "Center Across Selection" in the drop-down box called Horizontal.

Now when you return to your spreadsheet, you should see the text centered across the cells that you selected.

[0]
Edit
Query
Report
Aanjjan Bania
BARREL LATHE OPERATOR INSIDE