ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel will not add cells automatically together when selected? (https://www.excelbanter.com/excel-worksheet-functions/34938-excel-will-not-add-cells-automatically-together-when-selected.html)

Dom23

Excel will not add cells automatically together when selected?
 
When i drag my mouse over various numbers in excel it use to give a quick
addition of the figures in the bottom right hand corner. This no longer
happens and i have to select a cell and autosum into there. I can't see how
i have disabled this feature but most importantly how do i reactivate it!??
Please Help!!? It is very frustrating calculating every sum!!!!

Ron de Bruin

Hi

Do you see something else in the bottom right corner ?
Right click on the stausbar and select Sum

Or maybe you close the status bar ?
ViewStatus Bar


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Dom23" wrote in message ...
When i drag my mouse over various numbers in excel it use to give a quick
addition of the figures in the bottom right hand corner. This no longer
happens and i have to select a cell and autosum into there. I can't see how
i have disabled this feature but most importantly how do i reactivate it!??
Please Help!!? It is very frustrating calculating every sum!!!!




Bob Phillips

Right-click in that corner of Excel, and make sure the SUM option is
checked, not None.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dom23" wrote in message
...
When i drag my mouse over various numbers in excel it use to give a quick
addition of the figures in the bottom right hand corner. This no longer
happens and i have to select a cell and autosum into there. I can't see

how
i have disabled this feature but most importantly how do i reactivate

it!??
Please Help!!? It is very frustrating calculating every sum!!!!





All times are GMT +1. The time now is 05:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com