I am new to Spreadsheets and I have just created a spreadsheet via downloading a “csv” file from my Bluetooth blood pressure monitor. I ended up with 5 columns: A=Date, B=Systolic, C=Diastolic, D=Pulse and E=Notes. I have inserted a new column after the C column which I have named Pulse Pressure. Pulse Pressure is an important blood pressure indicator and is simply the Systolic pressure minus the Diastolic pressure. Basically my new D column called Pulse Pressure is Column B(Systolic) - Column D(Diastolic). However I am unable to direct the spreadsheet program to automatically do this calculation. I could obviously go in manually, do the subtraction and enter the result but as I have very close to 400 readings this would be a rather onerous task. My Pulse Pressure is often much too high. I need to get this info to my internist soon such that I can make the point that they need to address the Pulse Pressure. A high pulse pressure can be an indicator of impending heart failure so this is rather important to me. Particularly as I am 78 with high blood pressure which is a significant risk factor with Covid-19. If someone could direct me as how to do this I would be very appreciative.
I found the answer via a YouTube video. The task was easy once I saw the video. I give here a link to the video …https://www.youtube.com/watch?v=66dz_nomJoA . This Internet thing always amazes me. If we had powerful personal computers allowing one to use such a nice program as LibreOffice but no World Wide Web or Internet … I can just imagine trying to find the answer as I had to do when doing high school research papers using the encyclopedia Britannica at my neighbors as we could not afford one. I am pleased that I found this LibreOffice software … a big thanks to the developers to allow a person the free use of such a program that I am using for this one time project. I probably shall not do another spreadsheet in my time left in this marvelous but strange world of our. Blessings and Good Health to All.
- In cell C2 enter
=B2-D2 - Select cell C2 again
- Note the tiny square in the bottom right corner of the cell. This is the “fill handle”
- Double click the fill handle to autofill down the existing table, or drag the handle down to fill as far as required.
Ah I do thank you as you added an element the YouTube video did not and that was the concept of the fill handle and the double click to populate the entire column. I trial and error to click on the lower right hand of the cell and then drug all the way to the bottom of the spreadsheet that had some 400 rows…the double click would have been faster. I do thank you for taking the time to answer my question.