Page 68 - iPrime_V2.2_class7
P. 68
Tech Funda
Similar to Word, 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 Word, Excel also allows you to use the Undo and Redo commands. The Undo command
reverses the most recent action you performed in the worksheet and can undo multiple actions
sequentially. Conversely, the Redo command reverses the last action that was undone. Both
commands can be accessed from the Quick Access Toolbar located at the top-left corner of the
Excel window. You can also use the Ctrl + Z key and Ctrl + Y key to Undo and Redo respectively.
COLUMN WIDTH AND ROW HEIGHT
In a worksheet, you can set a column width ranging from 0 to 255 characters and a row height
from 0 to 409.5 points. The column width represents the number of characters that can be
displayed in a cell using the default font size. The default column width is 8.43 characters, and
the default row height is 15 points. If a column or row is set to a width or height of 0, it becomes
hidden and will not be visible in the worksheet grid.
Set Column Width/Row Height
To set the column width/row height, follow these steps:
Step 1 Select the column(s) or row(s) whose width or height you want
to change.
Step 2 Click on the Format command in the Cells group under the
Home tab.
Step 3 Select the 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 Type the desired value in the Column Width or Row Height
text box.
Setting column width
Row Height dialog box Column Width dialog box
66 Touchpad iPRIME (Ver. 2.2)–VII

