[AccessD] OT: Excel cell formatting

or
Right click windows key - S - V - Enter

as I remember it ;)



I use that keystroke a lot!


You may want X instead of V (All except borders)


D
On Tue, Jan 4, 2011 at 2:21 PM, Heenan, Lambert <
Lambert.Heenan at chartisinsurance.com> wrote:

> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>