answersLogoWhite

0


Best Answer

Assuming you're using Microsoft Excel, select the entire column by clicking and dragging with the mouse, then press the AutoSum button (looks like Σ).

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you produce the sum of a column by using the auto sum function?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Will the Excel auto-sum function automatically find the sums of several columns in a range and put the currect sum below each column?

Yes, you can do that. If you have a series of columns, you can highlight all of the column to select the range. When you click on the auto-sum button, Excel will insert =SUM(XX:XX) at the bottom of each column in the range.


How do you do column width command in Excel?

When you say column with command, you mean automatically adding a new column or autoadjusting a column?To add a column using a shortcut, you need to highlight a column/s first (short cut is Shift key + Space bar) then press your Ctrl and + Keys simultaneously.If you want to auto-adjust a column's width using a shortcut, you can use Alt + H O + I (texted with Excel 2007 version).


How do you indicate that a column totals?

This question is not clear. In Excel, you can get the total of a column by highlighting the numbers you want to add and clicking the auto-sum button. Or you can use the SUM function at the bottom of the column. If your number are in A1 through A23, in A24 enter the formula =SUM(A1:A23).


What does double-clicking the column line to the right of a column activate?

Auto fit


Auto correlation function ACF?

auto correlation function of a stationary process is an even function


How do you add the total or a column full of numbers without using a calculator?

Since you put this question in the Excel category, I will answer relative to what you can do with Excel. The quick way is to highlight the column of numbers and click on the Auto-Sum button.


Does auto column adjust mean that the width of the column will be increased or decreased so the widest entry will fit in the column?

yes


What auto column enterchanges with 66 tempest?

1966 GTO


What makes the width of the column increase or decrease so the widest entry can fit?

It is called Auto-Fit Column width. You will find it in the cell format options. When you click on the Auto-Fit button, your column will automatically expand to allow room for the widest contents of a cell in the column.


Does Microsoft Excel have auto column adjust?

When a referenced change the cell ,automatically updating the formulas


How do you integrate and lay out text and non-text?

To know how to integrate text and non-text items in a document, I use the format function on the toolbar. By using the insert and page layout functions I can design roughly. To fit text into a non-text item, I would use the Format Auto shape dialog and click the Text Tab box and then Text auto fitting would produce options for me to use. In tight squeezes I can make my text vertical, by rotating it, using Auto shape.


What would happen if you Auto Fit the width of column A after you entered the worksheet title?

If the title is in column A, then it will adjust to fit it, if it is wider than anything else in column A. If the title is not in column A, then the title will have no impact on what happens when you Autofit column A.