Organization.....

mallog · Post by **mallog** » Sun May 28, 2006 8:31 pm

You've pipped me to the post. It's been mentioned twice what's a hyperlink??? I use Excel but don't know anything about hyperlinks although I am familiar with the name( Always pays to know what you don't know!!).

Mallog

Clydesdale · Post by **Clydesdale** » Sun May 28, 2006 8:32 pm

Hi fmackay,

In business Microsoft Excel is used mainly for mathematical calculations using formulae. It is made of different worksheets, each laid out with a large number of columns full of sections called cells. Like an enormous Word table. Each cell can be formatted to accept and display different types of information such as dates, numbers, currency and data. I use only the data and dates.

In the case of hyperlinks – it is a setting you can put into a cell which, when you click on it, will take you to a different cell on a different worksheet that you have already prepared. E.g. in my Yule worksheet, Robert Yule married Catherine Murray in 1851. I have placed a hyperlink on Catherine Murray’s name so when I click on it, it will take me to a different worksheet where I have laid out all the information I have on Murray, and it will land on the cell with Catherine Murray’s name on it.

Has this helped or are you even more in the dark than you were before?

Helen

mallog · Post by **mallog** » Sun May 28, 2006 8:34 pm

Oooh Canny wait to try it

Thank you

Mallog

fmackay · Post by **fmackay** » Sun May 28, 2006 8:37 pm

Right I get the bit about the hyperlink but I've had a look at Excel and I still can't see how you would use that for a family tree!
Sorry for being so ignorant
fiona

Clydesdale · Post by **Clydesdale** » Sun May 28, 2006 9:06 pm

Hello Fiona,

It is difficult to explain - but I can copy some of the data and send it through if you would like to pm me with your email address.

I am sure everyone does it a different way but it might give you an idea of how I view the data I have collected.

I have printed it out (took about 8 sheets of A4 for just one worksheet) and stuck it down on to a piece of wallpaper so I can see everything at once. All this technology and I end up with a bit of wallpaper ...... sigh

fmackay · Post by **fmackay** » Sun May 28, 2006 9:16 pm

Hi Helen
Have sent you a pm
Fiona

laineywoo · Post by **laineywoo** » Sun May 28, 2006 9:46 pm

hi
The way I use the hyperlink. I save my copies of certs from SP onto a place on my computer that I use only for this purpose. Then I type all the details of the cert onto a spread sheet. Quite simply, you then right click, and you will see a bit called "hyperlink". I click that, then open the cert from the bit I have saved the cert too, and save it.............Then when you want [usually the extra entry] to view this cert, you just click on the link and the cert opens for you from the spreadsheet.. Not complicated once you've done it a couple of times. Does that help any?

--------------------------------------------
researching williamson, maxwell, bennie, wardlaw, hardie, spence all mostly Polmont and Muiravonside

Clydesdale · Post by **Clydesdale** » Sun May 28, 2006 9:51 pm

Hi laneywood,
What a good idea - I will do that so I can access my Word data sheet directly from my Excel information.
Go to the top of the class!

Helen

laineywoo · Post by **laineywoo** » Sun May 28, 2006 9:58 pm

It only took me about 3 years to work it out myself

Works well for me though. Hope I explained it OK

Clydesdale · Post by **Clydesdale** » Sun May 28, 2006 10:06 pm

It works a treat - what a time saver not having to go and search for my document. Thank you so much.
Helen.