Need help scaling to fit a spreadsheet on one page? Let Sharyn help.
@Gsnoop4405 ай бұрын
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!!
@ExcelatWork5 ай бұрын
Yayyyy!!! Awesome, thank you!
@abdallahkambangwa72152 ай бұрын
thanks you very much.
@ExcelatWork2 ай бұрын
You are welcome. So glad it helped!
@girishhate38773 жыл бұрын
thanks lady any more of your work i will be keen to follow
@ExcelatWork3 жыл бұрын
Awesome! Thank you!
@user-ks5cg5cd7m3 жыл бұрын
Very helpful channel. Thank you for clear explanations.
@ExcelatWork3 жыл бұрын
Thanks Faith! Really appreciate your comment and so happy to have been of help. Sharyn 😊
@shaurishauri7786 Жыл бұрын
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.
@collee20753 жыл бұрын
Thank you so much for this great tip :-)
@ExcelatWork3 жыл бұрын
You are so welcome!
@opokubismark64252 жыл бұрын
Very helpful...Thank you
@ExcelatWork2 жыл бұрын
Fantastic. So glad it helped 😊
@kevinmillicent2 жыл бұрын
Thank you for sharing
@ExcelatWork2 жыл бұрын
My pleasure
@stephonharris87892 жыл бұрын
Thank You so much.
@ExcelatWork2 жыл бұрын
You're most welcome
@shrs.34482 жыл бұрын
Thank you.
@ExcelatWork2 жыл бұрын
You're welcome!
@InHomeTutoringHonolulu2 жыл бұрын
Good tricks thank you.
@ExcelatWork2 жыл бұрын
You're welcome!
@ZiryabHamid Жыл бұрын
love it thanks
@ExcelatWork Жыл бұрын
So glad Ziryab!
@Afro_spices Жыл бұрын
Thanks😊
@ExcelatWork Жыл бұрын
You're welcome ☺️
@NoziM06863 жыл бұрын
Thank you 😊❤️
@ExcelatWork3 жыл бұрын
You’re welcome 😊
@No_Plastic2 жыл бұрын
Fantastic, thank you!
@ExcelatWork2 жыл бұрын
You're very welcome!
@barbra4292 жыл бұрын
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?
@ExcelatWork2 жыл бұрын
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 :-)
@barbra4292 жыл бұрын
@@ExcelatWork Thanks so much
@mollydog4442 жыл бұрын
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?
@ExcelatWork2 жыл бұрын
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.
@shubhsingh49052 жыл бұрын
@@ExcelatWork kindly make a video on these question to understand properly.
@ExcelatWork2 жыл бұрын
Hi there. I've just published a video that will help you balance your worksheet when printing. I hope this is helpful to you kzbin.info/www/bejne/oojImHSJYtyngqc
@dylanbyrne40482 жыл бұрын
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.
@ExcelatWork2 жыл бұрын
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)?