freeze layout

  • Thread starter Thread starter willem
  • Start date Start date
W

willem

is there any way to just freeze layout of cells etc (border shading) while
you can still drag down (copy) formulas etc

Thanks,

W
 
Instead of dragging (which causes a complete copy), do a normal copy, select
the destination cell(s), then right-click, paste special, formulas only.
 
You must log in or register to reply here.

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

Similar Threads

freeze borders and shading 2
PowerPoint Freeze animation 1
Unable to freeze panes 16
Freeze Formatting 1
Excel table setup 3
PC often crashes, at the beginning or after pixels appear 3
conditional formatting 1
Non Printing of Cell borders 7

Back
Top