![]() |
#1
|
|||
|
|||
![]()
I have a problem that causes me to forget words (POCD) so I print out an Excel sheet with 6 columns of 55 words. These words are like 'key words' and each word is linked in my mind to many other words. OK, it's hard to describe but my Excel problem is simple. I hope it has a simple solution.
This list of words has to be sorted from A to Z and the list changes almost weekly. If I need to drop 2 or 3 words and/or add 2 or 3 words I have to copy columns 2 thru 6, one at a time and paste it to the bottom of column 1. Once I have one column of all 330 words and can change it at will and then resort it with a single click. Then I reverse the process and end up with 6 columns of 55 words each. This is a real pain. Is there a way to maintain my word list in a single column, for editing and sorting and then either print it out as a single sheet of 6 columns or, automatically reformat the long column of 6 pages into a single page of 6 columns? Thanks for any help. Steve |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Printing sheet | msheyworth | Excel | 0 | 08-23-2012 07:19 AM |
![]() |
Rigwald | Word Tables | 9 | 08-07-2012 08:14 PM |
Make row in one sheet equal column of another | hypertyper | Excel | 6 | 01-31-2012 03:48 PM |
Adding a long column of time increments in seconds | klippert | Excel | 1 | 09-18-2010 12:26 AM |
sheet linking, sorting | nickbfe | Excel | 0 | 05-19-2006 11:00 AM |