[AccessD] OT: Excel cell formatting

Darryl Collins Darryl.Collins at iag.com.au
Sun Jan 9 16:25:14 CST 2011


_______________________________________________________________________________________

Note: This e-mail is subject to the disclaimer contained at the bottom of this message.
_______________________________________________________________________________________



As an aside, I always add the "paste formats" and "Paste Value" buttons to the main application toolbar and put them right next the to the "Paste" button.  After years of the bleeding obvious MS have finally done something similar with XL2010 and provides those options automatically when you choose paste.

 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms
Sent: Thursday, 6 January 2011 3:41 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________________________________________________

The information transmitted in this message and its attachments (if any) is intended 
only for the person or entity to which it is addressed.
The message may contain confidential and/or privileged material. Any review, 
retransmission, dissemination or other use of, or taking of any action in reliance 
upon this information, by persons or entities other than the intended recipient is 
prohibited.

If you have received this in error, please contact the sender and delete this e-mail 
and associated material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose or distribute 
the information contained in this e-mail and any attached files, with the permission 
of the sender.

This message has been scanned for viruses.
_______________________________________________________________________________________




More information about the AccessD mailing list