* Excel Spreadsheet Layout

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile
Post Reply
User avatar
rodit
Famous
Posts: 213
Joined: 02 Feb 2008 02:39
Family Historian: V7
Location: Wollongong, New South Wales, Australia

Excel Spreadsheet Layout

Post by rodit » 23 Nov 2021 04:41

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
Attachments
Screenshot 2021-11-23 152033.jpg
Screenshot 2021-11-23 152033.jpg (21.98 KiB) Viewed 214 times
Screenshot 2021-11-23 151941.jpg
Screenshot 2021-11-23 151941.jpg (14.65 KiB) Viewed 214 times

User avatar
BillH
Megastar
Posts: 1743
Joined: 31 May 2010 03:40
Family Historian: V7
Location: Washington State, USA

Re: Excel Spreadsheet Layout

Post by BillH » 23 Nov 2021 05:21

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

User avatar
dewilkinson
Superstar
Posts: 259
Joined: 04 Nov 2016 19:05
Family Historian: V7
Location: Oundle, Northamptonshire, England
Contact:

Re: Excel Spreadsheet Layout

Post by dewilkinson » 23 Nov 2021 09:11

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
Screenshot 2021-11-23 090926.jpg (94.78 KiB) Viewed 175 times
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

avatar
victor
Famous
Posts: 214
Joined: 08 Jan 2004 16:53
Family Historian: V7
Location: Thatcham, Berkshire, England

Re: Excel Spreadsheet Layout

Post by victor » 23 Nov 2021 10:23

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

User avatar
rodit
Famous
Posts: 213
Joined: 02 Feb 2008 02:39
Family Historian: V7
Location: Wollongong, New South Wales, Australia

Re: Excel Spreadsheet Layout

Post by rodit » 24 Nov 2021 01:22

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

Post Reply