So I have a big list of names and I’m trying to sort them normally A-Z. My problem is that I need to print said list on one page, but the list is too big. So I’m trying to see if there’s a way to have the column overflow into the next column but still be able to be sorted as if it were one big column. I know that I could sort it in on big column and manually drag the cut off portions into their own columns but I’m sure there’s a better way. Another downside to having to drag it would be that to add another name I’d have to put them all back into a column, sort, then drag every 47 rows back out.
To this, but without manually dragging every 47 lines back up
>Solution :
Yes, done this by having a long column as the source, but the columns in the print area absolute reference 60 or 65 cells of the source column to make a neat list.
Edit, pasted 80 names into col A and the names go straight across, check your format on the cells.
The largest to smallest sorts were done last.
