Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 7th 08, 09:14 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 38
Default inserting rows where a formula is inuse for that column

i have a spreadsheet in excel 2003 that i use to figure trucking miles and
the rate for those miles. it is done in alphabetical order. when i need to
add a row, how do iget the formula to apply to that row like the others.

  #2   Report Post  
Old March 7th 08, 10:35 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,440
Default inserting rows where a formula is inuse for that column

ToolsOptionsEdit tab, check Extend data range formats and formulas
Read HELP to make sure how it works

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Rose" wrote in message ...
|i have a spreadsheet in excel 2003 that i use to figure trucking miles and
| the rate for those miles. it is done in alphabetical order. when i need to
| add a row, how do iget the formula to apply to that row like the others.


  #3   Report Post  
Old March 7th 08, 10:38 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default inserting rows where a formula is inuse for that column

Where is the formula located and what does it look like?

You can enter a formula at the top of the sheet like =SUM(A:A) entered in B1

You can enter a formula at the bottom of the data range.

=SUM(A2:INDEX(A:A,ROW()-1)) entered in A12

As you insert rows above row 12, the formula will include those rows.

If you also want the formulas inserted with the row see David McRitchie's site
for his INSERTROW event code.

http://www.mvps.org/dmcritchie/excel/insrtrow.htm


Gord Dibben MS Excel MVP

On Fri, 7 Mar 2008 13:14:08 -0800, Rose wrote:

i have a spreadsheet in excel 2003 that i use to figure trucking miles and
the rate for those miles. it is done in alphabetical order. when i need to
add a row, how do iget the formula to apply to that row like the others.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for inserting a $ amount in a Column if certain met TRM Excel Discussion (Misc queries) 3 January 4th 08 08:56 PM
Inserting rows without changing formula values Hook''em 2006 Excel Worksheet Functions 5 December 27th 06 09:45 PM
inserting rows without adjusting formula relationships Daiv Excel Discussion (Misc queries) 1 August 2nd 06 11:30 PM
Static formula when inserting new rows/columns? nfe Excel Discussion (Misc queries) 4 May 2nd 06 02:55 PM
Inserting rows and having the formula follow workofiction New Users to Excel 1 June 21st 05 04:14 PM


All times are GMT +1. The time now is 10:48 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017