Create one page worksheet ?

[FDLeyda]

When creating a one page worksheet can I preset the number of Rows and Columns I want ?

When using the % adjustment to fill a printed page can I adjust Rows and Columns separately ?

How can I make sure the printout will fill a Landscape mode page all the way to the right edge ?

Thank you.
FDLeyda.
My first post.

[terry3218]

Hi. Umm I am no expert, but I am pretty sure that the answer to your 3rd question would be using the print area command that is use this command to select the area you want to be printed. You can selected the area, and then go to page layout>print area> select print area. Sorry I can't answer the other two questions.

[FDLeyda]

I have tried that many times. Maybe I am not doing the steps right ????

[FDLeyda]

I have tried that many times. Maybe I am not doing the steps right ???

[terry3218]

Can you upload a sample worksheet?

[FDLeyda]

I am willing but I do not know how.

[terry3218]

Instead of "post quick reply", go to " go advanced", and then there is an attachment icon, with which you can upload files

[FDLeyda]

Here it is. Thank you for your help so far.
Drew

[terry3218]

If you increase the columns' (check columns) size to 55 Pixels, and in the print layout menu choose " Fit all columns on one page" under the scaling option, the print will then go all the way to right edge.Untitled.png

[FDLeyda]

Sorry to take so long to respond. I went camping last weekend and it wiped me out.

I do not know how to do what you suggest. Could you give me the steps to do this. I do know my row and column sizes are not in pixels.

Thank you.
Drew

[terry3218]

Sorry for the late answer; I was caught up in work so much so I didn't have the energy or time to respond in the last few days. Hope you have sorted out this issue yet?

[FDLeyda]

It is sorted.
I used your suggestions and expanded on them to find the solution.
Basically trial and error.
Thank you.

[terry3218]

I am so glad that I could be of help. Have a nice day! :-)