10 ways to Move in a worksheet in Excel 2007

---

To move around in a worksheet, you can use the arrow, Tab, Page Up, Page Down and Enter Keys. Look down, to see how these keys can be used to move around in a worksheet.

1. The Right Arrow Key
Press the right arrow key several times and notice that right adjacent cell to current active cell will get active.

2. The Down Arrow Key
Press the down arrow key several times and notice that bottom adjacent cell to current active cell will get active.

3. The Left Arrow Key
Press the left arrow key several times and notice that left adjacent cell to current active cell will get active.

4. The Up Arrow Key
Press the up arrow key several times and notice that top adjacent cell to current active cell will get active.

5. The Tab Key
Press the Tab key several times and notice that right adjacent cell to current active cell will get active. The difference between tab and right arrow key is that when you are modifying a cell content, tab will still function in the same way as mentioned but Right arrow key will traverse through character by character in the cell.
Example: 1. Change the value of cell A1 to “Hello Excel”.
2. Select cell A1 and press F2. Now try left and right arrow keys.
3. Now Press Tab.

I hope the difference must be cleared now.

6. The Shift-Tab Key Combination
Press the Shift-Tab key several times and notice that left adjacent cell to current active cell will get active.

7. The Page Down Key
Press the Page Down key several times and notice that cursor or selected cell moves down by one page.

8. The Page Up Key
Press the Page Up key several times and notice that cursor or selected cell moves up by one page.

9. The Ctrl+Home Key Combination
Press the Ctrl+Home key from any selected cell and cursor will move to cell A1 always.

10. The Ctrl+End Key Combination
Press the Ctrl+End Key Combination and notice that cursor or selected cell moves to the last cell (last column and last row of used range).

---

How to edit or modify a cell in Excel 2007?

---

1. Using Formula Bar.
a. Select the cell of which contents needs to be changed.
b. Click the formula area of formula bar.
c. Place your cursor according to modification and use backspace/delete key to remove the undesired contents and insert new data by simply entering it.

2. Using F2 key.
a. Select the cell of which contents needs to be changed.
b. Press F2 key.
c. Place your cursor according to modification and use backspace/delete key to remove the undesired contents and insert new data by simply entering it.

3. Using Double Click.
a. Double click on the cell of which contents needs to be changed.
b. Place your cursor according to modification and use backspace/delete key to remove the undesired contents and insert new data by simply entering it.

4. Replace the cell contents.
a. Select the cell of which contents needs to be replaced.
b. Start typing the new data. (Remember, its replacement not modification, so old data will be replaced with new content, you’ve just typed.)

---

How to Enter and Delete data in Excel 2007 ?

---

1. Enter Data in a Cell.
a. Select the cell in which you want to enter the data.
b. Type some data and press Enter.
c. If you need to correct what you’ve entered, please read the next post or type backspace before step b.

2. Delete Data from a Cell.
a. Select the cell of which you want to delete the data.
b. Press Delete.
*Note: Read next post (How to edit a cell?), if you only need to delete some characters, not the whole data of a cell.

---

Select Cells using keyboard and Mouse in Excel 2007

---

To select or activate specific cells or a group of cells, we can use variety of ways to go through them. Some of them are listed and explained below.

1. The Name Box
Like “Go to” explained in previous post, the NAME Box can also be used to go to a specific cell. Just type the cell you want to go to in the NAME box and then press Enter.

---

2. Select last (or first) cell in a range.
 Use any of the keyboard combinations to move to the first (or last) cell in a range:
   i. Ctrl+Down Arrow –> Move to last cell vertically (Alternate: [End] then Down Arrow)
   ii. Ctrl+Up Arrow –> Move to first cell vertically (Alternate: [End] then Up Arrow)
   iii. Ctrl+Right Arrow –> Move to last cell horizontally (Alternate: [End] then Right Arrow)
   iv. Ctrl+Left Arrow –> Move to last cell horizontally (Alternate: [End] then Left Arrow)

---

3. Select the last cell of worksheet in used range.
  As we keep on enter the data in a worksheet, Excel keeps on storing the address of the last used cell. To find out which cell is the last used cell in the used area in active worksheet,
    a. Using Keyboard
        i. Press Ctrl+End key combination.
    b. Using Mouse
        i. Click Home
        ii. Click Find & Select
        iii. Click “Go to Special…”
        iv. Select “Last cell”
        v. Click Ok.

---

4. Select the first cell (A1) of Worksheet.
    Press Ctrl+Home key combination.

