* Excel Spreadsheet Layout

[rodit]

This has nothing to do with FH, but I am looking for help to rectify a problem I have somehow created in Excel.
I am attaching 2 Snips, one shows the top of a spreadsheet as it should be with A1 circled The second shows mine with without this Row. What I have done, I don't know and it will probably be something so obvious.
Thanks in advance
Roger

[BillH]

Looks like maybe the Formula Bar has been turned off.

I don't know what version of Excel you are using, but in Excel 2010 which is the version I have, I would try going to the View tab, and in the Show section I would select Formula Bar if it is not already selected. If it is already selected, I would de-select it and then select it again. In later versions it is probably similar to this.

Bill

[dewilkinson]

As Bill says it is the Formula Bar that has been turned off. On my version you need to go to View and tick the Formula Bar box as per below.

Screenshot 2021-11-23 090926.jpg (94.78 KiB) Viewed 1300 times

[victor]

I have the latest version of excel which is called Excel workbook ending with .xlsx
Tried to post an image on here but couldn't

Vctor

[rodit]

Thanks, gents. I found it just after posting yesterday. I have Excel 2019 and the solution is as you both suggested.
Thanks again
Roger