How do I lock ONLY the formatting on an excel sheet?

C

Court

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

Luke M

Nope. You could only mimic these by having the formatted cells that referred
to the sorted cells via the INDIRECT function.
 
D

Dave

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top