[AccessD] OT: Excel cell formatting

John,

 When you go to do the paste, right click and do a "Paste Special"

  You'll get a dialog where you can select various options (such as
contents, borders and shading, etc) for what gets pasted.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, January 04, 2011 04: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