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
* Excel Spreadsheet Layout
- rodit
- Famous
- Posts: 228
- Joined: 02 Feb 2008 02:39
- Family Historian: V7
- Location: Wollongong, New South Wales, Australia
Excel Spreadsheet Layout
- Attachments
-
- Screenshot 2021-11-23 152033.jpg (21.98 KiB) Viewed 1336 times
-
- Screenshot 2021-11-23 151941.jpg (14.65 KiB) Viewed 1336 times
- BillH
- Megastar
- Posts: 2257
- Joined: 31 May 2010 03:40
- Family Historian: V7
- Location: Washington State, USA
Re: Excel Spreadsheet Layout
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
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
Bill Henshaw
- dewilkinson
- Superstar
- Posts: 286
- Joined: 04 Nov 2016 19:05
- Family Historian: V7
- Location: Oundle, Northamptonshire, England
- Contact:
Re: Excel Spreadsheet Layout
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.
David Wilkinson researching Bowtle, Butcher, Edwards, Gillingham, Overett, Ransome, Simpson, and Wilkinson in East Anglia
Deterioration is contagious, and places are destroyed or renovated by the spirit of the people who go to them
Deterioration is contagious, and places are destroyed or renovated by the spirit of the people who go to them
-
- Superstar
- Posts: 269
- Joined: 08 Jan 2004 16:53
- Family Historian: V7
- Location: Thatcham, Berkshire, England
Re: Excel Spreadsheet Layout
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
Tried to post an image on here but couldn't
Vctor
- rodit
- Famous
- Posts: 228
- Joined: 02 Feb 2008 02:39
- Family Historian: V7
- Location: Wollongong, New South Wales, Australia
Re: Excel Spreadsheet Layout
Thanks, gents. I found it just after posting yesterday. I have Excel 2019 and the solution is as you both suggested.
Thanks again
Roger
Thanks again
Roger