Do You Know What You’re Looking For?

Sometimes, I like to surf through editions of “The Adair County News” found on the Chronicling America section of the Library of Congress because I occassionally run across an unexpected tidbit for one of my ancestors and to get a flavor for the timenegative-one-degrees.

You might see some information to give you a little background on what was happening in the life of your ancestor.




Or read about a political scandal:



Usually they included a lot of local news (gossip?) for Russell County, including this gem for a new store in Russell County which apparently sold “Dry Gods” and “Booots”! (So happy for spell check now!)


Each section of local news contained a header with the name of the community that was reporting. But did you know that the names of some of the towns in Russell County changed over time?

If you’re looking for a section for Russell Springs, you’d better know how the town name changed over time.

This area was known as “Big Boiling Springs” by 1850. There were many mineral springs in the area which were sought after for their health-giving properties and eventually, (by the 1890’s) it became a resort area with a 25 room hotel and a 10 room motel.

“Big Boiling Springs” became “Russell Springs” by 1855, but by 1888, the town was named “Kimble”. In the earliest editions of “The Adair County News”, Kimble is what you should be looking for.

The name “Russell Springs” made a come-back in 1901 and it has kept it’s name since that time.

Civil War Pension Cards Bonus

I’ve been doing some research on an ancestor who served in the Civil War and I was  happy to find Pension Index Cards for this individual on 3 different sites – but that wasn’t the bonus. The bonus was that the two cards were not the same!


Fold3 and FamilySearch



The top card was from Fold3 and it matched the card found on FamilySearch. The bottom card was from Ancestry, but it had the added information of the wife’s name and the date in which the Widow’s Pension aplication was filed – which has helped me to narrow down the date of death significantly. I think in the back of my mind, I knew there were different versions of the card, but I’ve been so focus on Revolutionary War times, I have to get my brain back in gear!

I’ve done some research on the subject and some excellent information can be found on the LegacyTree Genealogists web page. Click here to read their article. But the outline of the information is this:

  • At some point in the process of accounting for all the soldiers who applied and received Civil War pensions, two series of cards were created – each with a slightly different purpose and organizational strategy.
  • The set on Fold3 (NARA T289) is organized by geographic and military units. (You can click through the cards to see everyone who served in a specific unit.)
  • Lisa’s note – the cards on FamilySearch are the same as the cards on Fold3, but they are arranged alphabetically.
  • The Fold3 cards will often (though not always) contain the soldier’s death date at the bottom.
  • The set on Ancestry (NARA T288) is organized alphabetically by the soldier’s last name.
  • The Ancestry card will frequently include the name of the soldier’s widow or other dependents as well as the state from which the applications were filed.

But did you also know that there’s an additional index which can be helpful if you can’t clearly read the numbers on these cards? NARA A1158 has the pensions indexed by number for the Army or Navy service in the Civil War and later. This can be found on Fold3 here.  At this time, it is only 20% complete but the ones that have been completed are indexed by name. When you look at the application and certificate numbers, you can currently find some cards for numbers between 1-276585. If you think a number that you are looking at is between those two numbers, you might be able to confirm the number using this index. Isaac’s numbers are not in this range so here’s another example.



This is an Index Card found on Fold3 for Elias Smith. Perhaps I don’t know that this is the correct Elias because the name was pretty common in the area and no wife is mentioned. (Although in this case, the note about Andrew Stephens is a good clue!) Let’s see what Ancestry has.





The card on Ancestry does contain the name of the widow – Victoria (Coffey) Smith, my great-great grandmother! For this example, the numbers are pretty clear, but let’s say I wanted to confirm a number. Using the Numerical Index on Fold3, I’ve found a card for 226845 – the widow’s certificate. Notice that the number is found in the upper, left corner, but there are 4 names on this card. (Some cards contain up to 32 names because of the number of wars these cards refer to!)



Numerical Index on Fold3

On this card, I see that there is an invalid application (orig.) #226845 for Joseph Showman (along with the certificate number), an invalid certificate #226845 for Henry Rasenbrauck, a dependant application (M could mean “mother” or “minor”) #226845 for Amos Treat and finally, a dependent (W means “widow) certificate #226845 for Elias Smith. This shows me that the number I’m trying to decipher is correct.

A couple of abbreviations I’ve discovered in my research for this index: C = “child”, F = “father”, M = “mother” or “minor” and S = “sisters”. Orig is the application and Ctf is the certificate.

I found this card by click through the number breakdown supplied on the Fold3 site, but I did notice that while the numbers are in a range, they are not all in numerical order, so don’t give up – make sure you look through the entire list for that range. I’d suggest doing a name search first. The problem with name searches is that names may not be spelled the way you expect, so think through your options there.

