Can any one help please. Im doing school index 1900, I want to have surname, Christian name , number, I want three or four sets of these on a page when printed off, in alphabet order. I have windows 7 , do I set it up before I start or after I have index finished. Thanks carole

Hi Carole, In principle, the answer to your question is that it is best to set up formats first. In the case that you've given, it should be straightforward and Peter has explained how to do it. However, in case you wish to expand the information, there is a "gotcha" in Excel that's worth noting for family historians. If all dates are 1900 or later, that's fine, but as soon as you go back to 31-Dec-1899, Excel doesn't "understand" this as a date. So for example, if you needed to add a date of birth column to your 1900 school record, you could have difficulty getting it to sort into order properly. Just something to watch out for. Best wishes, Mike Gould Leicestershire, UK -----Original Message----- From: aus-nsw-sydney-bounces@rootsweb.com [mailto:aus-nsw-sydney-bounces@rootsweb.com] On Behalf Of carole douch Sent: 22 September 2012 03:54 To: aus-nsw-sydney@rootsweb.com Subject: [ANS] excel index set up Can any one help please. Im doing school index 1900, I want to have surname, Christian name , number, I want three or four sets of these on a page when printed off, in alphabet order. I have windows 7 , do I set it up before I start or after I have index finished. Thanks carole Please remember to snip most of the earlier message before you post any reply...... Thank you! ------------------------------- To unsubscribe from the list, please send an email to AUS-NSW-SYDNEY-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

Dear Carole, Although you mention MS Excel, do you by any chance have MS Access on your computer? I only ask this because there is an amazing number of basic formats already set up which can be customised by you, to suit your needs. There are included tutorials on how to use them. I only have XP with Office 2007. I expect that Windows 7 with relevant Office programs should have even more features. I have not had to use a database since 1998 and both Excel but particularly Access now has become far more user friendly since then. Both programs seem now to talk to each other, so if you already have some data entered it can imported or exported from the original source. The Sample Print preview on Access may answer many of your questions. If you set up a sample page within Excel, likewise look at ## ALL ### the >Print Preview > Page Options >Sheet options which may help you too. Cheers, Tony Moore @@@@@@@@@@@@@@@@@@@@@@@@@@@@@ On 22 Sep 2012 at 12:53, carole douch wrote: From: "carole douch" <carole.douch@bigpond.com> To: <aus-nsw-sydney@rootsweb.com> Date sent: Sat, 22 Sep 2012 12:53:52 +1000 Subject: [ANS] excel index set up Send reply to: aus-nsw-sydney@rootsweb.com > Can any one help please. > > Im doing school index 1900, I want to have > > surname, Christian name , number, > > I want three or four sets of these on a page when printed off, in alphabet > order. > > I have windows 7 , do I set it up before I start or after I have index > finished. > > Thanks carole

I am trying to find information in relation a William Beazley/Beasley marrying a Mary Driscoll in Newcastle New South Wales in approximately 1837. I have searched the Christchurch Cathedral Registers (online) and come up with zilch. The marriage is not listed on BDM NSW either. Just wondering if anyone knew of any other registers etc. The information came from William's death certificate (which I know, depending of what information the informant (his son) had, could be wrong). Any help gratefully appreciated. Regards Tracey.

Hi Carol If you have excel and want to set up the spread sheet best way is to use the help menu, turn on the assistant, and ask "how do I format columns Column A & B you don't have to change as default is "general" For collum C click on the C at the top of the column [the whole column will highlight] click on format and change from general to number and set decimal places to zero. You can set how many records you want to a page just ask the assistant how. If you need any further help contact me off list Anyone who does not have Microsoft office and wants to set up spread sheets etc Free software is available from www.openoffice.org It is fully compatible with latest version of Microsoft office and from a safe site. Peter O'D Central Coast