Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default adding new rows and keeping same formulas

Hi,

I'm wondering if it's possible in any way to keep my formulas when i
add new rows because I hate writing in the same formulas over and over
and over. Thanks a bunch.

  #2   Report Post  
Posted to microsoft.public.excel.misc
Tim M
 
Posts: n/a
Default adding new rows and keeping same formulas

Can you give an example of what you are talking about? If you want formulas
to always point to certain rows or columns you can use absolute cell
addresses rather than cell A2 you would put $A$2 and it will always point to
the contents of that cell no matter what rows are added.

" wrote:

Hi,

I'm wondering if it's possible in any way to keep my formulas when i
add new rows because I hate writing in the same formulas over and over
and over. Thanks a bunch.


  #3   Report Post  
Posted to microsoft.public.excel.misc
Rich Mcc
 
Posts: n/a
Default adding new rows and keeping same formulas

if you add new rows the formulas will move to allow for them,,, unless you
mean having the formula in your new row if thats the case jusr copy and
paste formula from row above into new row

Rich


" wrote:

Hi,

I'm wondering if it's possible in any way to keep my formulas when i
add new rows because I hate writing in the same formulas over and over
and over. Thanks a bunch.


  #4   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default adding new rows and keeping same formulas

Formulas can typically be copied down. For example, if you have in C1
the following formula:

=A1*B1

then you can copy it down and the cell references will change. For
example, in C5, it will automatically become

=A5*B5

If such is the nature of your formula, then you can fearlessly insert
rows and then simply copy the existing formulas along the entire
column.

HTH
Kostis Vezerides

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
keeping rows intact during sort Jim Excel Discussion (Misc queries) 2 November 25th 05 01:59 AM
keeping formulas static when cutitng and pasting associated celldata ben New Users to Excel 2 October 28th 05 01:10 AM
Keeping a series table from updating when adding new rows. Jacen Saracen Charts and Charting in Excel 2 July 18th 05 04:54 AM
Keeping duplicate rows Daniell Excel Worksheet Functions 2 April 18th 05 06:56 AM
copy / paste selective rows Kenny Kendrena via OfficeKB.com Excel Discussion (Misc queries) 5 February 7th 05 12:55 PM


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

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

About Us

"It's about Microsoft Excel"