answersLogoWhite

0

Excel will attempt to sum cells by selecting nearby cells which it presumes are the ones to be selected and summed. Usually this will be the cells above. If you select a range of cells and then click the Autosum button it will use the selected cells and sum them, putting the total at the bottom of the column, or it can do it for several columns, giving a total for each.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What happens when a selected range is next to numbers and the SUM button is clicked?

You will find the sum of the numbers.


What happens if you click the unclickable button?

How do you even dare to ask that!?!?!?!ONLY CHUCK NORRIS CAN CLICK THE UNCLICKABLE BUTTON!He has, in fact, clicked it TWICE!


Is it true If each cell in a selected range is next to a row of numbers Excel assigns the SUM function to each cell in the selected range when the Sum button is clicked?

false


How do you make a button click another button?

This is not possible, but you can make it appear that way, for example, get a video component, set the visible to false, get a button, make the video play an animation of a clicked button, and once another button is clicked the orignal button dissapears and the video player appears and plays a short animation of a clicked button.


What are the function of reset button?

The reset button is a button that when clicked, will clear all of the fields


What happens when a menu item is clicked in Excel?

You execute the command programmed into the particular item you clicked.


Then they all guided Amy to the button which had a warning on top that said?

self-destruct on it Ehvil clicked the button that


How the buttons on the Home Ribbon are buttons that when clicked once will format the selected text and clicked again will remove the format from the selected text.?

The right click button


Why can a safety button on a jar not be clicked before it is opened?

The vacuum inside the jar keeps the button down. On opening the jar, the vacuum is broken and the button pops up (and the lid can be clicked). Therefore, if the safety button is up, the vacuum seal has been broken and the contents of the jar may have been contaminated, and the contents may have gone off!


How can you answer questions in this website?

click the answer it button and you can answer a question if you type a question that has not already been answered then click the save button further instructions will be given once you have clicked the save button


How do you get your answers on WikiAnswers to appear?

They should appear immediately, as soon as you've clicked the <Save> button.


What button does excel display after the paste button is clicked?

It displays several options about what you can paste, like everything, format only, formulas only, special format, etc.