Copy, Auto-fill, Extrapolate, read on...

[Dan Wilson]

Good day. I am using Excel 2002 on Win XP Pro. I have a worksheet that contains several columns of formulas relating to calculations against a value placed in Column A. I have just installed MoreFunc from Laurent Longre and will be using the INDIRECT.EXT function to replace lengthy references in the formulas. As such, I now need to Copy, or Auto-fill or Extrapolate the amended formula from Row 1 through Row 100 of several of the Columns in my worksheet. I have placed the $ where it needs to be in the formula so that my formulas will automatically increment where needed and hold the reference fixed were needed.

My problem is that I have also formatted the columns with borders that contain a solid line around the box and a broken line to separate the cells within the box. When I select the top Row of the Column and then attempt to copy the formula to Row 100, the border changes to the formatting of the top Row.

I seem to recall reading that there is a way to prevent this from happening. I have searched the message board and the Excel Tips book, but apparently I have not entered the correct phrases to search. Any help will be appreciated.

Thanks, Dan...

 

[gingersteve]

Try Edit/Paste Special/Formulas. You won't be able to use autofill, but it will achieve your aim