Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How Do I Ad Columns and Rows?
I'm working on a budget with items across the top row and months along the
left side column, i'd like to be able to ad both rows and columns up automatically as they go. i'm not certain how to do this. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How Do I Ad Columns and Rows?
by 'ad' do you mean SUM()? Or do you mean insert new rows and columns?
To SUM things, simply use the SUM() function and reference the range you want summed, i.e., =SUM(a2:A30) to add together all the values in cells A2 through A30. If you're not asking about SUMs, I'm not sure what you you mean by'automatically' inserting rows and columns "Roemy" wrote: I'm working on a budget with items across the top row and months along the left side column, i'd like to be able to ad both rows and columns up automatically as they go. i'm not certain how to do this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rows & Columns in Excel | Excel Worksheet Functions | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
inserting columns within certain rows only | Excel Discussion (Misc queries) | |||
Repeating Rows and Columns on each page of print out | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) |