answersLogoWhite

0


Best Answer

First put the values that are going to make up your balance in one column. To get a running balance, there are a number of ways you could do it. Suppose your values are in column A, starting in A2. Then in B2 enter the same number that is in A2. Then in B3 enter the following formula:

=B2+A3

Then copy that formula down along column B, and you will get a running total.

Another way, and a slicker way is to do put this formula in cell B2 and copy it all the way down.

=Sum(A$2:A2)

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do I set up a running balance on an excell spreadsheet?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What does max min average mean in ict terms?

Inan Excell spreadsheet they are function used to get an answer to the maximum, minimum and average of the set of score selected. it's not that simple to know you need to study hard


Why electronic spreadsheet are much larger than manual spreadsheet?

beacause of the set out


What Describes how spread out a data set is?

spreadsheet


A set of characters with the same design size and shape is called a what in windows excell?

In Excel they are simply called font.


What is a spreadsheet column?

It is apace provided for a set of data all occupying the same column in the spreadsheet's matrix so that they can be referenced as a set using the column header or individually by the column/row intersections.


How can you describe a set of data in a spreadsheet?

A set of data can be described to the spreadsheet as a range by specifying the beginning cell, in the upper left corner of the data, and the ending cell, in the lower right corner of the data.


Is the spreadsheet calculation set all the instructions that direct the computer?

No. An instruction set is all the instructions that direct a computer.


Is a spreadsheet an effective tool for summarizing and comparing prices and components of different computers?

If you set up a good spreadsheet it can be used to do summaries and comparisons very well. A spreadsheet is for numerical analysis and manipulation, so it would be ideal for that task.


What does workbook in computer terms mean?

A workbook in spreadsheet software is a set of individual spreadsheets.


What the print set area command is use to?

If you want to print just a part of a spreadsheet and not the whole lot of it, you can select the part you want to print and set the Print Area. It is a very useful feature if you only want to print an important part from what is a large spreadsheet, like some totals or some columns. When you have finished, you can use the setting to clear the print area which will set the setting back to normal and do a full print of the spreadsheet.


How do you set dwell with out engine running?

My advice would be to set the points at .020" with a feeler gage to get the engine running, and then use a dwell meter to set the dwell after the engine is running.


How do you show a spreadsheet in PowerPoint?

You could copy a part of a spreadsheet from another application, such as Excel, and paste it into Powerpoint. You could also put a link into a slide that will open a separate spreadsheet file. You can also use the Insert option to put in a spreadsheet. You could use a table. You can create a chart within Powerpoint that will have a set of figures with it. So there are a number of ways of doing it.You could copy a part of a spreadsheet from another application, such as Excel, and paste it into Powerpoint. You could also put a link into a slide that will open a separate spreadsheet file. You can also use the Insert option to put in a spreadsheet. You could use a table. You can create a chart within Powerpoint that will have a set of figures with it. So there are a number of ways of doing it.You could copy a part of a spreadsheet from another application, such as Excel, and paste it into Powerpoint. You could also put a link into a slide that will open a separate spreadsheet file. You can also use the Insert option to put in a spreadsheet. You could use a table. You can create a chart within Powerpoint that will have a set of figures with it. So there are a number of ways of doing it.You could copy a part of a spreadsheet from another application, such as Excel, and paste it into Powerpoint. You could also put a link into a slide that will open a separate spreadsheet file. You can also use the Insert option to put in a spreadsheet. You could use a table. You can create a chart within Powerpoint that will have a set of figures with it. So there are a number of ways of doing it.You could copy a part of a spreadsheet from another application, such as Excel, and paste it into Powerpoint. You could also put a link into a slide that will open a separate spreadsheet file. You can also use the Insert option to put in a spreadsheet. You could use a table. You can create a chart within Powerpoint that will have a set of figures with it. So there are a number of ways of doing it.You could copy a part of a spreadsheet from another application, such as Excel, and paste it into Powerpoint. You could also put a link into a slide that will open a separate spreadsheet file. You can also use the Insert option to put in a spreadsheet. You could use a table. You can create a chart within Powerpoint that will have a set of figures with it. So there are a number of ways of doing it.You could copy a part of a spreadsheet from another application, such as Excel, and paste it into Powerpoint. You could also put a link into a slide that will open a separate spreadsheet file. You can also use the Insert option to put in a spreadsheet. You could use a table. You can create a chart within Powerpoint that will have a set of figures with it. So there are a number of ways of doing it.You could copy a part of a spreadsheet from another application, such as Excel, and paste it into Powerpoint. You could also put a link into a slide that will open a separate spreadsheet file. You can also use the Insert option to put in a spreadsheet. You could use a table. You can create a chart within Powerpoint that will have a set of figures with it. So there are a number of ways of doing it.You could copy a part of a spreadsheet from another application, such as Excel, and paste it into Powerpoint. You could also put a link into a slide that will open a separate spreadsheet file. You can also use the Insert option to put in a spreadsheet. You could use a table. You can create a chart within Powerpoint that will have a set of figures with it. So there are a number of ways of doing it.You could copy a part of a spreadsheet from another application, such as Excel, and paste it into Powerpoint. You could also put a link into a slide that will open a separate spreadsheet file. You can also use the Insert option to put in a spreadsheet. You could use a table. You can create a chart within Powerpoint that will have a set of figures with it. So there are a number of ways of doing it.You could copy a part of a spreadsheet from another application, such as Excel, and paste it into Powerpoint. You could also put a link into a slide that will open a separate spreadsheet file. You can also use the Insert option to put in a spreadsheet. You could use a table. You can create a chart within Powerpoint that will have a set of figures with it. So there are a number of ways of doing it.