Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 01-13-2015, 03:46 PM
skbutler skbutler is offline Mac OS X Office for Mac 2011
Join Date: Jan 2015
Posts: 2
skbutler is on a distinguished road
Question Sorting a long column and printing it on 1 sheet

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.

Reply With Quote
Old 01-13-2015, 04:24 PM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Join Date: Mar 2014
Location: Atlanta
Posts: 832
gebobs has a spectacular aura aboutgebobs has a spectacular aura about

There may be a simple solution to this. I've just tested it out briefly.

Put all your words in a single column on one tab, from A1 to A330.

On another tab, enter =Sheet1!A1 into A1, =Sheet1!A56 into B1, ... , =Sheet1!A276 into F1. Select A1:F1, copy and paste from row 2 to 55.

To delete a word, delete the contents of any cell you want in the first sheet. Do not delete the actual cells (if this distinction is unclear, let me know) as this will automatically change the references in the other sheet. In the blank cells, enter your new words. Sort the column and voila, the second sheet is ready to go!
Reply With Quote
Old 01-13-2015, 05:06 PM
skbutler skbutler is offline Mac OS X Office for Mac 2011
Join Date: Jan 2015
Posts: 2
skbutler is on a distinguished road
Smile Great

I'll try this tomorrow but it sounds promising.


Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing sheet msheyworth Excel 0 08-23-2012 07:19 AM
Long, 3 Column Table - Can I make Fit Into Page Columns? 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

All times are GMT -7. The time now is 08:28 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft