Shrink to fit - Reduces the size of the font to whatever is necessary so that all the data fits into the cell. Wraps text into multiple lines in a cell. Wrap text - Allows you to wrap text in multiple lines with a cell. Selecting Wrap Text disable the Shrink to Fit and vice versa. Shrink to Fit and Wrap Text are mutually exclusive. Justify Distributed - This option is only available if you select "Distributed (Indent)" in the Horizontal alignment and the number of indents is set to 0. Justify - Expands the spaces between the individual lines to align the text at the top and bottom.ĭistributed - Spreads the words evenly from top to bottom. Top - (Default setting) Aligns the cell contents at the top.Ĭentre - Aligns the cell contents in the middle.īottom - Aligns the cell contents at the bottom. The vertical alignment adjusts the top to bottom position of your cell contents. Notice that Justify does not justify the very last line of text, only the lines that spill over (see above screen shot). This is preferred to Merging the cells since you can still cut or copy the rows or columns that intersect with it.ĭistributed (Indent) - This allows you to distribute the contents evenly across the whole cell. Select the cells that you were going to merge and apply this format. The text has been entered in cell B2, and then centred across the cell range "B2:F2".Įnter the text in the left most column. Justify - Aligns text to the right and left of the cell.Ĭentre Across Selection - This allows you to centre text across a selection of cells, without the disadvantages of actually merging the cells. If any blank cells to the right of this cell also have the Fill format then these are filled as well. Right (Indent) - Aligns data to the right.įill - Repeats the contents of the selected cells until the cell is full. You can also use the shortcut key (Ctrl + Alt + Tab) to increment the number of indents used in the active cell. This is based on the width of one character in the default Normal style and you can indent up to 15 ? General - (Default setting) Aligns text to the left and numbers to the right. The horizontal alignment adjusts the left right position of your cell contents. This provides options for aligning the contents of your cells. Merge and Centre - Combines 2 or more adjacent cells to create a single cell. Increase Indent - Increases the indent by 1.ĭecrease Indent - Decreases the indent by 1 or removes the indent completely. Align Left - Aligns data to the left of the cell.Ĭentre - Aligns data in the middle of the cell.Īlign Right - Aligns data to the right of the cell.
0 kommentar(er)
