Reply To: [email protected]
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-6"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <[EMAIL PROTECTED]>
On Monday 23 October 2006 02:12 pm, Kirill S. Palagin wrote:
> Hello.
>
> Is there easy (one-step, mouse-only, shortcut or mouse+shortcut)
> way of inserting sum for several sparsely populated (with gaps)
> columns? Like in that _other_ spreadsheet app you select an area
> with values, click "Sum" button on the toolbar and column-wise sums
> are inserted right below the selection.
>
> Thanks a lot.
> WBR,
> K. Palagin.
You were not clear enough for me to understand clearly what you
wanted. If you had said create a sum for each column, I would have
understood better.
Is this what you mean? You have data scattered in cells over a
range. (Suppose the range is A2:W7.) You are looking for the sum for
each column from A through W.
If this is the case, these steps will do it:
1) Click A8 to highlight it.
2) Click the Sum icon (it is the Greek letter sigma) and <Enter>.
3)Click A8 to highlight it again.
4) Shift+End (This highlights cells A8 through W8.)
5)Edit > Fill > Right (This fills in the formulas for summing each
column to cell 8 of its column.)
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
