Search for content in message boards

Formatting charts, and exporting reports to Excel

Replies: 10

Re: Formatting charts, and exporting reports to Excel

Posted: 20 Nov 2012 10:57AM GMT
Classification: Query
Edited: 20 Nov 2012 11:05AM GMT
I can't help you with your first question.

But, as far as printing to Excel - when you export a report to Excel, some reports will ask if you want the export in rows or columns. If you say columns, names will be in rows and the other info in columns. If you say rows, the names will be in columns and the other info in rows. Other reports (like the outline descendant report) only export one way, but you can use Excel's columns to rows commands to turn the info "inside-out" and in reverse format)

To export a report to excel, with the report preview in front of you:

1) Click on the Share button in the upper right
2) Choose export csv
3) Choose rows or columns - if you get that screen.
4) You will be asked it you want to see the file - say yes
5) If it brings it up in Excel, used File > Save as to change the format from csv to excel.

You may have some cleaning up to do, the basic report is there.

SubjectAuthorDate Posted
Mavis_OConnor 20 Nov 2012 4:56PM GMT 
silverfox3280 20 Nov 2012 5:57PM GMT 
Mavis_OConnor 20 Nov 2012 7:07PM GMT 
silverfox3280 20 Nov 2012 10:44PM GMT 
Mavis_OConnor 20 Nov 2012 11:00PM GMT 
silverfox3280 21 Nov 2012 2:26AM GMT 
Mavis_OConnor 21 Nov 2012 4:58AM GMT 
Mavis_OConnor 21 Nov 2012 5:15AM GMT 
silverfox3280 21 Nov 2012 2:39PM GMT 
Mavis_OConnor 21 Nov 2012 8:15PM GMT 
per page

Find a board about a specific topic

  • Visit our other sites:

© 1997-2014 Ancestry.com | Corporate Information | New Privacy | New Terms and Conditions