Finally, one more index to consider! The Index to Pension Application Files of Remarried Widows (NARA M1785) can be found on Ancestry here. When I did a search for “Victoria” with a spouse named Elias Smith (you can also do a search with just the veteran’s name, leaving the spouse blank), I found this (bottom left):


One more way to find that application or certificate number. I also noticed that the filing date on this card is quite a bit after the dates given on the Pension Index cards, so something else to dig in to.

If you have a Civil War pension index for an ancestor, you might want to check to see if you have found all the information that can be found! You just might receive some bonuses as well!


Ancestor Inventory Form

I’ve added the Excel Ancestor Inventory Form to the Downloads tab at the top of the screen. Here are a few hints that I’ve put together as I’ve worked with the form:

Page 1:


  • Siblings could be changed to FANs (Family, Associates, Neighbors)
  • The “Notes” area at the bottom could be removed or shortened to make room for additional children. (See “P1 Six Census”) If you have a lot of FANs you are tracking, the “Notes” section could be used for that information.
  • Column C beginning with row 11 is to be used to list all known family members for tracking through census years.
  • Begin the census lists after the marriage year. There may not be room to list all census records for an entire lifetime, but you’re pretty safe if you begin after a marriage. Years that an ancestor was still living with their parents can be listed on P2.
  • If more than one marriage (and if you have space), you can insert a Spouse into the “children” area and begin numbering their children with 1. DOB for the spouse could be changed to DOM (date of marriage).
  • If 10 or fewer children, space can be added to indicate who each child married. (See “P1 9 Children and P1 Six Census”)
  • In each census column, type the name and the age to help you match each person correctly.
  • Shade the boxes for family members who have died. If deceased, type in the date of death and location if known. If married, indicate who they are recorded with and give location.
  • If a person is listed in the household, but is not a child, give the relationship (if known) on the 2nd line.

Page 2:


  • In the first form, space is given for 3 spouses. Any sections not needed can be changed to a different category such as “Children” or “To Do”. (See P2 One Spouse)
  • If some Spouse information is not known, you might want to change categories to “Father:” and “Mother:”
  • Information for various records could be locations or book and page numbers – whichever is most helpful to you. Could also just be “yes” or “no” to indicate if you have the record.
  • All categories can be edited. For example, if an ancestor was born in the US, you won’t need “Passenger List” and “Naturalization”. Most of the ancestors we research did not receive SSNs, so that could be edited out as well.
  • Because Census information is listed on page 1, the Census column on page 2 could be edited to something else. It was included to be a “mini-timeline” of locations without having to turn the paper over.
  • Every census year was included in the list. If you need space, you can edit the list to only include census years for an ancestor’s lifetime, then create a new section at the bottom.


  • Before you begin to enter information for an ancestor, be sure to click on the “File” tab and then “Save As” a new document with your ancestor’s name so that you will always have a blank form to use again.
  • You might decide to keep an entire surname in one workbook with multiple names. To do this:
    • Select the blank sheet you’d like to use, right click on that tab at the bottom of the screen.
    • Click on “Move or Copy”.
    • Check the box at the bottom that says “Create a Copy”.
    • Select the location you’d like the new tab to be. (You can also rearrange sheets by dragging the tabs to a new location.)
    • Rename the tab with your ancestor’s name. (Right click, select “Rename”.)
  • I’ve created a few different versions of the sheets as I’ve worked with my ancestors. Some families had many children and others did not. “Blank P1” has space for 14 children. There is also a version for 9 children and a version for 10 children. There could be hundreds of variations, so be creative!
  • Most of my ancestors only had one spouse, so space was added to have a list of children (with spouses below, if there was enough space) and a “To Do” list. If an ancestor had 2 spouses, I would keep the “To Do” list because the children are listed on the P1 pages.
  • To type a bullet in a cell, type alt+7. (There are other symbols as well. Play around with the numbers with the alt key to see other options.)
  • Some ancestors did not live during the years in which tax records have been microfilmed. In “P3 Films no Tax”, I edited that space to allow me to make a list of FHL microfilms I’ve ordered or have access to. (These could also be hyperlinks to images available on FamilySearch.)
  • If you want to replace a section with another section (for example, if you need another area for a spouse instead of children in a P2 sheet), you may need to un-merge cells in the section you are replacing because Excel won’t paste into merged cells unless everything is identical to the area you are copying:
    • Highlight the section you’d like to replace
    • Click the “Merge & Center” icon on the “Home” ribbon (this will un-merge everything)
    • Highlight the section you’d like to copy and type Ctrl+C
    • Click the top left cell in the section you are replacing and type Ctrl+V
    • You will probably have to re-merge cells to make the layout work correctly

If you have question about how to do something, feel free to leave me a comment and I’ll try my best to give you some help!

Ancestor Inventory

Happy New Year!

