Totaling values in a column WITHOUT a formula in Word 2004

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Ramón G Castañeda (sorry.nomail_at_all.com)
Date: 11/13/04

  • Next message: Ramón G Castañeda : "Re: Totaling values in a column WITHOUT a formula in Word 2004" 
    Date: Sat, 13 Nov 2004 00:39:40 -0800

    In previous versions of MS Word (under Mac 9.x and prior), It was a simple
    matter of highlighting a whole column in a table, hitting a command (Command
    =, I believe) or clicking on the Calculate icon and the total would be
    instantly copied to the clipboard as well as being shown in the lower left
    hand corner of the window.
     
    I¹m now looking for the same functionality in Word 2004.

    This is a form over the design of which I have zero control and which I¹m
    not at liberty to change in the slightest fashion. It¹s a quarterly report
    (which goes to Uncle Sam in Washington DC) on a single page, containing two
    sets of columns because the list of items breaks in the middle, one column
    has integers representing number of events, the other one dollar amounts.

    There is no available cell where I could insert a formula, and the totals
    need to be only at the end of the two columns on the right-hand side of the
    page, not the first two columns on the left. In Word 98, for instance, I
    would highlight the column, hit the total command, paste the result in any
    of the empty cells in the third column, highlight that third column, total
    it again, and paste the grand total at the very end. Then I would delete
    the pasted subtotal from the first column, and everything would be done.

    I¹ve looked in the help files and the MS Office assistant won¹t find the old
    total command. All I get is this instruction of placing a formula in the
    cell where I want the total to appear, which is no help at all.

    As I said, I¹m not at liberty to insert ANY formulas, nor are there
    available cells to do that anyway. I cannot change the design or layout of
    the table in any way.

    My workaround has been to copy the columns into Excel and perform the
    calculations there (Insert Function), copy the result to the clipboard and
    then take it into Word again. I would love to have the old simplicity back
    without having to use Excel at all. It only happens once per quarter, after
    all.

    Any guidance will be much appreciated.

    ---
    Please re-assemble my email address to reply privately if you are so
    inclined: ramonc at surewest dot net .
    Otherwise, replies to the Newsgroup are always welcome.

  • Next message: Ramón G Castañeda : "Re: Totaling values in a column WITHOUT a formula in Word 2004"

    Relevant Pages

    • Copy and Paste problems
      ... When I highlight a cell then click on the copy command, ... spreadsheet whites out and stops working. ...
      (microsoft.public.excel)
    • Re: VBA-Application
      ... in the email address with gmail if mailing direct) ... I want to highlight the row & column corresponding to the cell which is ... cell,as soon as move it to paste on some other cell my copy command get ...
      (microsoft.public.excel.misc)
    • Find
      ... When selecting a column and using the Find command, it is hard to see where ... The color of the cell and the highlight of selecting the column ...
      (microsoft.public.excel.newusers)
    • Re: Any Command to remove spaces
      ... You can use Find & Replace (CTRL-H). ... Highlight the cells, CTRL-H, ... Is there a command to remove all the spaces in the cell (prefix, ...
      (microsoft.public.excel)
    • Re: Me new mac
      ... Both of them bring up a Context Menu, which has Cut, Copy & Paste ... The Apple Mac OS X does have RightClick ... Command + C - Copy ... (or DoubleClick on a word to Highlight a Word & TripleClick ...
      (uk.people.silversurfers)