From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using the Formula bar

Using the Formula bar

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Using the Formula bar

“

- On an Excel screen, the area just below the ribbon is referred to as the formula bar. The formula bar right here, contains information if the active cell contains information. If I click, for example, in cell B3, we see that it contains "Jan." Now the reason it's called the formula bar is if I press the down arrow on this worksheet here called "Profits," if I go down to cell B5, we see it's the value 100. Now if I saw that and didn't go down to the next cell just yet, I'd say the cell below it has the value 20 in it. But as I push the down arrow, we see that cell B6 contains a formula. That's why it's called the formula bar. As you work with Excel, and maybe you haven't worked with it at all just yet, you get used to the idea of looking at the formula bar. Because as you move the active cell around, either by pressing arrow keys or pointing with the mouse and clicking somewhere, you want to know whether a cell contains a value, or text, or a formula. And it becomes almost second…

Contents