Software

Ask something
Discussion Locked

Excell 2000

0 helpful
3 replies

by adamovir

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I,m making a long list of numbers, 4 columns wide.
Its at least 15 pages long. I want to shorten the pages to 7 by making 2 set of 4 columns wide on each page.
My problem is it won't sort the columns in proper order in all the columns and pages. It will only sort the left set only or the right set only.
Please I need help.
thanks bob

3 replies

by dklippert

Try this, copy and paste your 4 column wide list of numbers into Word.
Go to Format>Columns and enter 2 into the number of columns box (Or use the Columns icon on the Standard toolbar)
Now click in the first cell and got to Table>Sort
If this is for a report, Word makes it easier to format.

This discussion is closed to new replies.