Change Column Width and Row Height
To change the width
of a column or
the height of a row:
§ Click the Format button on the Cells group of the Home tab
§ Manually adjust the height and width by clicking Row Height or Column Width
§ To use AutoFit click AutoFit Row Height or AutoFit Column Width
Hide or Unhide Rows or Columns
To hide or unhide rows
or columns:
§ Select the row or column you wish to hide or unhide
§ Click the Format button on the Cells group of the Home tab
§ Click Hide & Unhide
Merge Cells
To merge cells select the cells
you want to merge and click the Merge & Center
button on
the Alignment group of the
Home tab. The four choices
for merging cells
are:
Merge &
Center: Combines the
cells
and centers the contents
in the
new, larger cell
Merge Across: Combines the
cells across columns without centering data
Merge Cells: Combines
the cells in a range without centering
Unmerge Cells: Splits the cell
that has been merged
Align Cell Contents
To align cell contents, click the cell
or cells you want to align and click on the
options
within the Alignment group on the Home tab. There
are several options
for alignment of cell contents:
Top Align:
Aligns text to the top of the cell
Middle Align:
Aligns text between the
top
and bottom of the cell
Bottom Align: Aligns text to the
bottom of the cell
Align Text Left: Aligns text to the left of the cell
Center: Centers the text from left to
right in the
cell
Align Text
Right: Aligns text to
the right of
the cell
Decrease Indent: Decreases the
indent between the left border
and
the text Increase Indent:
Increase the indent between the left border and the
text Orientation:
Rotate the text diagonally or vertically
.jpg)
0 comments:
Post a Comment
Enter your comments to JoxTech