You are the best! I have looked and read numerous articles about how to print excel spreadsheets and have never figured it out. Now by watching your video in less than 3 min I am finally able to print it. THANK YOU VERY MUCH!!
Most videos shown are for vertical printing in one page. How about printing in a horizontal form? As I tried in horizontal form, the columns are no longer have the same size. Thanks.
In your example all the text seems mostly to the left on the page. How can it be made to look more evenly spread across the page? Also how do you print with horizontal lines only?
Hi there. Both are excellent questions. Here are a couple of things to try. For question #1, try increasing your left margin. You may need to fiddle with this a bit until you get it right. Question #2, try applying a middle border to your cell range. To do this, select over the range where you want the horizontal line, from the Home tab click the Borders button > click More Borders. The Borders option box will open. Look for 3 buttons placed vertically under the heading 'Borders'. Click the middle button. This should place a boder into the middle of the preview box. Click OK and you will now have horizontal borders, no vertical borders, so when you print on the horizontal lines will print. I hope this helps.
Hi there. I've just published a video that will help you balance your worksheet when printing. I hope this is helpful to you czcams.com/video/lWegAS-wtLE/video.html
I'm learning Excel and have two questions. Can I use this technique, but I want the grid lines to show on my printout. How can I show them. Is there a way to put some Clipart and pictures etc at the top of the printout if I want it to look a bit more decorative or if I want to put my logo on it?
Hi Barbra. To print your gridlines, go to the Page Layout Tab and under the Gridlines heading place a check in the Print box. Yes, you can add your logo at the top. First resize and save your logo so that it will fit nicely at the top of the page, then from the Insert Tab click Header- & Footer. Click into the section of the Header where you would like to place the logo. You will see a Picture option on the Ribbon. Click this and upload your logo into the Header. You can click out of the Header area when you are finished but you may still be in the Page Layout view where you can see your logo. To go back to your normal view you may need to go to the View tab and set your view back to Normal. I hope this helps :-)
I've been trying to get my semester planner assignment to fit on one A3 page, when I try to print it will not come out large enough but there is still plenty of room on the A3 page. I have tried adjusting the font sizes, and when I went 72 max font it's too large, it only prints half of the content to one page even when I have set it to print on one page. I have spent over a week re editing over and over again. I know there is a way to get the content to come out nice and visible and readable because there is still more room on the A3 page, but when I Have the font set to roughly 16 it was still not very readable.😱 I am going to give up I've been at the library until past midnight the last two nights trying to do this, It is part of my assignment requirements to fit it to 1 page. I know there is just something easy within the print settings or on the actual printer settings.
Hey Dylan. How frustrating for you. I'm sorry I have only just read your message. Forgive me if you have already checked this a million times, but is your Paper Size set to A3 (Page Layout tab > Size > A3)?
Need help scaling to fit a spreadsheet on one page? Let Sharyn help.
You are the best! I have looked and read numerous articles about how to print excel spreadsheets and have never figured it out. Now by watching your video in less than 3 min I am finally able to print it. THANK YOU VERY MUCH!!
Yayyyy!!! Awesome, thank you!
thanks you very much.
You are welcome. So glad it helped!
Very helpful channel. Thank you for clear explanations.
Thanks Faith! Really appreciate your comment and so happy to have been of help. Sharyn 😊
thanks lady any more of your work i will be keen to follow
Awesome! Thank you!
Most videos shown are for vertical printing in one page. How about printing in a horizontal form? As I tried in horizontal form, the columns are no longer have the same size. Thanks.
Very helpful...Thank you
Fantastic. So glad it helped 😊
Thank you so much for this great tip :-)
You are so welcome!
Thank you for sharing
My pleasure
Thank You so much.
You're most welcome
Good tricks thank you.
You're welcome!
Thank you.
You're welcome!
Fantastic, thank you!
You're very welcome!
love it thanks
So glad Ziryab!
Thank you 😊❤️
You’re welcome 😊
Thanks😊
You're welcome ☺️
In your example all the text seems mostly to the left on the page. How can it be made to look more evenly spread across the page? Also how do you print with horizontal lines only?
Hi there. Both are excellent questions. Here are a couple of things to try. For question #1, try increasing your left margin. You may need to fiddle with this a bit until you get it right. Question #2, try applying a middle border to your cell range. To do this, select over the range where you want the horizontal line, from the Home tab click the Borders button > click More Borders. The Borders option box will open. Look for 3 buttons placed vertically under the heading 'Borders'. Click the middle button. This should place a boder into the middle of the preview box. Click OK and you will now have horizontal borders, no vertical borders, so when you print on the horizontal lines will print. I hope this helps.
@@ExcelatWork kindly make a video on these question to understand properly.
Hi there. I've just published a video that will help you balance your worksheet when printing. I hope this is helpful to you czcams.com/video/lWegAS-wtLE/video.html
I'm learning Excel and have two questions.
Can I use this technique, but I want the grid lines to show on my printout. How can I show them.
Is there a way to put some Clipart and pictures etc at the top of the printout if I want it to look a bit more decorative or if I want to put my logo on it?
Hi Barbra. To print your gridlines, go to the Page Layout Tab and under the Gridlines heading place a check in the Print box. Yes, you can add your logo at the top. First resize and save your logo so that it will fit nicely at the top of the page, then from the Insert Tab click Header- & Footer. Click into the section of the Header where you would like to place the logo. You will see a Picture option on the Ribbon. Click this and upload your logo into the Header. You can click out of the Header area when you are finished but you may still be in the Page Layout view where you can see your logo. To go back to your normal view you may need to go to the View tab and set your view back to Normal. I hope this helps :-)
@@ExcelatWork Thanks so much
I've been trying to get my semester planner assignment to fit on one A3 page, when I try to print it will not come out large enough but there is still plenty of room on the A3 page. I have tried adjusting the font sizes, and when I went 72 max font it's too large, it only prints half of the content to one page even when I have set it to print on one page. I have spent over a week re editing over and over again. I know there is a way to get the content to come out nice and visible and readable because there is still more room on the A3 page, but when I Have the font set to roughly 16 it was still not very readable.😱 I am going to give up I've been at the library until past midnight the last two nights trying to do this, It is part of my assignment requirements to fit it to 1 page. I know there is just something easy within the print settings or on the actual printer settings.
Hey Dylan. How frustrating for you. I'm sorry I have only just read your message. Forgive me if you have already checked this a million times, but is your Paper Size set to A3 (Page Layout tab > Size > A3)?
Is it possible in 2010 MS excel
HI there. Yes it is 😊
U
Thank you so much for this great tip :-)