I’ve been thinking about how I’ve been doing my genealogy and I’d like to make some changes for 2017. (Wouldn’t everyone?) I tend to become obsessed with a specific ancestor and every other ancestor gets left out of the fun.

Recently, I have begun to dig into using DNA in my research and because of that, I’ve created a public tree on Ancestry to link the results to. I decided that as I added each person to the tree, I would look through the hints and do a quick search for any “low hanging fruit” and I was quite surprised at how many records were out there that I hadn’t taken the time to look for before because I’ve been focused so fiercely on John M. Smith. Because I was finding so much information on collateral family members, I thought about how I really have no idea exactly what I DO have for each ancestor because it’s been so long since I’ve even looked at any family other than my Smith line.

So I decided that I needed to take an “inventory” for each ancestor to see what I have and what I should be looking for. I wanted to be able to look at one sheet of paper per family to give me a quick idea of what I’ve already found. I went out to Pinterest to see what I could find and then I took my favorite ideas and created my own inventory using…..Excel, of course!


I started with a form that I found on the “Are My Roots Showing?” blog. That form can be found here.  I made just a few changes to that form, but wanted more so I also found inspiration from the Mid-Continent Public Library and their Research Checklist found here. I’ve taken these ideas and put together a 2 page inventory that I intend to fill out for each family group in my tree. As I fill it out, I’ll run my “quick search” to find the easy records that I’ve been missing out on all this time and then I’ll create a Research Plan for each family.


I thought others might be interested in using a form like this as well, so I’m going to add it to my “Downloads” tab at the top of the page, so check back tomorrow for that link as well as some tips I’ve collected as I’ve begun to work with the form. Every ancestor is unique so the form is a great way for me to make sure I’ve covered all my bases, but each form needs to be tweaked to make the best use of space. For example, if I know an ancestor did not have more than one spouse, then I can use that space to jot down a “To Do” list as things come to mind so I don’t forget to add anything to my Research Plan.

I still have a couple of things in mind to add to the form, so I plan to finish that up tonight and post them tomorrow, but I thought you might enjoy a little heads up!

Need to Create a Quick Christmas Gift?

I don’t know why, but I’m always shocked at how little time I have to work on my genealogy between Thanksgiving and Christmas! You’d think I’d wake up and smell the coffee about how busy this time of year always is for me…and I’d imagine for you as well!

I know that I have 1 more video to go in my Excel series on creating a database in Excel, but I thought that I’d throw in a “bonus” video for the holidays for those that might be looking for a quick way to add a background image to an Excel document like a Family Group Sheet or 5 Generation Chart.

Betty's Chart.png


I’ve added my blank 5 Generation Chart created in Excel to the “Downloads” tab at the top of the page, so if you don’t already have one on your computer, feel free to download mine. One specific thing I’d like to point out is that my Chart contains cells for adding military information for the men while the women have the information for the marriage. If you have a female ancestor who served in the military, that’s a quick update that you can make.

Also, my chart has the grid lines turned off, but if you turn them on to take a quick look, you’ll see that the information you type for birth, military, marriage and death will be entered into the cell adjacent to those headings, but for the name, you’ll replace the word “name” with the name of your ancestor.

I hope this short video will bring some great ideas to mind for you whether it’s a gift for someone else or the cover of your research binder!

In case I don’t make it back here again this month, I hope you all have a very Merry Christmas and a blessed New Year!


Excel Video #4: Tracking the Documents and Sources

How often have you looked at information you’ve written somewhere and wondered, “Where in the world did I find THAT?” It happens to me a LOT. Usually, it’s when I look at information I had collected as a new genealogist (because I’m FAR wiser now than I was then! LOL!)

When you have a great deal of information that you are collecting such as we have been doing while building a surname database, you have to decide if you’re going to take the time right now to create your final source citation or if you’re going to collect the information that you will create your final citation from. In this video, we will be creating hyperlinks which we can click on to go directly to the document the information is coming from. Did you know that FamilySearch provides a citation for each document they have scanned? But there’s more than one citation included depending on where you look so we will also be collecting all of the source information using the comments feature in Excel because there is no option for adding a footnote.

I’ll also show you one of my absolute favorite tools in Excel – the filter. When I have an overwhelming list in Excel, I use the filters option to look at small, specific chunks at a time.

Excel Video #3 – Multi-level Custom Sorting

If you’re going to put in the time to compile the data for a surname database, you want to be sure that you can wring every bit of information possible from it – in the most efficient way that you can.

When you put together your own database, you want it to be designed so that you can see patterns and find information quickly. The beauty of Excel is being able to organize information in multiple ways depending on what you are looking for.

When you have a lot of information in your document, headers are a must, but do you find yourself scrolling back up to the top to see exactly what you are looking at? I’ll show you how to make that header row remain visible at the top of the screen at all times, no matter how far down you scroll.

