Page 71 - TP_iPlus_V2.1_Class7
P. 71
Cut, Copy, and Paste Data
We can use the Cut, Copy, and Paste commands in Excel to move or copy entire cell content. The
Cut command moves the content to a new location, removing it from its original location.
With the Copy command, content is copied to the new place and also exists in its original place.
The Paste command is used to paste the copied/cut data.
When you move or copy a cell, Excel moves or copies the entire cell contents with cell formatting.
To do so, follow the given steps:
2 Click on the Cut/Copy option in the
Clipboard group under the Home tab.
To move, click on the Cut option. To 4 Click on the Paste option on the
copy, click on the Copy option. Clipboard group under the Home tab.
1 Select the cells that you want to move 3 Click on the cell where you would like to
or copy. paste the copied data.
Quick Byte
Similar to Word, Excel allows the use of 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
i + 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 the Ctrl + Y key to Undo and Redo respectively.
i + 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.
69
More on Spreadsheets