---

5. Select a group of cells / Select an contiguous range area of worksheet.
    a. Using Mouse
        i. Select top-left cell of the desired range to be selected.
        ii. Press Left button of mouse and don’t release it until asked.
        iii. Keep moving mouse and you can see the selected range area in different color.
        iv. Reach to the bottom-left cell of the desired range.
        v. Release the left mouse button.
    b. Using Keyboard
        i. Select top-left cell of the desired range to be selected.
        ii. Press F8 key to anchor the cursor.
        iii. Select bottom-left cell of the desired range.
        iv. Press Esc.

---

6. Select Non-adjacent cells.
    a. Using Mouse
        i. Select top-left cell of the desired range to be selected.
        ii. Press Ctrl and don’t release it until asked.
        iii. Select desired ranges.
        iv. Release the Ctrl button.
    b. Using Keyboard
        i. Press Shift-F8 key to anchor the cursor. Sentence “Add to selection” will appear in status bar.
        ii. Select desired ranges.
        iii. and when you’re done, press Esc to toggle off the option of non-contiguous selection.

---

7. Select Horizontal range of adjacent cells.
   Use any of the keyboard combinations to select the horizontal range of adjacent cells:
        i. Ctrl+Shift+Right Arrow –> Select horizontal range of adjacent cells which contains data from left to right.
        ii. Ctrl+Shift+Left Arrow –> Select horizontal range of adjacent cells which contains data from right to left.

---

8. Select vertical range of adjacent cells.
    Use any of the keyboard combinations to select the vertical range of adjacent cells:
        i. Ctrl+Shift+Up Arrow –> Select vertical range of adjacent cells which contains data from bottom to top.
        ii. Ctrl+Shift+Down Arrow –> Select vertical range of adjacent cells which contains data from top to bottom.

---

9. Select the current region.
    Continuous range of cells that contains data around the selection (including the selection) is termed as current region. thus, current region is always enclosed by either blank rows or blank columns or blank cells or all.
    a. Using Keyboard
        i. Press Ctrl+Shift+8.
    b. Using Mouse
        i. Click Home
        ii. Click Find & Select
        iii. Click “Go to Special…”
        iv. Select “Current region”
        v. Click Ok.

---

Move between Worksheets and Open Workbooks

---

Move between Worksheets

An excel workbook can contain a large number of worksheets. In such cases, switching between the sheets is difficult using a mouse. In addition, if the sheets name are long, this could further increase the problem of selection. apart from annoying method of selecting tabs from mouse, you can use any of the following available methods:

Using Keyboard
Use Ctrl+Page Down key combination to select next sheet in active workbook
and similarly, use Ctrl+Page Up key combination to select previous sheet in active workbook.

Using shortcut menu
1. Look at the bottom-left of worksheet (to the left of sheet tabs), there are small arrow buttons.

2. Place the mouse pointer over one of the arrows and right click.
3. A shortcut menu, displaying all the sheets will appear, select your sheet from there.

---

Move between Open Workbooks
Using Mouse
1. Click view.

2. Click Switch Windows and choose a workbook from list of open workbooks.

Using Keyboard
1. Use Ctrl+F6 or Ctrl+Tab key combination to move forward through list of open workbooks.
2. Similarly, use Ctrl+Shift+F6 or Ctrl+Shift+Tab key combination to move backward through list of open workbooks.

---

View more data in a worksheet

---

An Excel worksheet contains thousands of columns and millions of rows, but if your data is spread even over a hundreds of rows and columns, it becomes difficult to view the data. Depending on the data and requirement, you can magnify or reduce the selected data region to the size of window.

---

1. Fit Selection to size of window
a. Press Ctrl+* (Ctrl+Shift+8 key Combination). This will select the active used range region.
b. Click View.

c. Select Zoom.

d. Select Fit selection.

e. click ok.

---

2. Magnify or reduce the view size of selected region
a. To magnify the worksheet view, move the Zoom Slider(placed in bottom right of the workbook) to right.

b. To reduce the worksheet view, move the Zoom Slider(placed in bottom right of the workbook) to left.

---

3. Increase the amount of data (Fullscreen view)
This will hide the ribbon, formula bar and status bar, allowing you to view more amount of data without magnifying or reducing the workshet view.
a. Click View.

b. Select FullScreen.

---

Introduction to Microsoft Excel 2007 and its components

---

