If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I set up a spread sheet in excel
I know nothing About spread sheets. I just need 4 columns and 1 row. The
row will be dates. columns will be location, milage , process and doctor. I will need to total the milage at the bottom of the spead sheet. I understand there are different codes for entering certain data. |
#2
|
|||
|
|||
How do I set up a spread sheet in excel
Hi
Enter the following in the cells A2 Date B2 Location C2 Mileage D2 Process E2 Doctor In cell C1 enter =SUBTOTAL(9,C3:C10000) Place cursor in cell A3 and choose WindowsFreeze Pane This will keep you headings in place as you scroll down the screen. Enter your data in each row from row 3 onward, and your total mileage will appear in cell C1. I have suggested the use of the Subtotal function, rather than Sum, in case you want to have totals by Doctor or by location. If so, then select cells A2:E2DataFilterAutofilter Then when you have data entered, you can use the dropdown on the cells to select any location or Doctor, and you will see a filtered set of results for that choice, and the mileage will be the total for that selection. -- Regards Roger Govier "Insurance Claim" Insurance wrote in message ... I know nothing About spread sheets. I just need 4 columns and 1 row. The row will be dates. columns will be location, milage , process and doctor. I will need to total the milage at the bottom of the spead sheet. I understand there are different codes for entering certain data. |
Thread Tools | |
Display Modes | |
|
|