[AccessD] OT: Excel cell formatting

John - cut, then do not PASTE, instead PASTE SPECIAL, values+formulas.

Also, for quick format clean-up, use the Format Painter.....
It's great once you get the hang of it.

> -----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