Free Sample Genealogy Excel Spreadsheets
This site is hosted by:
News (22nd April 2016)
There is now a macro in these spreadsheets that will build a $$INDEX page for you. It can be executed using CTRL+i.
While working on my family tree I try to keep
things organised by using Excel spreadsheets to compliment my Legacy database.
One that holds census research notes
and one that holds GRO record notes.
Both spreadsheets contain code to make adding new family worksheets easier and for sorting the worksheets alphabetically. They will also auto adjust the columns to fit the entered text, therefore they are MS Excel 2007 workbooks.
All macros and code are entirely 100% safe and do nothing more than simplify the addition and organisation of the spreadsheets.
To add a new worksheet you press ctrl and m. To sort the worksheets you press ctrl and s.
If you want to tinker around with the default headings etc. you will need to 'unhide' the '$$Code' worksheet, make your changes and then save the worksheet. Existing worksheets will remain unaffected but all new spreadsheets will use your new style.
Note that any changes made to the $$Code worksheet will be reflected only in any new family worksheets.
The census spreadsheet also now contains a sheet named $$Dates which lists the dates that the UK Censuses were taken.
Last modified :Wednesday, 4th May, 2016