LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Printing two columns of data in telephone directory style

Hi,

Wondering if anyone can please help?

I have a long (15,000 entry) list of data in two columns that I need to
print. To save space, paper and access time, I'd like to print this list in
two sets of two columns - as the names and numbers in a telephone directory
might appear.

What I envisage is my list starting at the top left of page 1, with its
corresponding data column just to the right. The list would go down to the
bottom of that page and then restart at the top of the page, just right of
centre. Subsequent pages would continue in similar fashion.

I have tried achieving this manually, but it's fraught with potential error.
Also, the moment you edit column width, font size or just about any other
formatting parameter, the whole thing needs repaginating - it's just not
practical.

Is this possible within Excel? I sure would be grateful for any assistance.

Best Regards,

- OftenConfuddled
 
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
how can i create a telephone directory from an excel sheet tal Excel Discussion (Misc queries) 1 October 15th 07 09:20 AM
How do I change sheet notation from R1C1 style to A1 style in XL 2 Sherlock1506 Setting up and Configuration of Excel 1 December 5th 06 03:22 PM
How do i make a telephone directory for the office Anil New Users to Excel 1 May 20th 06 10:12 PM
excel, printing data in columns Nac Excel Worksheet Functions 1 August 23rd 05 03:36 PM
Making a One Column Directory from Two Columns Dennis Hughes Excel Discussion (Misc queries) 1 January 21st 05 04:01 PM


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