Justify, Fill, Orientation, Shrink to Fit and other Excel formatting tricks.


Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

The Format Cells dialog can be accessed from Home | Alignment | Orientation, or by right-clicking on selected cells and selecting Format Cells.

See Excel’s text and number alignment choices

Text formatting in Excel with wrapping, line breaks and merging

This dialog gives you more detailed options to choose from than are available in the Orientation menu.

justify fill orientation shrink to fit and other excel formatting tricks microsoft excel 30163 - Justify, Fill, Orientation, Shrink to Fit and other Excel formatting tricks.

Text Alignment

In addition to the horizontal and vertical alignments described above, the Format Cells dialog has a few additional options.

Horizontal | Fill

Horizontal | Fill will duplicate the text as many times as required to fill up the cell.

img 5d50932943cae - Justify, Fill, Orientation, Shrink to Fit and other Excel formatting tricks.

Horizontal | Justify

Horizontal | Justify spaces the text out so that it is distributed evenly across the cell, except for the last line.

justify fill orientation shrink to fit and other excel formatting tricks microsoft excel 30165 - Justify, Fill, Orientation, Shrink to Fit and other Excel formatting tricks.

Horizontal | Center Across Selection

Horizontal | Center Across Selection will center the text across a range of selected cells.

justify fill orientation shrink to fit and other excel formatting tricks microsoft excel 30166 - Justify, Fill, Orientation, Shrink to Fit and other Excel formatting tricks.

Horizontal | Distributed

Horizontal |Distributed, like Justified, also spaces the text out so that it is distributed evenly across the cell, but in this case the last line is also spaced out across the cell, even if it is much shorter. This may lead to very uneven spacing.

justify fill orientation shrink to fit and other excel formatting tricks microsoft excel 30167 - Justify, Fill, Orientation, Shrink to Fit and other Excel formatting tricks.

Vertical Alignment

The Vertical dropdown  has the Top, Center, and Bottom options as described above, as well as Justified and Distributed, both of which space the lines of text out evenly up and down the cell.

justify fill orientation shrink to fit and other excel formatting tricks microsoft excel 30168 - Justify, Fill, Orientation, Shrink to Fit and other Excel formatting tricks.

Orientation

While the Orientation button described above allows you angle text diagonally across the cell, the Orientation section of the Format Cells dialog gives you more fine-grained control, so that you can angle the text in whatever direction you want (within 90 degrees clockwise or counter-clockwise – you cannot turn text upside down!)

justify fill orientation shrink to fit and other excel formatting tricks microsoft excel 30169 - Justify, Fill, Orientation, Shrink to Fit and other Excel formatting tricks.

Set your own text angle

To set the angle, you can either drag the needle on the dial to the position you want, or enter the number of degrees in the box below the dial.

Text Control

Under this section we have options to make text fit into a cell when it is currently overflowing the boundaries. There are two ways of doing this.

Wrapping text has been dealt with in our previous article on text formatting, but here we have another option –

Merge two or more cells together, has also been covered earlier.

Shrink to Fit

Shrink the text size is really handy. Instead of tweaking the font size, just click ‘Shrink to Fit’ and let Excel handle it.

justify fill orientation shrink to fit and other excel formatting tricks microsoft excel 30170 - Justify, Fill, Orientation, Shrink to Fit and other Excel formatting tricks.

Shrink to Fit cannot be used in conjunction with Wrap Text – it’s one or the other. The idea is to shrink the text enough that it fits in the cell as one line.

This choice is advisable only for text that is only slightly too large for the cell. If you try to use this option on longer text, it will become too small to read!

I have applied Shrink to Fit to the entire header row, and each heading has been slightly adjusted in size so that it fits in the column.

justify fill orientation shrink to fit and other excel formatting tricks microsoft excel 30171 - Justify, Fill, Orientation, Shrink to Fit and other Excel formatting tricks.

Shrink to Fit will, naturally, change the font size for each cell which makes for an awful column headings.  Use it during development, then switch to a consistent font size later.

subs profile e1563205311409 - Justify, Fill, Orientation, Shrink to Fit and other Excel formatting tricks.
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address