Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Total row doesn't work properly, Excel 2010

25 May 2014   #1
Franky

windows 7 32-bit
 
 
Total row doesn't work properly, Excel 2010

In my Excel 2010 file and in one of its sheets I have a small table. As following, when I checked the Total Row option in Table tools > Design > Table style options > Total Row the tabled appeared as follows. But it is against of the info when I hold the mouse pointer over the Total Row check box because that info says: The total row is a row at the end of the table which displays totals for each column. But in practice it only displays the total for the last column not each column! Any idea why?




Attached Images
Total row doesn't work properly, Excel 2010-rld4q.png 
My System SpecsSystem Spec
.
25 May 2014   #2
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

Your problem is not all that clear, but from what I can see from your post, that one column results seem to be correct.

This is from Excel 2013, but I think they are very similar. If you want to total the other 2 columns then you need to carry out that procedure. If you click on the Totals row below each column & click on the Totals icon & select Sum, the column will highlight & the formula will show in the formula slot & the total for that column will be entered. Do this for each column. refer to screen shot.

Total row doesn't work properly, Excel 2010-excel_column_totals..png

Also if you click on the little arrow beside the Totals icon more alternatives are shown.


My System SpecsSystem Spec
26 May 2014   #3
Franky

windows 7 32-bit
 
 

Yes you are right. Thank you.
My System SpecsSystem Spec
.

26 May 2014   #4
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

Thanks for posting back. Glad to hear it helped.
Perhaps you could mark the problem as solved.
My System SpecsSystem Spec
Reply

 Total row doesn't work properly, Excel 2010




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Microphone doesn't work properly
The microphone is detected, already enabled, but no sound detected. The microphone doesn't have a problem, because it works on other computer which are using XP. I've done troubleshooting, but it couldn't find what the problem is. Please help..
Sound & Audio
Inspect document doesn't show anything, Excel 2010
In my Excel 2010 workbook I wen through File > Info > Check for Issues > Inspect document. But as it's shown following, it doesn't show anything. Why? Thanks in advance.
Microsoft Office
Copying filtered table doesn't work as it is expected in Excel 2010
Hi all, I have a small table and want to copy it after filtering. The image is in below (image no. 1), and I have filtered it to shows only the red font color of the column "Days" as follows, (image no. 2). Now everything is ready to start the copying! So I select all the table (Double CTRL+A...
Microsoft Office
Print preview doesn't work properly in Excel 2010
Hello all, First I made some contents and drew a border from Home > Font > all Borders on an Excel 2010 file. So it became like below image (capture1). After that I wanted to print it so went to File > Print to see its preview. But the problem is that the lines between tue and wed and also...
Microsoft Office
IE9 from server doesn't work properly
Hi there When logging on to a service that needs extra logon Information such as supplying password etc IE9 fails. I'm currently in France and have to use the ORANGE France wifi service. IE8 gives me an orange logon screen -- works fine IE9 doesn't present the option -- I just get...
Browsers & Mail
Excel 2007 doesn't work properly with windows 7
I have found several issue on excel now I'm using windows 7. When you select multiple cells, using control, they aren't highlighted. I also have issues with excel crashing all the time, even on relatively small files and running on a 8Gb machine Anyone else having the same issues?
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 09:18.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App