1 00:00:14,430 --> 00:00:15,100 Hi, everyone. 2 00:00:15,690 --> 00:00:25,300 And today we are going to discuss and complete print settings and how to print a spreadsheet file. 3 00:00:28,120 --> 00:00:39,160 Print and we are we are going to talk about page set up pages up consists of many steps, page margins 4 00:00:39,610 --> 00:00:41,790 further and further and cheat. 5 00:00:42,610 --> 00:00:45,700 So let's get started with page page. 6 00:00:45,760 --> 00:00:51,500 You can be oriented with portrait or landscape. 7 00:00:51,950 --> 00:00:57,700 OK, this is landscape and this is a portrait. 8 00:00:57,970 --> 00:01:01,740 Also, you can choose the vegetation from here. 9 00:01:02,920 --> 00:01:10,670 Portrait and landscape and portrait taller than landscape and landscape is wider than portrait. 10 00:01:10,720 --> 00:01:11,080 OK. 11 00:01:13,630 --> 00:01:24,510 Bidstrup can be adjusted by person from normal size, so you can increase this person by, say, four 12 00:01:25,350 --> 00:01:30,850 for 60 percent and let's see, it's much better. 13 00:01:30,880 --> 00:01:39,210 Gay can also make it by 80 percent to try. 14 00:01:40,750 --> 00:01:58,510 Oh, no, not convenient to this page, why four pages, let's decrease the this percentage to 70. 15 00:02:02,920 --> 00:02:03,690 Two pages. 16 00:02:04,040 --> 00:02:08,410 The first page and the second page. 17 00:02:12,190 --> 00:02:23,500 So you can adjust this person to print your page or there are another option, much easier than this 18 00:02:23,500 --> 00:02:34,180 option by four to one page white and one page to this page will be fitted to be printed in one page 19 00:02:34,180 --> 00:02:35,860 white and one page two. 20 00:02:36,160 --> 00:02:38,680 Let's get let's try. 21 00:02:39,470 --> 00:02:44,050 OK, here here is our sheet. 22 00:02:44,650 --> 00:02:49,300 Have been selected to be print in just one page. 23 00:02:49,510 --> 00:02:55,850 OK, and this is the difference between scaling FITA or scaling a just two percent. 24 00:02:56,280 --> 00:03:00,250 OK, you can choose many 25 00:03:02,800 --> 00:03:05,590 told if you click zero. 26 00:03:06,920 --> 00:03:13,820 Just one Baojun, OK, so we always choose the to one page white. 27 00:03:14,910 --> 00:03:16,410 And zero to. 28 00:03:18,430 --> 00:03:19,810 To respect what? 29 00:03:20,780 --> 00:03:21,930 Of page, OK? 30 00:03:22,340 --> 00:03:22,750 OK. 31 00:03:25,000 --> 00:03:36,700 Also, you can choose the size can be Laeter or EFORE, it's based on the page and paper size you will 32 00:03:36,700 --> 00:03:37,370 be printed on. 33 00:03:37,580 --> 00:03:37,960 OK. 34 00:03:40,390 --> 00:03:43,960 This is about Beijng, about margin. 35 00:03:44,890 --> 00:03:49,540 Here are the dimensions of margin in each direction. 36 00:03:50,800 --> 00:03:55,330 Top left, bottom right here, futer. 37 00:03:57,610 --> 00:04:03,040 Also you can choose this margins from here. 38 00:04:03,460 --> 00:04:07,030 You can choose normal, white, narrow, OK. 39 00:04:12,190 --> 00:04:20,300 The option here enables you to change the lamination if you want to minimize the margin to zero. 40 00:04:20,350 --> 00:04:25,480 You can minimize all margins to zero. 41 00:04:26,870 --> 00:04:33,100 OK, you will find the Bage wider like that. 42 00:04:33,250 --> 00:04:45,670 No margins here, but you should have minimum margin by just this dimension and OK. 43 00:04:50,040 --> 00:04:51,960 Also about her and future. 44 00:04:56,130 --> 00:05:05,610 You can custom Heather, the hair is second to three sections, left section, central section and right 45 00:05:05,610 --> 00:05:15,510 section and here is the component you can add you can add in the left section, the number of page. 46 00:05:17,370 --> 00:05:27,870 And you can insert a number of pages and you can insert date there time and here and center, you can 47 00:05:27,870 --> 00:05:36,780 insert file Beth and insert file name and here and write fiction. 48 00:05:36,780 --> 00:05:47,100 You can select sheet name and you can insert picture if you want you want to insert a picture from my 49 00:05:47,100 --> 00:05:47,580 desktop. 50 00:05:48,510 --> 00:05:54,340 I will insert this picture here and you can format the picture. 51 00:05:54,390 --> 00:05:58,830 OK, this is about Whitter also. 52 00:05:58,830 --> 00:06:01,530 Similarly, you can customize the footer. 53 00:06:02,220 --> 00:06:10,140 That voter is divided into three sections, left section, center section and right section. 54 00:06:10,450 --> 00:06:20,540 Also you can add, for example, number of pages and here insert it and here insert time. 55 00:06:22,020 --> 00:06:22,340 OK. 56 00:06:23,840 --> 00:06:24,250 OK. 57 00:06:25,020 --> 00:06:35,970 Also you can make these adjustments in old pages or make the first page different than the other pages. 58 00:06:35,970 --> 00:06:42,690 If you want to check this option, you can make this changes only four or even pages. 59 00:06:42,690 --> 00:06:46,220 If you want to do that, check this option, OK? 60 00:06:48,580 --> 00:06:52,840 There's about Hedera, let's see this changes on the Brent. 61 00:06:55,810 --> 00:07:00,640 Here is here is our Heather Serguei. 62 00:07:01,630 --> 00:07:13,480 If you want to add Heather for Heather, you want to custom Heather and that the filing in the left 63 00:07:13,480 --> 00:07:21,730 section and you want to add that in the center section and you want to add, 64 00:07:25,090 --> 00:07:28,520 for example, time in the right section, OK? 65 00:07:29,440 --> 00:07:34,930 Also, if you want to custom further and add page number. 66 00:07:39,120 --> 00:07:43,460 And number of pages here in the center section in the future. 67 00:07:43,510 --> 00:07:46,380 OK, let's see this changes. 68 00:07:49,390 --> 00:08:01,630 Smarter Turkcell, our date, our time and number of Beijng and the number of pages, and we want to 69 00:08:01,630 --> 00:08:07,000 adjust this filter here, so stop. 70 00:08:08,830 --> 00:08:14,080 Futer customized puter, and we want a page of. 71 00:08:16,520 --> 00:08:22,150 This is number of beach and this is the total number of pages, so, OK. 72 00:08:23,180 --> 00:08:27,320 OK, here is six of 19. 73 00:08:29,650 --> 00:08:37,450 Seven of ninety eight of 19 Antawn and each page has. 74 00:08:39,110 --> 00:08:48,290 The title of the sheet and date and time, OK, this about Whitter or Futer, also, if you want to 75 00:08:48,290 --> 00:08:57,650 add for the future, you want to customize water and add in the left section, for example, you want 76 00:08:57,650 --> 00:08:59,930 to add that. 77 00:09:00,200 --> 00:09:02,330 And for example, you want to add here 78 00:09:06,890 --> 00:09:10,370 file bath in the right section. 79 00:09:14,060 --> 00:09:17,070 OK, let's see this changes, OK? 80 00:09:17,390 --> 00:09:20,720 OK, and here is that in the. 81 00:09:21,650 --> 00:09:29,180 And number of pages and birth of this sheet, OK, and all pages like that. 82 00:09:30,590 --> 00:09:31,100 Great. 83 00:09:37,970 --> 00:09:50,660 Let's print this worksheet, what it consists of, header table, this table and two pages. 84 00:09:52,220 --> 00:09:55,070 Let's bring this sheet control by. 85 00:09:57,950 --> 00:10:01,280 And select active sheet. 86 00:10:03,980 --> 00:10:12,560 And go to page up and higer let's customize here and remove. 87 00:10:14,660 --> 00:10:24,800 This page and remove all the header here, OK, OK, we remove the header and this sheet and here is 88 00:10:24,800 --> 00:10:25,730 our sheet. 89 00:10:27,700 --> 00:10:29,270 Printed by this way? 90 00:10:30,580 --> 00:10:38,560 Well, it's a good it's you can print this sheet in just one paper. 91 00:10:41,480 --> 00:10:52,500 What if I want to print the only table in one paper and want to print this to picture in just one paper? 92 00:10:52,940 --> 00:10:54,200 How can you do that? 93 00:10:55,460 --> 00:10:57,920 Well, let's use. 94 00:10:59,440 --> 00:11:00,820 Page, break, preview. 95 00:11:07,650 --> 00:11:10,920 What if I want to print? 96 00:11:11,800 --> 00:11:21,970 To this limit and don't and and I don't want to bring these two pictures, so let's use page break prevue. 97 00:11:23,120 --> 00:11:34,940 And shift this line to this limit here, so accordingly, after you press controlled by, you will see 98 00:11:35,510 --> 00:11:43,250 that the picture doesn't appear because you hide them from printing using page break prevue. 99 00:11:43,410 --> 00:11:53,240 OK, well, I think we can use a Bajou rendition landscape will be more appropriate than. 100 00:11:56,760 --> 00:12:06,820 Portrait, so I will use landscape orientation so much better, much better, much better using landscape. 101 00:12:06,840 --> 00:12:09,000 And this is will be our page. 102 00:12:09,660 --> 00:12:13,910 Well, what if I want to print only the table? 103 00:12:14,980 --> 00:12:22,650 OK, let's select only the table and go to control 104 00:12:25,290 --> 00:12:27,630 and select print selection. 105 00:12:28,170 --> 00:12:28,980 This is a table. 106 00:12:30,240 --> 00:12:43,410 What if I want to center this table in the middle of the beach it up and from the select center on page 107 00:12:43,830 --> 00:12:46,380 horizontally and central page vertically. 108 00:12:46,440 --> 00:12:48,960 OK, that's it. 109 00:12:49,800 --> 00:12:57,330 We centered the table to our page and print and press print. 110 00:12:57,390 --> 00:12:57,780 OK. 111 00:13:00,420 --> 00:13:10,160 Let's summarize this lecture we have discussed page set up, we have discussed page filtrate landscape, 112 00:13:10,290 --> 00:13:21,120 we have discussed adjust to and change this person advice to use it to one page and zero tool to respect 113 00:13:21,540 --> 00:13:25,860 page wide and select the Bieber sized letter or efore. 114 00:13:27,060 --> 00:13:38,700 Commonly we use it for and let the machine be minimized to use the much space in your page and also 115 00:13:38,700 --> 00:13:44,790 center your page horizontally and vertically to center the table or the object to the center of the 116 00:13:44,790 --> 00:13:45,180 page. 117 00:13:45,640 --> 00:13:53,040 Also you can use header and water and you can customize header to any section left, center, right 118 00:13:53,250 --> 00:13:54,970 and use that page. 119 00:13:54,990 --> 00:14:06,390 Number two, the number of pages or sheet name or sheet title or you can also add picture time date. 120 00:14:07,200 --> 00:14:08,660 It's up to you. 121 00:14:09,810 --> 00:14:16,620 Also, you can customize for similarly like like customize header. 122 00:14:16,980 --> 00:14:19,890 You can add whatever you want. 123 00:14:21,390 --> 00:14:32,370 Also, you can make the first page different or make odd or even pages different only, and we have 124 00:14:32,860 --> 00:14:44,030 to assemble practice to print this active work book and we can select the page border using page break 125 00:14:44,040 --> 00:14:44,510 preview. 126 00:14:44,970 --> 00:14:55,800 And this is normal page to select a part of page by using page prevue and page break preview. 127 00:14:56,940 --> 00:14:59,090 Please practice this picture. 128 00:14:59,100 --> 00:15:04,530 If you have any question, please contact me and you have Unimin Q&A. 129 00:15:05,200 --> 00:15:05,940 Thank you. 130 00:15:05,940 --> 00:15:07,920 And see you in the next lecture.