Page 55 - TP_Pluse_V2.2_Class_5
P. 55
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.
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, when the Excel application is
already running, follow the given steps: 1
Step 1: Click on File tab. The backstage view appears.
Step 2: Click on New in the left pane. A new pane appears on
the backstage view.
Step 3: Click on Blank workbook.
2
Tech Hint
To open a new 3
workbook: Ctrl + N
ENTERING DATA
To enter data in a worksheet, follow the given steps:
Step 1: Click on the cell where you want to enter the data.
Introduction to Excel 2016 53

