Sidebar Sidebar
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

Numbers: Can I have the row with the totals on top?

D

desertman

macrumors 6502a
Original poster
Jul 14, 2008
694
37
Arizona, USA
I have a Numbers spreadsheet in which I list all my revenues and their totals. For 2014 I had this spreadsheet in the "conventional" way with all the totals at the bottom of the sheet.

For this year I would like to have the totals on top. Is that possible? And how would I do this?

The old sheet looks like this:

Header row
Content rows
Totals row
Header row

What I want is this:

Header row
Totals row
Content rows
Header row
 
Meister

Meister

Suspended
Oct 10, 2013
5,456
4,310
Of course you can.
Just move the totals row wherever you want it or just add the appropriate formula in the cells you want to display the total.
 
Last edited:
GGJstudios

GGJstudios

macrumors Westmere
May 16, 2008
44,545
943
desertman said:
I have a Numbers spreadsheet in which I list all my revenues and their totals. For 2014 I had this spreadsheet in the "conventional" way with all the totals at the bottom of the sheet.

For this year I would like to have the totals on top. Is that possible? And how would I do this?

The old sheet looks like this:

Header row
Content rows
Totals row
Header row

What I want is this:

Header row
Totals row
Content rows
Header row
Click to expand...
That should be very simple to accomplish. I don't use Numbers, but it's very easy in Excel. One way is to create the totals row as you normally would, then simply select the row, cut it and paste it under the header row. You could also create the formula in the desired row, selecting what range of cells you want to total. The totals can be above, below, to the left or right.
 
You must log in or register to reply here.
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.
Top Bottom