LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 1
Default Formating multiple columns

I have a data sheet with nearly 9000 "rows" of data. Those rows have 7 columns of data. The first column is last names. I need to keep the data in alphabetical order. But since we print this data in book form, I'd like to save paper by creating two columns of this data on one piece of paper. So far there are 52 rows per page. How can I transfer this data into two sets of data per page? keeping it in alphabetical order. In the past we have copy and pasted, but it takes a very long time to do that with this much data.

Thank you,

Atochabsh
 
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
HELP FORMATING COLUMNS Ron Coderre Excel Discussion (Misc queries) 0 July 4th 07 12:10 AM
PROBLEMS WITH FORMATING COLUMNS JTEFUN Excel Discussion (Misc queries) 3 July 3rd 07 09:56 PM
FORMATING COLUMNS..... HELP JTEFUN New Users to Excel 4 July 3rd 07 07:31 PM
Formating columns dbrumit Excel Discussion (Misc queries) 4 January 11th 05 01:21 PM
OWC Formating Columns KLomax Excel Programming 0 December 2nd 03 05:18 PM


All times are GMT +1. The time now is 08:19 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"