Prev: Reconstructing a table
Next: Creating a new table from another - filtering out unwanted data
From: Court on 12 Mar 2010 12:10
I want to Lock the formatting on an excel sheet so when i sort the data in
the sheet the background colors and cell formatting stay in place, and just
the data shifts. Is this possible?
From: Luke M on 12 Mar 2010 13:38
Nope. You could only mimic these by having the formatted cells that referred
to the sorted cells via the INDIRECT function.

--
Best Regards,

Luke M
"Court" <Court(a)discussions.microsoft.com> wrote in message
news:C9B9E68D-92DA-45FC-B823-D8B6F40BBDBF(a)microsoft.com...
>I want to Lock the formatting on an excel sheet so when i sort the data in
> the sheet the background colors and cell formatting stay in place, and
> just
> the data shifts. Is this possible?


From: Dave on 12 Mar 2010 20:07
Hi,
Not sure how big your sheet is, or how complex your formatting.
But you could apply your formats using VBA, and have it automatically
reapply the formats after every sort.
Regards - Dave.

"Court" wrote:

> I want to Lock the formatting on an excel sheet so when i sort the data in
> the sheet the background colors and cell formatting stay in place, and just
> the data shifts. Is this possible?
 | 
Pages: 1
Prev: Reconstructing a table
Next: Creating a new table from another - filtering out unwanted data