Vedette wrote:Hi Sharon
Your obviously very familiar with the workings of a spreadsheet.
I on the other hand am not that computer savvy.
I have a spreadsheet for our car club membership list.
It is very similar to the one you have for the trailer dimensions and weights.
Members are listed in alphabetical order.
There is a row of numbers down the left side for each line of cells. (numbers do not appear when list is printed)
My question is: How do I add a new member to this spread sheet in the appropriate alphabetical location?
Simply put your cursor on the line number below where you want to add a line and click. That row will become highlighted. With that row still highlighted, take your cursor up to the top of the screen and click on 'Insert'. A pull-down screen will appear. Click on 'Rows'. That will add an extra line above the one that you had highlighted.
There is a way to sort your data to get it in the order that you want it; but, that is a little more complicated to explain here. For your needs, the above should suffice.
Vedette wrote:And how do you move or delete the lines between cells?
I'm not certain that I know what you mean.
If you mean that you don't want the grid lines to print, go up to top of your screen and click on 'File'. A pull-down menu will appear. Click on 'Page Setup'. Another screen will appear that has tabs on it. Click on the 'Sheet' tab. When the 'Sheet' screen appears, click on the box next to 'gridlines' and click on the 'OK' at the bottom of that screen This will un-check that feature and the lines will no longer appear when you print your document. If you decide you like the lines, (makes it easier to follow your line or column) just repeat the above and, when you click on the 'gridline' , the check will reappear. Don't forget to click on 'OK' or your changes won't be changed.
If you want a column to be wider to fit your typing, probably the easiest way would be to click on the column letter, which will highlight the entire column. Next, take your cursor up to the top of the screen and click on 'Format'. A pull-down will appear. Click on 'Column' and another pull-down will appear. Here, my guess would be for you to click on 'AutoFit Selection'. This should enlarge your column to the width of the widest data in that column. If that doesn't do what you want it to do, there are a couple other ways to do what you want. If I haven't given you the answers that you need, just let me know and I will try to help.
Vedette wrote:In the past I have sent this document to our members via e-mail as an attachment for them to print.
Could It be revised by the recipient if sent this way?
If you mean that you are sending it as a file and not a scanned photo or print-out, then, yes. They can revise it anyway they want as that file becomes their own. However, your personal copy will not change when they change theirs. If they want to update the file for you, they will have to edit their copy, save the changes, and send it back to you. Then, you simply upload the copy that they sent you. If you want to save your old copy, rename it to something else before you upload the one that they are sending you, so that the newly uploaded file doesn't overlay your original.
If you don't want them to be able to change it, print it out and scan the printed page back into your computer and send that as a photo. You can also take a photo of the printed page and send that photo to people.
I am using an older version of Excel. Hopefully, these features have not changed. I doubt it has changed much. Remember to always save any data that was entered before you try any new Excel tactics. That way, if you don't like what you've done, you can simply exit without saving and that should cause your files to revert back to whatever it was the last time you clicked on 'Save'.
Vedette wrote:It is a rainy Saturday morning here, how are things with you?
Good Roads
Brian & Sandi
It is a beautiful, sunny day here, with temperatures expected to be near 80. While it is quilte pleasant, what we really need are some more cloudy, rainy days. It was announced on the news last night that, if we don't get more rain soon, the farmers will run out of allocated water by June. When you come down to the Dam gathering, Shasta lake will have a huge "bathtub ring". The dams are currently only half full.
Have a great day and enjoy the rain!
by 2bits » Sun Jan 12, 2014 10:49 pm 