Objective: This tutorial will navigate through Introduction to Microsoft Excel 2007 and its components. Knowledge of windows environment will be helpful, however tutorial is prepared for a computer novice.

---

Open Microsoft Excel 2007

Microsoft Excel is an electronic spreadsheet that can be used to organize data rows and columns, to perform mathematical calculations quickly and can also be programmed to send your mails at pre-defined time.

If you have purchased a valid licensed copy of Microsoft Excel 2007 then open it following the instructions given below:
1. Go to Start –> Programs –> Microsoft Office –> Microsoft Excel 2007

---

The Microsoft Excel 2007 Window

The Microsoft Excel 2007 window appears and our screen looks similar to the one shown here.

Screen always might not look exactly like the screen shown. In Excel 2007, display of window depends on the size of the monitor and the resolution to which the monitor is set. Resolution determines how much information the computer monitor can display. A low resolution means less information fits on the screen, but the size of text and images are larger. Inversely, a high resolution means more information fits on the screen, but the size of the text and images are smaller. Also, settings in Excel 2007, Windows Vista, and Windows XP allow you to change the color and style of your windows.

---

The Microsoft Office Button

Look at the upper-left corner of the Excel 2007 window, it is the Microsoft Office button. When you click this button, a menu will appear. This menu can be used to create a new file, open an existing file, save a file, and perform many other tasks.

---

The Quick Access ToolBar

Right to the Microsoft Office button is the Quick Access toolbar. The Quick Access toolbar gives access to commands we frequently use. By default, Save (to save your files), Undo (to rollback an action), and Redo (to reapply an rolled back action) appear on the Quick Access toolbar.

---

The Title Bar

Next to the Quick Access toolbar is the Title bar. On the Title bar, Microsoft Excel displays the name of the workbook, which is currently in use.

---

The Ribbon

We use commands to tell Microsoft Excel what to do. In Microsoft Excel 2007, we use the Ribbon to issue commands. The Ribbon is located near the top of the Excel window and below the Quick Access toolbar. At the top of the Ribbon are several tabs; clicking a tab displays several related command groups. Within each group are related command buttons. Buttons are clicked to issue commands or to access menus and dialog boxes. You may also find a dialog box launcher in the bottom-right corner of a group. When you click the dialog box launcher, a dialog box makes additional commands available.

---

The Formula Bar

If the Formula bar is turned on, then in the Name box (located on left side) it displays the cell address of the cell you are in. Cell entries which can be a values or formulas are displayed on the right side of the Formula bar. To turn on the Formula bar in Excel 2007 window, perform the following steps:

1. Click the View tab.
2. Click Formula Bar in the Show/Hide group. The Formula bar appears.

---

The Status Bar

The Status bar appears at the bottom of the Excel 2007 window and provides quick information such as the count, sum, average, minimum, and maximum value of selected numbers. We can change what displays on the Status bar by right-clicking on the Status bar and selecting the options we want from the Customize Status Bar menu. We just need to click a menu item to select it and click it again to deselect it. A check mark appearing next to an item means the item is selected.

---

The Worksheet

Microsoft Excel 2007 consists of worksheets (Default Names are “Sheet1”, “Sheet2” and “Sheet3”). Each worksheet contains columns and rows. The columns are lettered A to Z and then continuing with AA, AB, AC to AZ and then continuing with AAA, AAB and so on up to XFD (total columns are 16384); the rows are numbered 1 to 1,048,576.

The combination of a column coordinate and a row coordinate defines a cell address. For example, the cell located in the upper-left corner of the worksheet is cell A1, meaning column A, row 1. Cell C7 is located under column C on row 7. We enter our data into the cells on the worksheet.

---

1. Enter Data in a Cell.
a. Select the cell in which you want to enter the data.
b. Type some data and press Enter.
c. If you need to correct what you’ve entered, please read the next post or type backspace before step b.

2. Delete Data from a Cell.
a. Select the cell of which you want to delete the data.
b. Press Delete.
*Note: Read next post (How to edit a cell?), if you only need to delete some characters, not the whole data of a cell.

---

Go to Cells Quickly in Excel 2007 ( Home –> Find & Select –> Go to )

---

1. Open “Go to” Window
  a. Using Mouse
      i. Click Home.

      ii. Click “Find & Select”
      iii. Select “Go to”

  b. Using Keyboard
      i. Press F5 or Ctrl+G key combination.

2. In the reference field, type the name of cell. e.g. J10, B5, AE100
    (*Note: Column name appear first in this style, followed by Row number.)

3. Click Ok

---