SOLVED

Cells

Copper Contributor

Hello I have been learning Excel and I somehow changed my auto sum to something that reads 

=SUM(W8:W20)

How do I get it back to the actual total from that row (and column, since the whole page changed)

Thank you so much in advance for any help.

 

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@GlendaLizotte Perhaps you accidentally switched on "Show Formulas" on the Formulas ribbon.

Screenshot 2021-08-29 at 06.42.27.png

Press the icon and see if it reverts back to displaying the result, rather than the formula itself.

@Riny_van_Eekelen Thank you so much. that was it.

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@GlendaLizotte Perhaps you accidentally switched on "Show Formulas" on the Formulas ribbon.

Screenshot 2021-08-29 at 06.42.27.png

Press the icon and see if it reverts back to displaying the result, rather than the formula itself.

View solution in original post