[AccessD] OT: Excel cell formatting

I run into a similar problem occasionally and it drives me nuts. If I copy 
cell contents to a cell that has a border, the border cell loses its border 
format. :( This might prove useful!

Susan H.

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