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