Page 271 - Trackpad IT-402_Class-IX
P. 271
NAVIGATION IN A WORKSHEET
Given below are some shortcut keys to move the active cell in a worksheet.
Key/Keys Combination Explanation
↑
Arrow keys Moves a single cell in the direction of the arrow key
← ↓ →
↑ Moves the cell to the end/beginning of the row/column
Ctrl + Arrow keys
← ↓ → moving in the direction of the arrow key.
Home Moves to the first cell of the current row.
End Moves to the last cell containing the text of the current row.
Pg Dn Moves one screen down in the worksheet.
Pg Up Moves one screen up in the worksheet.
Ctrl + Home Makes A1 the active cell.
Ctrl + End Makes the last cell on the sheet with data as the active cell.
F2 Enters the active cell into the edit mode.
Ctrl + F2 Opens the Function Wizard.
Shift + Ctrl + F5 Moves the cursor to the Name Box of the formula bar.
Find out the address of the:
uiz Bee • first cell of a worksheet. • last column name.
• last cell of a worksheet. • first row number.
Subject: To rename a sheet
A sheet can easily be renamed by using the given steps:
1. Double click on the sheet tab. It will open the Rename Sheet dialog box.
2. Delete the existing sheet name and type a new name.
3. Press the Enter key.
ENTERING DATA
The data is always entered in an active cell. You can make the cell active by selecting it. Follow the given steps to enter
data in a spreadsheet.
Step 1: Select a cell.
Step 2: Type the data in the cell.
Electronic Spreadsheet 271

