How can I lock the formatting (patterns) in Excel?

G

Guest

I am trying to set up a patterened spreadsheet, similar to a checkbook
register with alternating colors for each row. However, if I want to copy
and paste, or drag any information around, all the colors move from where it
was selected from. Is there a way to lock the formatting (keep the patterns
like as a background) but still be able to copy/paste and move things around?

Thanks!
 

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

Formatting cell 2
Can I lock formatting in Excel while keeping the ability to edit? 1
How can I lock the gridlines in an excel spreadsheet? 1
Cell shading not working in Excel 2003 2
Cell shading with conditional formatting 5
Can I sort in Excel and leave the formatting (color) in place? 1
How do I expand the check register template beyond 89 rows? 2
How do I lock ONLY the formatting on an excel sheet? 2

Top