copying cells with formulas but exclude the formatting

Dan Wilson

Active Member
Joined
Feb 5, 2006
Messages
462
Office Version
  1. 365
Platform
  1. Windows
Good day. I am using Excel 2002 on Win XP Pro. I have searched the Excel Book and the Message Board with no luck. I guess I'm not entering the right phrases.

I need to copy the formulas in a column after changing the formula in the top row. However, I do not want to copy the formatting (borders). The top row contains a full-line border at the top of the first cell and the rest of the column contains broken-line borders at the top of each cell.

I remember reading that there is a way to do this, but I can't seem to find it. Any help would be appreciated.

Dan...
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Dan Wilson

Active Member
Joined
Feb 5, 2006
Messages
462
Office Version
  1. 365
Platform
  1. Windows
Reply

Good day Venkat. As I am still an amateur at Excel, I'm sure that I used the wrong syntax to explain my problem. I will try with a new post. Thanks for the response.
Dan...
 

Forum statistics

Threads
1,181,647
Messages
5,931,210
Members
436,784
Latest member
amuljono

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top