Page 74 - PlusGPT_V2.1_C7_Flipbook
P. 74
On the other hand the Redo command is used to reverse the last Undo command or action. You can
access both the commands from the Quick Access Toolbar located at the top-left corner of the Excel
2016 window. You can also use the Ctrl + Z key and Ctrl + Y key to Undo and Redo respectively.
Column Width and Row Height
On a worksheet, you can specify a column width of 0 to 255 and a row height of 0 to 409. This value
represents the number of characters that can be displayed in a cell that is formatted with the standard
font. The default column width is 8.43 characters and the default row height is 15 points. If a column/
row has a width or height 0, it is hidden, i.e., it is not visible in the grid.
Set Column Width/Row Height
To set column width or row height, follow the given steps:
Step 1: Select the column(s) or row(s) whose width or height you want to change.
Step 2: Click on Format command in Cells group from Home tab.
Step 3: Choose Column Width or Row Height under
Cell Size section from the drop-down list.
A Column width or Row height dialog box
will appear.
Step 4: In the Column Width or Row Height box,
type the value that you want your column or
row to be. Setting column width
Step 5: Click on OK button to get new row height / column width.
Row Height dialog box Column Width dialog box
Select All button
Automatically Fit Column/Row Content
To set column width or row height automatically, click on the Select All
button. Double-click any boundary between two column/row headings. All
columns/rows in the entire worksheet will be changed to the new size. Selecting entire worksheet
Tech Fact
At times, a cell might display #####. This can occur when the cell contains a number
or a date that exceeds the width of the cell so it cannot display all the characters
that its format requires. To see the entire contents of the cell with its current format,
you must increase the width of the column.
72 Premium Edition-VII

