Can borders be locked?

C

Craig Snyder

Can borders be locked or frozen like in old versions of Lotus 123? That way
if you copy one cell to another cell with different borders the borders won't
be changed. As I see it, locking the borders should be independent of
locking the cells for content.
 
O

Otto Moehrbach

If you want to copy/paste and you don't want the format (borders, et al) to
follow, do Edit - PasteSpecial - Values. HTH Otto
 

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

Lock Cell Borders 2
Cut & Paste in Excel without erasing cell borders? 1
Conditional formatting border thickness 2
Partial cell protection? 1
Micro to do borders question. 3
How do I mark certains cells with gridlines? 3
Copy&paste cells w/o affecting borders 2
Lock format but allow data entry 1

Top