#1
|
|||
|
|||
cut&paste cell contents AND formatting
I have a table where certain cells are background shaded one of two colors. When I cut and paste a cell from one part of the table to another (an empty cell), the words are pasted, but the shaded background is left behind.
Can this be done? This is an ever-changing table; names will frequently be cut and pasted elsewhere. *Alternate Option: I would expect the formatting to follow the cell in a SORT, but I don't know this. This is a three column table with about 25 lines, with people names in each cell. When I add/drop names, if I use the alphabetical RESORT option, it resorts across rows. I want this to resort by column, that is, the last name in column 1 is followed by the next alphabetical name in the first row of column 2. Is there a way to alphabetically sort in this manner? I tried newspaper columns but then there was lots I could not do (that tables can do). |
#2
|
||||
|
||||
Hi cglenn,
AFAIK, that's the way Word works - by design (other users might be upset if cutting & pasting data did as you want). If there's a consistent pattern to the shading (eg alternate rows green or yellow, or a number like 1 or 2 in a cell determines the shading for the cell or row), a simple macro could be used to go through the table after the updating has been done and re-apply the correct shading.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks Paul. While there is no pattern (it's a list of Farmville neighbors with some shaded green as good neighbors, others pink as bad neighbors and no shading for a few others), I could add a number 1 or 2 to the shaded cells. Having next to no experience with macros, it might take a little time for me to try and figure it out. If I have questions, I'll post in the appropriate macro area.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How can I paste cell "A1" contents to cell "B1" if cell "A1" is not blank? | Learner7 | Excel | 1 | 04-25-2011 04:39 AM |
How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |
Copy all comments & cell contents (i.e. data) to word? | IanM | Excel | 0 | 07-03-2010 11:14 PM |
Copy the contents of a dcoument and paste it several times in a new document | Gerjanst | Word VBA | 0 | 06-30-2010 12:51 PM |
Paste contents skiping from cursor pos . | aligahk06 | Word | 0 | 10-20-2009 05:53 AM |