Office Tab: Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8910.Many users who are accustomed to Microsoft Excel 2003XP(2002)2000 may feel it hard to find out the Page Setup function in the Ribbon.
For further setup, you should click the little square with an arrow in the right bottom of the group. Which I have emphasized in the Figure 1). With Classic Menu, you can easily find out where Page Setup is. Click the Menus tab next to the Home tab, the familiar toolbars and menus show up, and then click File item, the Page Setup option stays in the same place you know in Microsoft Excel 2003. You can use Office 2007201020132016 immediately without any training. Supports all languages, and all new commands of 2007, 2010, 2013, 2016, 2019 and 365 have been added into the classic interface. Page Setup In Excel Free To SubmitPrivacy Policy Contact Us If you have any questions or suggestions about our products or web site, please feel free to submit them to us. We have the - Do we want to print this Active Sheet, the Entire WORKBOOK or just a Selection of CELLS. Transcript Hi, my name is Shir and Im the founder and CEO of shirconsulting.com where we focus on converting the existing data from your business into massive savings and extraordinary profits. Lets get started. So now that you have your EXCEL SPREADSHEET filled with data, lets try printing it out. First thing were 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, lets go to Page Layout. ![]() Whats 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. And the different Headers and the Formula Bar whether you want to see it or not. ADVERTISEMENT Thanks for watching Visit Website So here were 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. ADVERTISEMENT Thanks for watching Visit Website ADVERTISEMENT Thanks for watching Visit Website 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 were 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. ![]() Im going to choose Narrow so we get as much space as possible. We can change the Orientation so that its Landscape or Portrait. If you want to make it all fit on one page, its usually a good idea to hit Landscape in this case. Were 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 dont care how many pages it goes vertically as long as its one page Wide. Thats 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. You can also say - I dont care how Wide it is, I just dont want it to be any more than one page high. 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. Another way to get to all these options is to hit CTRLP or PRINT or we can also do the File and Print over here. Right, so if I did it with the keyboard it would be CTRLP - brings us to whats called Backstage View and we have a bunch of these options here as well.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |