Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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 columns of data into a specified page size byby New Users to Excel 0 April 8th 08 09:08 AM
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


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

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"