Page 59 - TP_Plus_v4_Class4
P. 59
CHANGING THE ACTIVE CELL
To change the active cell in a worksheet, you can either use the keyboard or the mouse pointer.
When working with a mouse, just click on the cell you want to make active. Given below are the
keys and their functions to change the active cell in a worksheet using keyboard keys.
Key Function
Enter key Moves the active cell one row down
Shift + Enter key Moves the active cell one row up
Shift + Tab key Moves the active cell one column to the left
Tab key Moves the active cell one column to the right
[left arrow key] Moves the active cell one column to the left
[right arrow key] Moves the active cell one column to the right
[up arrow key] Moves the active cell one row up
[down arrow key] Moves the active cell one row down
Ctrl + Home key Moves the active cell to the first cell, i.e. A1
Ctrl + End key Moves the active cell to the last used cell on the worksheet
CREATING A NEW WORKBOOK
To create a new workbook, follow the given steps:
1 2
Click on File tab. Click on New option.
Click on Blank 3
workbook.
ENTERING DATA The text appears in
the Formula bar
To enter data in a worksheet click on the cell
where you want to enter the data and start typing
your text or numbers.
When you type in Excel, you will see that two
buttons become active in the box to the left of
the Formula bar.
#Introduction to Excel 2019 57

