ExcelBanter - Losing cell borders when I copy and paste

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Losing cell borders when I copy and paste (https://www.excelbanter.com/new-users-excel/184406-losing-cell-borders-when-i-copy-paste.html)

Davo

Losing cell borders when I copy and paste

When I copy and paste into a blank cell my borders from the cell dissapear.
What am I doing wrong?

Gord Dibben

Losing cell borders when I copy and paste

Are you copying a bordered cell onto an un-bordered cell?

Format from source will go with the source.

If copying an unbordered cell onto a blank bordered cell, source format will
wipe the target cell format.

Gord Dibben MS Excel MVP

On Sat, 19 Apr 2008 15:47:00 -0700, Davo wrote:

When I copy and paste into a blank cell my borders from the cell dissapear.
What am I doing wrong?

Barb Reinhardt

Losing cell borders when I copy and paste

Try paste special - Values.
--
HTH,
Barb Reinhardt

"Davo" wrote:

When I copy and paste into a blank cell my borders from the cell dissapear.
What am I doing wrong?

All times are GMT +1. The time now is 11:34 AM.