Excel Worksheet Example
Name Office Assistant
Select all Cell reference Cell
Column Header Horizontal split box
Row Header Range
Sheet Tab Vertical split box
♦ The cell reference appears in the upper left box, called the Name Box, and indicates the active cell,
indicating it by column letter and row number. In this example the active cell is C5.
♦ The formula bar shows the contents of the active cell named in the Name Box. You may enter or
edit information and formulas in the formula bar.
♦ The column header is the letter in the gray shaded area at the top of the worksheet.
♦ The row header is the number in the gray shaded area at the left of the worksheet.
♦ A cell is the intersection between a column and a row.
♦ A range is a group of cells selected together. A range is indicated by the upper left cell and the
lower right cell separated by a colon. In this example the range is C5:G7.
♦ The cell pointer is the heavy black border around the active cell or range.
♦ The Fill Handle is the small black square in the lower right hand of the cell pointer. Clicking and
dragging the Fill Handle allows you to automatically fill all the selected cells with text or formulas.
This process is known as Autofill.
♦ The Horizontal and Vertical split boxes allows you to scroll in sections of the worksheet separately.
♦ The Office Assistant (unlike in other Microsoft programs!) can be a useful source of help, especially
with functions and formulas. It’s usually worthwhile putting up with him for that reason.
♦ The Select all allows you to select the whole worksheet.
♦ The Sheet Tab indicates which worksheet you are working in. It can be renamed by double clicking
the tab and typing a new name.
Putting Excel to Work in the Library Fall 2004 - This material has been created by Sandy Lamoureux for the Infopeople Project [infopeople.org],
supported by the U.S. Institute of Museum and Library Services under the provisions of the Library Services and Technology Act, administered in
California by the State Librarian. Any use of this material should credit the author and funding source.