General discussion

Locked

Excell 2000

By adamovir ·
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

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excell 2000

by DKlippert In reply to Excell 2000

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.

Collapse -

Excell 2000

by adamovir In reply to Excell 2000

Poster rated this answer

Collapse -

Excell 2000

by adamovir In reply to Excell 2000

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums