Page 32 - ModularV1.1 _c7_flipbook
P. 32
Tech
Funda Similar to MS Word, MS Excel also allows us to use shortcut keys to copy,
cut and paste the content of the cells. The shortcut keys are:
To Copy: Ctrl + C To Cut: Ctrl + X To Paste: Ctrl + V
USING UNDO AND REDO FEATURES
Similar to MS Word, MS Excel also allows to use the Undo and Redo commands. The Undo
command is used to reverse the previous action that you have performed in the worksheet. With
the help of this command, you can reverse more than one action. On the other hand, the Redo
command is used to reverse the the last Undo. You can access both the commands from the
Quick Access Toolbar located at the top-left corner of the MS Excel 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 are 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 these steps:
Step 1 Select the column(s) or row(s) whose width or height is to be changed.
Step 2 Click on Format command in Cells group from Home tab.
Step 3 Choose Column Width or Row Height under the 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 width or row height to be.
Row Height dialog box Column Width dialog box Setting column width
Automatically Fit Column/Row Content
To set column width or row height automatically, 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
Selecting entire worksheet
the new size.
30 Modular (Ver. 1.1)-VII

