Windows 10: Excel ?

I'm trying to learn how to setup a spreadsheet in Excel and need a little help. This is my first attempt at making a spreadsheet. In this example how do I setup this spreadsheet so that I can keep a running total of columns C,D and E in column F if I keep adding new lines. If I'm doing it wrong any suggestions are welcome.





:)

 

Ungroup, and NOT have similar icons next to each other on taskbar on this garbage windows 10 system

Does anyone know how to have multiple instances of Chrome (or whatever browser) and Excel, so they could go across the taskbar as:

Chrome, Excel, Chrome, Excel, etc., NOT chrome, chrome, chrome, excel, excel, excel? Such an annoying feature that they can't be separated, but such is the case with most of Windows 10. Newer, but worse.

Thanks.

 

Excel file type disappeared

Thanks for you reply.

1. Yes

2. I have Office 2016 and Excel 2016 installed on my computer.

3. When I open excel file (file type is older Excel version) which before open Excel, it guided me to open it with other App and there is no Excel 2016 as my option.

4. There is no problem when I open Excel file from a different computer.

When I open Excel, then open an excel file which saved as older version excel type, I need to save as Excel 2016 version, and it showed a normal Excel type.

Please help me to solve this issue. Thank you so much.

 

Hi Winuser,

One suggestion, move the Total cell to the left so that it is beneath the Sub Total column. When you insert a new row (in your example you would be inserting at row 5) and then add your new numbers they will automatically be added in to the Total.

Cheers,
Phil

 

Oops, just checked. It is required to move the total to the left under the subtotal column. Also, the equation for the sum should be:

=sum(E2:E4)

The colon means sum everything from E2 to E4. When you add lines before the total line, the E4 should increase automatically to reflect the added lines.

 

Thanks, I think I got it now. I'll play around with it some more and try different formulas so I can learn more about making spreadsheets.

 

I've been playing around with my example spreadsheet and have it pretty much working the way I want. Thanks again for the help. I do have one more question though. Is there any way to have new entries auto fill? Right now I'm using copy and paste to enter new lines.