Another feature that is nice in Excel is being able to keep your column spacing – maybe because you need it to fit on a specific size of paper – but sometimes, some of the information in the cells is too long. There is an option to “wrap” the text – automatically adding line returns within the data and adjusting the height of the row to make it fit perfectly. When you are wrapping text, you can decide if text that is not as long will sit on the bottom, top or center of the cell. Whatever you’d prefer to make it readable to you.

Because we’ve pulled the data for this database directly from FamilySearch, THEY have determined the order of the different columns when you downloaded the file. In the video, I show you how to move a column so that the information is in the order that you’d prefer.

The final thing that I talk about in this video is the ability to alphabetize your information. I show you how you can alphabetize the first column but then how to also add a 2nd level of alphabetizing so that all of the spouses listed for identical names will also be in alphabetical order. That is a great help when you are trying to differentiate between all those different men named “John Smith”. We’ll then add another level to make your first level of sorting based on the marriage date, then the 2nd level based on the first column name and a 3rd level of sorting to be based on the spouse’s name. That way, documents that refer to an individual by initials or nicknames will still be very close together within the Excel document but it will be easier to tell the difference between fathers and sons with the same name.

Once you learn all the different ways that data can be sorted, you’ll be able to arrange the information in the best way to help you find the information that you’ve been looking for!

I wasn’t expecting THAT!

I decided to start building a marriage database for all Stephens marriages in Russell County between 1825 and 1900. As I was going through the various marriage bonds, I found a marriage for Andrew J. Stephens Jr and Lola Tarter and the name of the person who performed the marriage was another ancestor of mine – Jehu Rumbo! Beneath his name, it said “Minister B Church”.


I had no idea that he was a minister! I did a little more digging and found 11 additional marriages performed by Jehu. How I wish I could figure out what church “B Church” stands for!

The other unexpected tidbit is that this marriage is the last marriage that I have found for Jehu (so far!) and that it helps me narrow down his date of death a bit. I already had 1895 as the date – found in a county history book – but this final marriage took place on Feb. 28, 1985. I can find no probate records for Jehu and no mention of his death in court records. I may have to branch out to search a few other counties.

Finding this record was a bonus that I was not expecting!


Excel Video #2: Collecting FamilySearch Information

Building a surname database can take quite a bit of time. Entering the information that you see in books or microfilms can be tedious, especially when all you want to do is KEEP SEARCHING! But it can be so rewarding when you begin to see connections that you hadn’t seen before because your information in Excel is formatting to help you see items that are easy to overlook when reading documents individually.

While adding information one line at a time will be very helpful, it can be even more helpful if there is already data in the document that you can begin to compare with. When I begin to research a new family – or when I look for information on a family that I haven’t researched in a while – I always turn to FamilySearch first. The search form on the website is easy to use and the format of the information is perfect to transfer into an Excel document. Keep in mind that this type of searching will only return results from data that has been indexed within FamilySearch – not necessarily from each microfilm that is available using the technique discussed in the last video – which you can watch in the “Video Tutorials” tab at the top of the blog.

In this video tutorial, I will show you how to search a specific database for a specific surname and then to download the information directly into Excel. Depending on your search terms, this can provide you with information on every person with a specific surname over a specific time frame to begin filling your database with very little typing on your part!

I will also show you how to quickly get rid of rows and columns of information that you don’t need and then how to combine different Excel files into one combined database. Finally, I will show you how to quickly adjust the width of the columns to make the page more readable.

Looking for Russell Co Marriages?

When you get on the FamilySearch website and look at the list of available marriage records for Kentucky, you might get excited. And then you click on the link and scroll down to the link that says “browse through images”, you’d expect to see a list of counties to click on. Instead, you see a screen full of numbers.


But which one is Russell County? You might click on a few numbers to see if you can get lucky, but there are a LOT of numbers and pretty soon, you just give up.

Recently, I was able to find some marriage records for one of my ancestors so yesterday, I took the time to make some notes so that I’ll be able to find these records easier the next time. I thought you might find the list helpful as well. The following links are the first 10 marriage books specifically for Russell Co, Kentucky.

v. 1 – 1826-1854 (Begins with Image 6)
v.2 – 1854-1860 (Image 62)
v.2 -1861-1867 (Image 5)
v.3 – 1867-1875 (Image 358)
v.4 – 1875-1787 (Image 5)
v.5 – 1876-1880 (Image 146)
v.6 – 1880-1883 (Image 480)
v.7 – 1883-1886 (Image 5)
v.8 – 1886-1889 (Image 348)
v.9 – 1889-1892
v.10 – 1892-1895

If you aren’t familiar with the microfilm viewer on FamilySearch, take a look at the video “Finding Information on FamilySearch” in the Video Tutorials tab at the top of the blog.