On the ribbon tab Home | group Alignment, you can specify the alignment of the cell contents within the cell.
Before you execute the commands, you must first select the desired cells. To change a single cell, simply navigate to it.
Then proceed as follows:
Aligning directly via the icons of the command group "Alignment"
Most of the options for aligning cell contents can be applied directly via the icons on the ribbon tab Home | group Alignment.
The following functions are available here:
Icon |
Function |
|
Top vertical alignment: Align the cell content with the top edge of the cell. |
|
Centered vertical alignment: Align the cell content vertically with the center. |
|
Bottom vertical alignment: Align the cell content with the bottom edge of the cell. |
|
Justified vertical alignment: The cell content is evenly distributed between the top and bottom cell border (only affects cells that contain multiple lines of content and have the option Wrap text enabled). |
|
Rotate: Here, you can rotate the entire cell (including its contents) around the selected angle. The command Stacked corresponds to the option Vertical text in the dialog box (see below): The cell content is not read from left to right, but from top to bottom. To disable it, click on Stacked again. |
|
Wrap text: The cell content will be automatically wrapped to the next line (inside the cell) if the cell width is insufficient to display it in a single line. |
|
Merge cells: This option lets you merge a cell with its neighboring cells. PlanMaker treats merged cells as if they were one single cell. To do so, select the cell and any number of directly adjacent cells, and click on the icon itself to merge the cells. Note: Whenever you merge cells, the content of all selected cells is automatically deleted – except for the cell in the upper left corner of the selected range. To split merged cells, click on the icon again. |
|
If you click on the icon's arrow, you can choose from various options for merging cells: Merge cells: This corresponds to clicking on the icon itself, and all selected cells are merged normally. Merge and center: The selected cells are merged and the cell content is centered horizontally over several columns (vertically at the bottom). Merge and turn on line wrap: Cells are merged while wrapping the cell contents in the created merged cell. If you selected cells across multiple columns and rows, you can choose between the commands Merge by row or Merge by column to merge the selected cells to only one column or only one row. Here in the menu also, you can use the entry Split cells to separate merged cells. |
|
Default horizontal alignment: Text is left-aligned, numbers are right-aligned. Logical values and error values are centered. |
|
Left horizontal alignment: Align the cell content with the left edge of the cell |
|
Centered horizontal alignment: Align the cell content centered |
|
Right horizontal alignment: Align the cell content with the right edge of the cell |
|
Justified horizontal alignment: The cell content is evenly distributed between the left and right cell border (only affects cells that contain multiple lines of content and have the option Wrap text enabled) |
Most of these options can also be found in the dialog box of the command group Alignment (see below). In addition, the options enabled via the direct ribbon commands are displayed as enabled in the dialog box. If, for example, the ribbon command Wrap text is enabled for a cell, a check mark also appears in the dialog box in front of the option Wrap text.
Shortcut keys
There are also shortcut keys for horizontal alignment:
Command |
|
Windows/Linux |
|
Mac |
|---|---|---|---|---|
Left align |
|
Ctrl+L |
|
Cmd+L |
Center |
|
Ctrl+E |
|
Cmd+E |
Right align |
|
Ctrl+R |
|
Cmd+R |
Justify |
|
Ctrl+J |
|
Cmd+J |
Aligning via the dialog box of the command group "Alignment"
You open the dialog box on the ribbon tab Home by clicking on the group arrow
in the bottom right corner of the command group Alignment. In the dialog box, you will find additional options that cannot be set directly via the icons of the command group Alignment as described above (for example, Inner margins).
The dialog box contains the following options on the "Alignment" tab:
Horizontal alignment
This determines the horizontal alignment of the cell content within the cell boundaries:
Default: Text left-aligned, numbers right-aligned, and logical values and error values centered
Left: Align the cell content with the left edge of the cell
Centered: Align the cell content horizontally with the center
Right: Align the cell content with the right edge of the cell
Justified: The cell content is evenly distributed between the left and right cell border (only affects cells that contain multiple lines of content and have the option Wrap text enabled)
Center across columns: The content of one cell is centered across multiple columns. For this purpose, select the cell and any number of adjacent cells to the right of it (these cells have to be empty!). Then select the Center across columns alignment.
Vertical alignment
This determines the vertical alignment of the cell content within the cell boundaries:
Bottom: Align the cell content with the bottom edge of the cell
Centered: Align the cell content vertically with the center
Top: Align the cell content with the top edge of the cell
Justified: The cell content is evenly distributed between the top and bottom cell border (only affects cells that contain multiple lines of content and have the option Wrap text enabled).
Rotate by ...
Here, you can rotate the entire cell (including its contents) around the selected angle.
Text direction
For text in Arabic script, you can change the text direction of the cell to right-to-left here. If you select the default setting Context-sensitive, PlanMaker sets the correct writing direction automatically.
For more information, see also Working with Arabic text.
Inner margins
Here, you set the inner margins of cells.
Line break
If this option is enabled, the cell content will be automatically wrapped to the next line if the cell width is insufficient to display it in a single line.
By default, this option is disabled.
Tip 1: You will also find this option via the context menu by right-clicking on a selected cell.
Tip 2: You can use the key combination Ctrl+↵ to wrap to the next line manually.
Vertical text
If this option is enabled, the cell content will be displayed vertically (top to bottom instead of left to right).
Merge cells
This option lets you merge a cell with adjacent cells. To do so, select the cell and any number of directly adjacent cells and enable this option.
PlanMaker treats merged cells as if they were one single cell.
Note: Whenever you merge cells, all cells except the upper left cell lose their contents.
To split merged cells, select them again and disable this option.