HTFC Forums

H.T.F.C.

How To Fix Computers





Go Back   HTFC Forums > Software Newsgroups > Microsoft Office

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1  
Old 03-03-2008, 09:48 PM
David Langschied
 
Posts: n/a
Default Adding a row to a calculated column

I need to find out how to add a row to a calculated column. I have a total
at the bottom and when I add the column the total does not change. I can
modify the formula to add the new row, but I have to do this all the time and
was looking for an easier way to do this.
Reply With Quote
Sponsored Links
Fix your Windows Problems - FAST.
FREE Safe Scan Registry Check. Locate & Fix Errors in Minutes!
  #2  
Old 03-03-2008, 10:35 PM
Bob I
 
Posts: n/a
Default Re: Adding a row to a calculated column

Insert the new row into the "Summed" area.

David Langschied wrote:
> I need to find out how to add a row to a calculated column. I have a total
> at the bottom and when I add the column the total does not change. I can
> modify the formula to add the new row, but I have to do this all the time and
> was looking for an easier way to do this.


Reply With Quote
  #3  
Old 03-03-2008, 10:50 PM
DL
 
Posts: n/a
Default Re: Adding a row to a calculated column

If you used the auto sum Btn then a simple insert row will suffice

"David Langschied" <DavidLangschied@discussions.microsoft.com> wrote in
message news:FCABDA19-93E9-42F2-BCE9-075A7AECBC61@microsoft.com...
>I need to find out how to add a row to a calculated column. I have a total
> at the bottom and when I add the column the total does not change. I can
> modify the formula to add the new row, but I have to do this all the time
> and
> was looking for an easier way to do this.



Reply With Quote
Sponsored Links
Reply


Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel, stacked column chart, modify column width RobertAkiraWatts Microsoft Office 0 01-07-2008 04:39 PM
Excel Matching on this column Howard Brazee Microsoft Office 0 05-10-2007 01:48 PM
How do you do dot leaders from end of word to end of column? muffin Microsoft Office 1 05-08-2007 05:48 AM
keep same column widths in all folders Catherine Windows Vista 0 04-29-2007 07:36 PM
Blue column on desktop corpsstories Windows XP Basics 6 04-11-2007 01:57 PM


All times are GMT. The time now is 06:03 AM.


Powered by vBulletin® Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.1.0
© 2004 - 2007 Web-S-Sense Pty. Ltd. Usenet and forums posts © their respective authors.
Ad Management by RedTyger