I am trying to do something in Excel and I'm stuck and not sure how to do this so any help would be appreciated.
I am doing a database of names, I have 3 colums, one is for the name and one is for the origin of the name and the third is for the meaning of the name. There is 20,000 names in total and they are just in one big long line, what I would like to do is be able to fit 6 colums to a page, this would be 2 lots of the 3 colums, I would like it to flow on as its in alphabetical order and I cant work out how is the best and easiest way to do this, I don't want to have to cut and paste as this would be very time consuming.
The reason I don't want to cut and paste half the 20,000 lines of info is because I need to have the information in a particular order, I need page 2 to flow into page one and then page 3 into page 2 etc, does that make sense? Because I need it that way, it would take me forever to cut and paste it, so I need to find a way to easily make page 2 flow over to page one and then continue down.