MARY KIRCHER RODDY
  • Home
  • Coaching and Research
  • Lectures
    • Upcoming and Past Presentations
  • Searching For Stories blog
  • Publications
  • Contact
  • Resources
  • Privacy Policy

Searching for Stories

Spreadsheet Magic - A Cool Tip for a Big Spreadsheet

7/5/2016

2 Comments

 
As the weather heats up, sometimes it’s good to think about cold things.  Like freezing things.  Like… freezing panes.

If you have a large spreadsheet with more rows and/or columns than will fit on your computer screens, try freezing panes to keep you column and row titles visible while you scroll through the worksheet.  Here’s how…
​
In the spreadsheet below, I have listed the census years and places across the top and the names of the family I researching in column A.  As I move forward through the years or downward below the first few names, I’d like to be able to see columns A, B and C and rows 3 and 4.  In this example, if I place my cursor in cell D5 and on the View tab click “Freeze Panes,” I am given some options, to freeze the top row, freeze the first column or to freeze panes.  That’s the one I chose, because it will keep my names as well as my census years. 
Picture
When I click on the freeze panes, note the lines that appear:
Picture
Now I can move to the right or downward and my titles will remain to explain to me what I’m looking at.
​
Freeze panes – a cool tip for a big spreadsheet.  Try it!
2 Comments
John Sparrow
7/6/2016 03:03:03 pm

I follow a number of blogs. The ones I like best are those that teach about techniques, such as yours with spreadsheets. Keep it up.

Reply
Mary Roddy
7/6/2016 05:44:20 pm

Thanks, John! I'm glad you enjoyed.

Reply

Your comment will be posted after it is approved.


Leave a Reply.

    Author

    Mary Kircher Roddy is a genealogist, writer and lecturer, always looking for the story.  Her blog is a combination of the stories she has found and the tools she used to find them.

    Read more of Mary's writings at "Adventures of A Broad Abroad" and at Letters from Limerick

    Archives

    April 2021
    January 2021
    November 2020
    August 2020
    July 2020
    February 2020
    January 2020
    November 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    October 2018
    September 2018
    August 2018
    July 2018
    February 2018
    January 2018
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016

    Categories

    All
    Achard
    Ahern
    Aldrich
    Amador County Genealogy
    Ancestry.com
    Archives
    Blair County
    Bradley Family
    Brannack
    Brannock
    Brown
    Brown Family
    California Genealogy
    Cemetery
    Census
    Citations
    City Directories
    Clark County
    Death Records
    DNA Strategies
    Education
    Enslaved People Research
    FamilySearch
    Family Stories
    Fields Family
    Freuhauf
    Genealogy Conferences
    Genealogy Education
    German Research
    Germany
    Graham Family
    Grandparents
    Hardy
    Hartmann
    Indexes
    Ireland
    Kircher
    Letters
    Lunenburg
    Map
    Mapping Tools
    Midwest Resources
    Midwives
    Military
    Newspaper
    Newspapers
    New York
    Ohio
    Pennsylvania
    ProGen
    Railroad
    Records
    Research Techniques
    San Francisco
    Sonoma County Genealogy
    Spreadsheets
    Springer
    Tiburon
    Timelines
    Virginia
    Virginia Genealogy
    Vital Records
    War
    Webster
    World War II Research
    Writing

     Subscribe in a reader

    Enter your email address:

    Delivered by FeedBurner

    Picture
Powered by Create your own unique website with customizable templates.
  • Home
  • Coaching and Research
  • Lectures
    • Upcoming and Past Presentations
  • Searching For Stories blog
  • Publications
  • Contact
  • Resources
  • Privacy Policy