Slider

How to Set Horizontal Alignment in Excel as Fill

Date:2019-7-31 Author:Cordelia

In Home tab of Excel, you can set the horizontal alignment as Align Left, Align Center or Align Right easily. But if you want to make the content you typed to fill a cell automatically no matter how wide the cell is, these basic alignments may can’t satisfy you.

How to Set Horizontal Alignment in Excel as Fill

Take this table as an example. I input an underline in the cell next to “Total” and want it to fill up the whole cell.

How to Set Horizontal Alignment in Excel as Fill

First, make sure your cursor is not inside the cell. Then right-click the cell and choose Format Cells… in the menu.

How to Set Horizontal Alignment in Excel as Fill

When the Format Cells window pop out, switch to Alignment window.

How to Set Horizontal Alignment in Excel as Fill

Click the small arrow to open the drop-down list of Horizontal. Select Fill and hit OK to confirm it.

How to Set Horizontal Alignment in Excel as Fill

Now the cell you select is filled up by the underline. Even when you widen the cell, the underline will fill the wider cell automatically.

How to Set Horizontal Alignment in Excel as Fill

How to Set Horizontal Alignment in Excel as Fill

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *