Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I lock the formatting (patterns) in Excel?
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! |
#2
|
|||
|
|||
Are you using conditional formatting for anything?
If no, you can use it for this shading: http://cpearson.com/excel/banding.htm AdrianC wrote: 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! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop Excel auto formatting the text 3-4 as 04 Apr? | Excel Discussion (Misc queries) | |||
excel formatting | Excel Discussion (Misc queries) | |||
Excel: Additional Conditional Formatting | Excel Worksheet Functions | |||
Excel cell patterns | Excel Discussion (Misc queries) | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions |