Learning Resources
 

MS-Excel Interface and Moving in a worksheet

Worksheet Interface
MS-EXCEL Window Elements
Microsoft Excel is a Spreadsheet package that is widely used for financial purposes. The workspace called the workbook is divided into a number of sheets called the worksheet.  It has following parts

  • Menu Bar
  • Status Bar
  • Row and Row Number
  • Column and Column Number
  • Cell
  • Cell Address
  • Workbooks   
  • Worksheets   
  • Work Sheet tabs

Moving around a worksheet
To move between cells on a worksheet, click any cell or use the arrow keys. When we move to a cell, it becomes the active cell. To see a different area of the sheet, use the scroll bars.

 

To scroll

Do this

One row up or down

Click the arrows in the vertical scroll bar.

One column left or right

Click the arrows in the horizontal scroll bar.

One window up or down

Click above or below the scroll box in the vertical scroll bar.

One window left or right

Click to left or right of scroll box in the horizontal scroll bar.

A large distance

Drag the scroll box to the approximate relative position. In a very large worksheet, hold down SHIFT while dragging