Sort by either cube # or ext# and print all on one page

I need to be able to sort the information contained in this spreadsheet by either cube# or ext# and print it all on one side of one page, as visibly as possible.

Assistance is greatly appreciated.
EE-Mapping.xlsx
frugalmuleAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
I believe you started it in a standard table form.

So I moved it back to the table form, and built a report based on the table ("For Printing").

Now in the attached you can sort your table, and it will be reflected in the report.
EE-Mapping141215.xlsx
0
frugalmuleAuthor Commented:
I need it to be something everyone can use, or at least sort on.  Two tabs is going to be too confusing :(
0
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Firstly, you have my sympathies. If you work in an organise that two tabs in a spreadsheet are going to be too confusing, it must be a nightmare to work in.

Secondly, let's reduce it to one spreadsheet - see attached.
EE-Mapping141216.xlsx
0
frugalmuleAuthor Commented:
Excellent.  I'm not sure I understand how you did it but it's perfect.  How do I change the text in the header so that it is visible when viewing it?
0
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
You need to adjust the height of row 1.

Unfreeze the panes (View - Freeze Panes - Unfreeze panes)

Go up to row 1.

Make it about 3 lines deep.

Re-freeze the panes.

And, as a tip on how I did it, try going across to column BA. :-)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.