Author Topic: Speadsheet for Graveyard Memorials  (Read 2976 times)

Offline slippery

  • RootsChat Member
  • ***
  • Posts: 221
    • View Profile
Re: Speadsheet for Graveyard Memorials
« Reply #9 on: Sunday 18 June 17 09:20 BST (UK) »
familydar it does not work for me.

ReadyDale your system works the only slight problem I have being a one finger typist is that the lettering you are typing does not show in the formula row.
To use this system I will have to retype the 100 or so inscriptions again. I should had sorted out how to do it correctly at first.

Peter

Offline ReadyDale

  • RootsChat Veteran
  • *****
  • Posts: 697
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
Re: Speadsheet for Graveyard Memorials
« Reply #10 on: Sunday 18 June 17 21:12 BST (UK) »
Not sure I understand what you mean (apart from the one fingered typist bit  ;D).
Everything is possible in Excel (I use it all the time for work) and I'm happy to help. Either reply here or PM me if you prefer and I'll try and advise. You will definitely NOT need to retype everything/

Rob

Offline Rosinish

  • RootsChat Marquessate
  • *******
  • Posts: 14,239
  • PASSED & PAST
    • View Profile
Re: Speadsheet for Graveyard Memorials
« Reply #11 on: Monday 19 June 17 00:18 BST (UK) »
You will definitely NOT need to retype everything

I agree, Copy & Paste if need be.

Annie
South Uist, Inverness-shire, Scotland:- Bowie, Campbell, Cumming, Currie

Ireland:- Cullen, Flannigan (Derry), Donahoe/Donaghue (variants) (Cork), McCrate (Tipperary), Mellon, Tol(l)and (Donegal & Tyrone)

Newcastle-on-Tyne/Durham (Northumberland):- Harrison, Jude, Kemp, Lunn, Mellon, Robson, Stirling

Kettering, Northampton:- MacKinnon

Canada:- Callaghan, Cumming, MacPhee

"OLD GENEALOGISTS NEVER DIE - THEY JUST LOSE THEIR CENSUS"

Offline Billyblue

  • RootsChat Marquessate
  • *******
  • Posts: 4,066
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
Re: Speadsheet for Graveyard Memorials
« Reply #12 on: Monday 19 June 17 02:57 BST (UK) »
Close
It is Alt + Enter (or Alt + Return - same thing)

If you click on the cell or, column that you want to change, select Format,  then Alignment, then check the word wrap box. This might vary slightly depending on which version of Excel you are using.  If you still have problems use the help function and search for word wrap. You can then change the width of the cell or column as required. You might need to make the cells deeper to accommodate the word wrap. Experiment before applying this to your data and make sure you have a backup.

MARTIN

If you use WordWrap, you don't need to change the depth of the cell, the system does that automatically.  But if you then change the depth of the cell, this may alter the visual effect of what you are presenting, i.e. you may cut off the bottom of the screed.
If you use Alt+Enter you will get to a new line in the cell which may or may not be what you want.
Also fiddly to edit.
Sounds like you need WordWrap, to me.

Dawn M
Denys (France); Rossier/Rousseau (Switzerland); Montgomery (Antrim, IRL & North Sydney NSW);  Finn (Co.Carlow, IRL & NSW); Wilson (Leicestershire & NSW); Blue (Sydney NSW); Fisher & Barrago & Harrington(all Tipperary, IRL)


Offline eadaoin

  • RootsChat Aristocrat
  • ******
  • Posts: 1,623
  • Reilg Chill Barróg
    • View Profile
Re: Speadsheet for Graveyard Memorials
« Reply #13 on: Monday 19 June 17 19:44 BST (UK) »
In fact you can also use a Table in WORD for this type of data
- this can be sorted, and I find it easier than Excel (When I haven't calculations to do)
Begg - Dublin, Limerick, Cardiff
Brady - Dublin
Breslin - Wexford, Dublin
Byrne - Wicklow
O'Hara - Wexford, Kingstown
McLoghlin - Roscommon
Lawlor - Meath, Dublin
Lynam - Meath and Renovo, Pennsylvania
Everard - Meath
Fagan - Dublin
Meyler/Myler - Wicklow
Gray - Derry, Waterford
Kavanagh - Limerick

Offline KGarrad

  • RootsChat Marquessate
  • *******
  • Posts: 26,063
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
Re: Speadsheet for Graveyard Memorials
« Reply #14 on: Monday 19 June 17 20:17 BST (UK) »
I find Excel better - because you do things like add Filters ;D
And you can expand horizontally across more than a single screen.

Having said that, I do sometimes use Word.

KG
(currently Statistician for English Ice Hockey Association ;D)
Garrad (Suffolk, Essex, Somerset), Crocker (Somerset), Vanstone (Devon, Jersey), Sims (Wiltshire), Bridger (Kent)