ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how can I view what each cell contains at the top of my page? (https://www.excelbanter.com/new-users-excel/164864-how-can-i-view-what-each-cell-contains-top-my-page.html)

HH

how can I view what each cell contains at the top of my page?
 
I used to be able to see what I was typing into each cell at the top of the
page. That is now missing from my spreadsheet. There was an = sign at the
beginning of it. How do I get it back? Now using Vista...

OssieMac

how can I view what each cell contains at the top of my page?
 

You say you are using Vista but that is the operating system. Do you mean
xl2007? If so then:-

Click Microsoft button (Large button top left of screen)
Excel Options (towards bottom right of dialog box)
Advanced (Left column)
Scroll down to header Display in right side of dialog box
check option show formula bar


Regards,

OssieMac


"hh" wrote:

I used to be able to see what I was typing into each cell at the top of the
page. That is now missing from my spreadsheet. There was an = sign at the
beginning of it. How do I get it back? Now using Vista...



All times are GMT +1. The time now is 04:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com