[AccessD] OT: Excel cell formatting

Cut then Past Special and choose Values as what to paste. Tedious, but should work.

Lambert 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, January 04, 2011 4:40 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] OT: Excel cell formatting

I have a spreadsheet I use which I use border formatting around cells.  The problem is that if I move cells around, the formatting moves with the cell.  I really want the cell borders to be fixed and just the cell contents to move around.

Is it possible to pin down things like the cell border formatting?

--
John W. Colby
www.ColbyConsulting.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com