If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

excel help - print x rows per page

Random · 2010-12-29 21:41:18

hi there, i'm using excel. i have (for example) about 100 rows. i'd like to print them all so that i have exactly 31 rows per page. i can't find any option to allow me to do this. can anyone help me out please? thanks

29-12-2010 9:41pm

#1

Random

Closed Accounts Posts: 19,080 ✭✭✭✭

Join Date: September 2004

Posts: 16669

hi there, i'm using excel. i have (for example) about 100 rows. i'd like to print them all so that i have exactly 31 rows per page. i can't find any option to allow me to do this.

can anyone help me out please?

thanks

0

Comments

#2 29-12-2010 10:21pm

Gaspode

Registered Users, Registered Users 2 Posts: 8,044 ✭✭✭

Join Date: November 2004

Posts: 7319

If I'm doing that I select the rows I want, go to the print dialog and click the 'selection' check box in the spot where it asks you what to print.

0
#3 30-12-2010 7:40pm

Random

Closed Accounts Posts: 19,080 ✭✭✭✭

Join Date: September 2004

Posts: 16669

in the end i just used print preview and kept adjusting until i saw the right number of rows per page. was hoping for a more permanent solution though.

0
#4 30-12-2010 8:50pm

mp22

Moderators, Business & Finance Moderators, Regional South Moderators Posts: 6,854 Mod ✭✭✭✭

Join Date: November 2008

Posts: 6308

Is this what your after

0