[AccessD] OT: Excel cell formatting

David McAfee davidmcafee at gmail.com
Tue Jan 4 17:06:06 CST 2011


This is true in Excel 2007, I don't remember if it was true for earlier
versions.

On Tue, Jan 4, 2011 at 2:54 PM, Ramz . <ramzcbu at gmail.com> wrote:

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