If I have several hundred items and rather than print many pages with say 40 items per page, how can I get excel to take the next 40 items and bring it to the top of the 1st page spread sheet and across so that it "fills" the printed page. In other words you have 3 columns of items 1-40 top to bottom and then another 40 items to the right of the 1st 40 items so that you utilize the enitire page?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
spreading items across the page
- Thread starter kerrysr
- Start date
Excel Facts
Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Get the ASAP Utilities free add-in at www.asap-utilities.com
Upvote
0
Similar threads
- Question
- Replies
- 11
- Views
- 977
- Question
- Replies
- 2
- Views
- 361
- Replies
- 0
- Views
- 175
- Question
- Replies
- 3
- Views
- 465
