[AccessD] OT: Excel cell formatting

Ramz . ramzcbu at gmail.com
Tue Jan 4 16:54:11 CST 2011


I tried the Cut (X) and Paste Special approach, but the "Paste Special"
option is disabled when I choose a "cut" operation in Excel 2007. It's only
enabled when in "copy" operation.

-- Ramil

On Tue, Jan 4, 2011 at 2:43 PM, Susan Harkins <ssharkins at gmail.com> wrote:

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



More information about the AccessD mailing list