Looking for some help with a word table.

Discussion in 'General Chat' started by MrFraggle, Jul 24, 2018.

Tags:
  1. MrFraggle

    MrFraggle
    Distinguished Member

    Joined:
    Jan 12, 2012
    Messages:
    4,251
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    166
    Location:
    Edinburgh
    Ratings:
    +6,714
    Not the right forum perhaps but knowledge is varied and vast here so hopefully someone can help.

    My good lady has COPD and we need to keep an eye on her oxygen and pulse levels daily. With that in mind I tried to create a table which pretty much works except I need to input all the months dates which is obviously long winded, I have just done one for August. (See images.)

    Ideally I would use Excel as I know the trick of adding a months dates in one go but Excel does not seem to play nice with Android. I use Onedrive to store the tables which she can open in Word on her phone or tablet and once she has used the Oximeter, stick the readings in, that way I can see them and make sure all is well.

    So how do I simplify adding a months worth of dates to the table or is there a better way to do it altogether?
    [​IMG]
    [​IMG]
     
  2. imightbewrong

    imightbewrong
    Distinguished Member

    Joined:
    Dec 6, 2005
    Messages:
    54,363
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    167
    Location:
    Romford-ish
    Ratings:
    +35,537
    Would it be better in a shared google sheets document? Free and works well natively with android as it's google's own product.
     
  3. MrFraggle

    MrFraggle
    Distinguished Member

    Joined:
    Jan 12, 2012
    Messages:
    4,251
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    166
    Location:
    Edinburgh
    Ratings:
    +6,714
    Possibly but I am as thick as mince when it comes this sort of thing and this works though not as well as I would like.
    But I might have a look at Google Docs tomorrow but will I still not have the same conundrum how to add a full months date simply?
     
  4. imightbewrong

    imightbewrong
    Distinguished Member

    Joined:
    Dec 6, 2005
    Messages:
    54,363
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    167
    Location:
    Romford-ish
    Ratings:
    +35,537
    You can do it in a google sheet in exactly the same way you do it in excel
     
  5. MrFraggle

    MrFraggle
    Distinguished Member

    Joined:
    Jan 12, 2012
    Messages:
    4,251
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    166
    Location:
    Edinburgh
    Ratings:
    +6,714
    Hmmm, I hope it is easier as it took me some time to get to the above in word though I did have better version in Excel until I moved it over to Android.
     
  6. imightbewrong

    imightbewrong
    Distinguished Member

    Joined:
    Dec 6, 2005
    Messages:
    54,363
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    167
    Location:
    Romford-ish
    Ratings:
    +35,537
    You can probably copy and paste your excel into a google sheet. Filling with dates if necessary - type first date, click on little box in corner of cell and drag down.
     
  7. MrFraggle

    MrFraggle
    Distinguished Member

    Joined:
    Jan 12, 2012
    Messages:
    4,251
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    166
    Location:
    Edinburgh
    Ratings:
    +6,714
    Thanks will try that also tomorrow.
     
  8. EndlessWaves

    EndlessWaves
    Distinguished Member

    Joined:
    Apr 7, 2008
    Messages:
    13,939
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    166
    Location:
    Norfolk
    Ratings:
    +2,549
    Microsoft also does an online version of Excel (and the other Office applications) to compete with google docs, which you may prefer. Being a website it shouldn't have whatever compatibility problem you've encountered with .xlsx files.
     
  9. MrFraggle

    MrFraggle
    Distinguished Member

    Joined:
    Jan 12, 2012
    Messages:
    4,251
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    166
    Location:
    Edinburgh
    Ratings:
    +6,714
    Went the Google sheets route and although I got there in the end I really do not like the way it handles cell formatting which seems to be all over the shop. Though it might be that I am used to Excel.
    Thanks all.
     
  10. MrFraggle

    MrFraggle
    Distinguished Member

    Joined:
    Jan 12, 2012
    Messages:
    4,251
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    166
    Location:
    Edinburgh
    Ratings:
    +6,714
    Try as I might I cannot find away to remove the rest of the sheet leaving just the table. Can someone point me in the right direction?

    [​IMG]
     
  11. imightbewrong

    imightbewrong
    Distinguished Member

    Joined:
    Dec 6, 2005
    Messages:
    54,363
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    167
    Location:
    Romford-ish
    Ratings:
    +35,537
    Select column/row, right click->delete ?
     
  12. MrFraggle

    MrFraggle
    Distinguished Member

    Joined:
    Jan 12, 2012
    Messages:
    4,251
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    166
    Location:
    Edinburgh
    Ratings:
    +6,714
    Certainly works for everything to the right of the table but not to the millions of cells below. (slight exaggeration,:D)
     
  13. imightbewrong

    imightbewrong
    Distinguished Member

    Joined:
    Dec 6, 2005
    Messages:
    54,363
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    167
    Location:
    Romford-ish
    Ratings:
    +35,537
    You will probably find there are 1000 rows, select all the ones you don't want and hit delete.
     
  14. MrFraggle

    MrFraggle
    Distinguished Member

    Joined:
    Jan 12, 2012
    Messages:
    4,251
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    166
    Location:
    Edinburgh
    Ratings:
    +6,714
    Not quite that simple but got there, thanks.
     
  15. imightbewrong

    imightbewrong
    Distinguished Member

    Joined:
    Dec 6, 2005
    Messages:
    54,363
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    167
    Location:
    Romford-ish
    Ratings:
    +35,537
    It worked for me so I guess you had something selected in the wrong way initially.
     
  16. MrFraggle

    MrFraggle
    Distinguished Member

    Joined:
    Jan 12, 2012
    Messages:
    4,251
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    166
    Location:
    Edinburgh
    Ratings:
    +6,714
    I have a choice of three Deletes.
    Delete rows between specified numbers.
    Delete columns between specified numbers.
    Delete cells which bought up Shift left or Shift up whatever that means.
    But as I said I got there thanks to you pointing me in the right direction and now the table looks neat and tidy on her tablet and phone.
     
  17. imightbewrong

    imightbewrong
    Distinguished Member

    Joined:
    Dec 6, 2005
    Messages:
    54,363
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    167
    Location:
    Romford-ish
    Ratings:
    +35,537
    For next time this means you didn't select all the rows you want to delete - if you do this you will get the 'delete' option which will wipe them out.

    "Shifting" is usually when you are deleting some individual cells and you need to tell the spreadsheet what do do with the 'gap'.
     
  18. MrFraggle

    MrFraggle
    Distinguished Member

    Joined:
    Jan 12, 2012
    Messages:
    4,251
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    166
    Location:
    Edinburgh
    Ratings:
    +6,714
    Hopefully I will not need it again as I have created a blank table and all I need is to make a copy and add the months dates and then share it with the good lady.
    Will save a lot of faffing around with adding the months dates.
     

Share This Page

Loading...