ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   tying columns of data into a specified page size (https://www.excelbanter.com/new-users-excel/182864-tying-columns-data-into-specified-page-size.html)

byby

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


All times are GMT +1. The time now is 10:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com