ms office

Alternative Method: Selecting Cells by Dragging

1. First, click A1 cell.

2. Hold down your click and drug it to F11 cell.

3. Your excel worksheet A1 to F11 will be selected.

4. Click any cell if you deselect it.

Selecting Sells

Selecting Sells

You must at first select those cells, if you want to complete a function of a group cells. If you select a cell your selected cell will highlight a color.

1. First, click A1 cell.

2. Press F8 function key from your keyboard.

3. You see the “EXT” on the status bar in the right lower corner of the screen.

4. Now, click F11 cell.

5. Your excel worksheet A1 to F11 will be select.

6. If you want to deselect it, at first press Esc button from your keyboard and click anywhere on the worksheet.


Name Box

You can also use the Name Box to go to any special cell.

Name Box

1.        Click Name box and type B10.

2.        Press Enter key. You see your cursor move to D10 cell.

Go to – Ctrl+G

You can also use Ctrl+g for “Go To” command.

  1. At first, click A1 cell.
  2. Hold down the Ctrl key and press “g” (Ctrl+g) key from your keyboard. The “Go To” dialog box will be open.
  3. Type E5 into the “Go To” dialog box.
  4. Press Enter button from your keyboard. Your cursor should move to E5 cell.

Go to – F5

The F5 key is a function key. You can use this key for “Go To” command.  Enter the cell address to the “Go To” box and press Enter key from your keyboard. So, your cursor jumps to your choosing cell.

  1. At first, click A1 cell.
  2. Press F5 key. The “Go To” dialog box will be open.
  3. Type D5 into the “Go To” dialog box.
  4. Press Enter button from your keyboard. Your cursor should move to D5 cell.

Moving Quickly Around the Worksheet

The following are shortcuts for moving quickly from one cell to another cell in different part of the worksheet.

The Home Key

You can make use of the home key in conjunction with the end keys. It causes the cursor move to cell A1 or beginning of the data area.

  1. At first, move to your cursor J column.
  2. Move to your cursor 20 row.
  3. It will be J20 cell.
  4. Press End key from your keyboard.
  5. Press Home key form your keyboard.
  6. You will see your cursor move to the cell A1.

The End Key

end keyThe Status Bar

You can make use of the end key in conjunction with the arrow keys. It causes the cursor move to the end of the spreadsheet in direction to the arrow.

  1. At first, click A1 cell.
  2. Press the end key from your keyboard.
  3. You see the “END” on the status bar in the right lower corner of the screen.
  4. Press the right arrow key.
  5. The cursor moves right end cell of the screen.
  6. Again, press END key.
  7. Press the down arrow key.
  8. The cursor moves button cell of the screen.
  9. Again, press END key.
  10. Press the left arrow key.
  11. The cursor moves left cell of the screen.
  12. Again, press END key.
  13. Press the up arrow key.
  14. The cursor moves top cell of the screen.

Page Up and Page Down

You can make use of the Page Up and Page Down keys to move the cursor one page up or one page down at a time.

  1. At first, click A1 cell.
  2. Press Page Down key at a time.
  3. You see your cursor move to the down just one page at a time.
  4. Again, click A20 cell.
  5. Press Page Up key at a time.
  6. You see your cursor move to the up just one page at a time.

The Shift+Tab Keys

At first, hold down the shift key and press the tab key to move the page left one cell at a time.

  1. Click C3 cell.
  2. Hold down the shift-key and press tab button from your keyboard.
  3. You see your cursor move to left just one cell at a time.

The Tab Key

You can make use of the up tab key to move the page right one cell at a time.

  1. At first, click A1 cell.
  2. Press the tab key at a time.
  3. You see your cursor move to the right just one cell at a time.

The Right and Left Arrow Keys

You can make use of the right and left arrow key to move right or left one cell at a time.

  1. At first, click A1 cell.
  2. Press the right arrow key at a time.
  3. You see your cursor move to the right just one cell at a time.
  4. Again, press the left arrow key at a time.
  5. You see your cursor move to the left just one cell at a time.

The Up and Down Arrow Key

You can make use of the up and down arrow key to move up or down one cell at a time.

  1. At first, click A3 cell.
  2. Press the up arrow key at a time.
  3. You see your cursor move to the up just one cell at a time.
  4. Again, Press the down arrow key, just one time.
  5. You see your cursor move to the down just one cell at a time.

The Status Bar

The Status Bar

The Formula Bar

The Formula Bar

Toolbars

The Standard Toolbar

The Standard Toolbar

The Formatting Toolbar

The Formatting Toolbar

The Title Bar

 The Title Bar

This lesson helps to know about Microsoft Excel screen. It starts with the Title Bar, which is placed at the very top of the Microsoft Excel screen. The title bar displays the name of the worksheet you are presently using. You should see “Microsoft Excel – Book1” at the top of the screen.

The Task Pane

The task pane will show right side of the Excel window. If you want to close it, click x button like picture.

The Task Pane

 

The Microsoft Excel Window

This is Microsoft Excel basics tutorials. Although knowledge of how to find the way in a windows environs, this tutorial was created for the beginner and expert computer learner.

After open Microsoft Excel, the picture likes show below.Microsoft excel window

   
© Biswasbd 2011-2017 All Rights Reserved