freeze layout

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
 
L

Luke M

Instead of dragging (which causes a complete copy), do a normal copy, select
the destination cell(s), then right-click, paste special, formulas only.
 

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
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
MS Project 2016 - all tasks not showing in Calendar View 0
Copy addition formula of non-consecutive horizontal cells 2
Merging from an Excel file with graphics 1
Working on birthday "book" for my wife and having layout/editing trouble 0
Freeze column headers for ledger sheets 1
How to paste this down? 3

Top