Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default tying columns of data into a specified page size


This may be an easy question.

I have 3 thin columns of data that are 1000 rows long.

I have kept them like this so that i can use the alphabetical-order
tool successfully.

However i need to, now, put this data into an 11/17 page. so there will
now be several greater columns of the 3-columned data side by side. I
want to format the page so that i can still use the alphabetical tool
in respects to the entire list (which is now spanning horizontally
across the sheet in many 3-column groups). As well, i need to maintain
that data in the 3 columns remains side-by-side. So, i need the
formatting to respect the 3 columns as "together" so that when i use
the alphabetical-order tool it "expands the selection" for all 3
columns (yet not the other columns which are now side by side)

Thank you.

By




--
byby
Reply
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
Tying to extract all data from a pivot pulling from external data Ted Urban Excel Discussion (Misc queries) 3 September 14th 07 10:50 AM
Auto size a pivot table to a page size *.* Excel Worksheet Functions 1 August 23rd 06 05:09 AM
Size of Workbook(columns/rows/data) Browner Excel Discussion (Misc queries) 3 July 13th 06 06:12 PM
custom size (page size) missing in excel 2003 Donald Borja Setting up and Configuration of Excel 1 May 22nd 06 10:53 AM
Tying an imported graphic to a cell T.R. Young Excel Discussion (Misc queries) 0 October 5th 05 08:52 PM


All times are GMT +1. The time now is 02:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"