#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). |
|
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 |