#1   Report Post  
nospam
 
Posts: n/a
Default box formatting

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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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   Report Post  
nospam
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting Error ddate Excel Worksheet Functions 0 May 5th 05 09:00 PM
difficulty with conditional formatting Deb Excel Discussion (Misc queries) 0 March 23rd 05 06:13 PM
conditional formatting question Deb Excel Discussion (Misc queries) 0 March 23rd 05 02:07 AM
Formatting dates in the future Compass Rose Excel Worksheet Functions 3 January 17th 05 10:39 PM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 03:33 PM


All times are GMT +1. The time now is 02:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"