Watch more How to Use Microsoft Excel videos: Learn page setup and printing in this Howcast Excel tutorial with expert Shir Moscovitz. Hi, my name is Shir and I'm the founder and CEO of shirconsulting.com where we focus on converting the existing data from your business into massive savings and extraordinary profits. Today we're going to learn the basics of Excel. Let's get started. So now that you have your EXCEL SPREADSHEET filled with data, let's try printing it out. Here are some basic tips to follow. We have great news about Excel for Mac! Then look at the Header & Footer tab on the ribbon. There's a 'Picture' button which lets you insert any picture from your computer or you can format a picture that's already been added to your header or footer. First thing we're going to want to do is go to the View Tab on the RIBBON if we have 2010 or 2007 version of EXCEL. Here, we have a bunch of different choices - this is version 2010 - so instead of doing the Normal layout, let's go to Page Layout. That gives us a little preview of what it looks like on the page. We can scroll down and see the edges of the page. What's nice to have here is the Ruler which you can uncheck this way just to see in terms of the measurements of the page in inches in this case. The gridlines which of course are the EXCEL CELLS, the borders themselves. Java se 6 for mac os x. Download Java for OS X 2017-001 Java for macOS 2017-001 installs the legacy Java 6 runtime for macOS 10.13 High Sierra, macOS 10.12 Sierra, macOS 10.11 El Capitan, macOS 10.10 Yosemite, macOS 10.9 Mavericks, macOS 10.8 Mountain Lion, and macOS 10.7 Lion. And the different Headers and the Formula Bar whether you want to see it or not. So here we're going to have all this visible so we can add a Header just by clicking on it and saying - 'Title of our Data' - and that will appear on the Header of every page. ![]() Or we could do the same thing with a Footer. We can do a page number for example. So another place we need, want to go is the Page Layout tab which has a bunch of useful commands right here. So the main ones we're going to focus on are Margins to basically quickly decide how much space we want in between the content of our page and the edge. In this case it's Normal so it gives you the breakdown of.75' to the top, to the left, bottom and right. Here's the breakdown. You can choose Wide or Narrow. I'm going to choose Narrow so we get as much space as possible. We can change the Orientation so that it's Landscape or Portrait. If you want to make it all fit on one page, it's usually a good idea to hit Landscape in this case. We're also going to want to go here and take a look at the Scale to Fit option. If you have a lot of stuff on your SPREADSHEET and you want it to fit without having to re-size or change the COLUMNS, you can simply say - 'I want it to all fit on one page of Width.' So I don't care how many pages it goes vertically as long as it's one page Wide. That's all I want. And that limits it to that, scales it in order to make it fit. So it literally shrinks down everything so that it fits into that criteria. I am going to Automatic so it doesn't really do anything. You can also say - 'I don't care how Wide it is, I just don't want it to be any more than one page high.' And then you can limit it that way. The other option is to simply take the Scale: Percentage and say 'I want to take whatever I have now and make it 50%' and hit ENTER and now everything is smaller when we print it out.
0 Comments
Leave a Reply. |