Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
I have a grid which is set up to represent my classroom. It has boarders around some cells to represent desks. The pupils names are in the desks but when I cut a name from a 'desk' the formatting comes too. Is there any way to anchor the formatting so it stays around the cell I originally specified? Thanks |
#2
![]() |
|||
|
|||
![]()
How about using
copy, then paste special|Values, then go back to the other cell and clear the contents? nospam wrote: Hi, I have a grid which is set up to represent my classroom. It has boarders around some cells to represent desks. The pupils names are in the desks but when I cut a name from a 'desk' the formatting comes too. Is there any way to anchor the formatting so it stays around the cell I originally specified? Thanks -- Dave Peterson |
#3
![]() |
|||
|
|||
![]()
Thanks, I'll give that a whirl.
Dave Peterson writes How about using copy, then paste special|Values, then go back to the other cell and clear the contents? nospam wrote: Hi, I have a grid which is set up to represent my classroom. It has boarders around some cells to represent desks. The pupils names are in the desks but when I cut a name from a 'desk' the formatting comes too. Is there any way to anchor the formatting so it stays around the cell I originally specified? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Formatting dates in the future | Excel Worksheet Functions | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |