***Please note this page may include affiliate links, from which I may receive compensation. I only advertise for companies I trust.***
|Basic Parts of an Excel Spreadsheet|
In this lesson, you will learn the basic parts of an Excel spreadsheet: columns, rows, cells, worksheet name, formula bar, menu bar, and toolbar.
Columns are the vertical bars on the spreadsheet. Columns are labeled with letters, beginning with A. In the below spreadsheet, column A is highlighted in yellow.
Rows are the cells that run horizontally. Runs are labeled with numbers, beginning with the number 1. In the below spreadsheet, row 1 is highlighted in green.
A cell is an individual block of the Excel spreadsheet. We use cell names to narrow down to specific locations of a spreadsheet. A cell is named first by its column and then by its row. In the below spreadsheet, the highlighted cell is cell B2.
In Excel, every tab of an Excel spreadsheet is a worksheet. The worksheet name is located below the bottom row of the spreadsheet. In the spreadsheet below, this worksheet is named Worksheet 1. You can rename worksheets by right-clicking on the name and typing in the new name.
The formula bar is located directly above the column labels. When a formula has been entered in a cell and the cell is selected, you will see the formula that is being calculated in that particular cell. In the below spreadsheet, the cell A1 is selected, and the formula being calculated in that cell is C1*B2, so 3 times 4.
The menu bar includes the menu. The parts of the Excel spreadsheet menu include the following: File, Home, Insert, Page Layout, Data, Review, and View.
The tool bar is located at the top of the spreadsheet underneath the menu bar. It includes functions, such as cut, copy, paste, wrap text, and merge & center. The functions available depend on which menu is selected. In the below spreadsheet, the home menu is selected, so the home toolbar is showing.
You are on your way to excelling at the basics of Excel.
All the best,