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 >