Thursday, 9 June 2022

Entering Data || Moving Around a Worksheet

                     Entering Data

To enter data in a Worksheet, follow the given steps :
Step 1 : To make a cell active, click inside it.
Step 2 : Type the required data. The data will appear in the Formula bar also.
Step 3 : Press the Enter key or click on the Enter button on the Formula bar.
Step 4 : If we want to cancel the entered data, click on the Cancel button or press the Esc key.

   Moving Around a Worksheet 

We can move around a Worksheet either using the mouse or using the keyboard. We can click on any cell to make it active for editing. This following table lists some of the keys and the key combinations that let us easily move around in a Worksheet. 


Command Move the cell pointer to
Arrow keys Up, down, right or left of the current cell
Tab Next cell in a row
Shift + Tab Previous cell in a row
Enter One cell down in a column
Shift + Enter One cell up in a column
Ctrl + Home First cell of the current worksheet
Ctrl + End Last used cell on a spreadsheet
Page up One screen up
Pagle down One screen down

No comments:

Post a Comment