Loading....
Coupon Accepted Successfully!

 

Move Around the Worksheet

The Down Arrow Key:- Press the down arrow key several times. Note that the cursor moves downward one cell at a time. If you will press shift +down arrow key then you can move to last row of the worksheet.
 
The Up Arrow Key:- Press the up arrow key several times. Note that the cursor moves upward one cell at a time. If you will press shift +up arrow key then you can move to first row of the worksheet.
 
The Right Arrow Key:- Press the right arrow to move left right side of the cell. Note that the cursor moves right one cell at a time. If you will press shift +right arrow key then you can move to first row of the worksheet.
 
The left Arrow Key:- Press the left arrow key to move to the left side of the cell. Note that the cursor moves left one cell at a time. If you will press shift +left arrow key then you can move to first column of the worksheet.
 
The Tab Key:-
  • Move to cell A1.
  • Press the Tab key several times. Note that the cursor moves to the right one cell at a time.
The Shift+Tab Keys
  • Hold down the Shift key and then press Tab. Note that the cursor moves to the left one cell at a time.
The Ctrl-Home Key
  • Move the cursor to column J.
  • Stay in column J and move the cursor to row 20.
  • Hold down the Ctrl key while you press the Home key. Excel moves to cell A1.
Go To Cells Quickly
 
The following are shortcuts for moving quickly from one cell in a worksheet to a cell in a different part of the worksheet.
 
Press F5:- The F5 function key is the "Go To" key. Steps are given below to move on to desired cell
  • Press F5. The Go To dialog box opens.
  • Type J3 in the Reference field.
  • Press Enter. Excel moves to cell J3.
Press Ctrl+G:- There is a another way to go to a specific cell.
  • Hold down the Ctrl key while you press "g" (Ctrl+g). The Go To dialog box opens.
  • Type C4 in the Reference field.
  • Press Enter. Excel moves to cell C4.
The Name Box:- This is the third way to go to the specific cell. Just type the cell you want to go to in the Name box and then press Enter.
Minimize and Maximize The Ribbon
Follow the step to maximize and minimize the ribbon which is given below:-
  • Right click anywhere in the main menu.
  • Select the Minimize the Ribbon in the menu that appears. This will toggle the Ribbon ON and OFF.
 
In the available option you can choose the option as per your choice.

Add Command to Quick Access ToolBar

To add command with the help of Quick access ToolBar follow the following steps:-
  • Click the arrow to the right of the Quick Access ToolBar
  • Select the command which you want to add from the available menu. Then command will appear in the toolbar.
 

Change Page View

There are so many view available on EXCEL. You can change view from the Page View option available in the bottom of the worksheet. These view options are:-
  • Normal:- This is the default view
  • Page Layout:- This is very helpful from printing point of view. When you select this view, then you can be able to see the margin, vertical and horizontal rulers and column and row headings.
  • Page Break:- This is very important view. This view can determine where the page will break when you are trying to print an excel sheet that spanjs multiple pages.




Test Your Skills Now!
Take a Quiz now
Reviewer Name