Page 24 - Plus_V2.2_C6_Flipbook
P. 24
Tech Hint
To copy, cut and paste the content
of the cells the shortcut keys used
in Excel:
• To Copy: Ctrl + C
• To Cut: Ctrl + X
• To Paste: Ctrl + V
Pasting contents of a cell
COLUMN WIDTH AND ROW HEIGHT
On a worksheet, you can specify a column width of 0 to 255 and 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 of a cell, follow these 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
Row Height dialog box Column Width dialog box
Automatically Fit Column/Row Content
To automatically fill column or content of a cell, follow these steps: Select All button
Step 1: Click the Select All button.
Step 2: Double-click any boundary between two column/row
headings.
Step 3: All columns/rows in the entire worksheet will be
changed to the new size. Selecting entire worksheet
22 Premium Edition-VI

