How To Use Scale To Fit in Microsoft Excel Tutorial with Page Break Preview - The Teacher
video description
Date: 2022-03-31
Related videos
Comments and reviews: 5
ahmad
Thanks for the video.
My question is that when we scale the spreadsheet using page break view option it will adjust the print area according to the scaling , but on other hand the font size is reduce in some cases to minimal due to large amount of data in the sheet. Sometimes the font size is to illegible to read. In the case if we increase font size the page margins distorted and we have to set them again so it is like hit & trial thing. For instance, I have a spread sheet containing a large amount of data can easily be printed I mean legible to read after print if I take the print on 3 pages , but if I wish to reduce the pages to two the font size is reduced to fit the content in a printing command automatically which is not legible to read. In that case what can I do to eradicate the problem that data in the sheet when print has been taken is legible to read and fit in the 2 pages printing command?
reply
Thanks for the video.
My question is that when we scale the spreadsheet using page break view option it will adjust the print area according to the scaling , but on other hand the font size is reduce in some cases to minimal due to large amount of data in the sheet. Sometimes the font size is to illegible to read. In the case if we increase font size the page margins distorted and we have to set them again so it is like hit & trial thing. For instance, I have a spread sheet containing a large amount of data can easily be printed I mean legible to read after print if I take the print on 3 pages , but if I wish to reduce the pages to two the font size is reduced to fit the content in a printing command automatically which is not legible to read. In that case what can I do to eradicate the problem that data in the sheet when print has been taken is legible to read and fit in the 2 pages printing command?
reply
fazlul
suppose Heroine 150 g, Fencidil 15 bottles, Home made wine 20 Litres in B1 cell. Heroine 200g, Home made wine 30 Litres, Fencidil 20 bottles in B2 cell. Fencidil 30 bottles, Heroine 300 g and Home made wine 50 Litres in B3 cell in excel. How to sum these text and number in accordance with category in B4 cell in excel ? (Result Heroine 650 g, Fencidil 65 bottles, Home made wine 100 Litres ) But How shall I do the sum with excel formula including text and number ?
reply
suppose Heroine 150 g, Fencidil 15 bottles, Home made wine 20 Litres in B1 cell. Heroine 200g, Home made wine 30 Litres, Fencidil 20 bottles in B2 cell. Fencidil 30 bottles, Heroine 300 g and Home made wine 50 Litres in B3 cell in excel. How to sum these text and number in accordance with category in B4 cell in excel ? (Result Heroine 650 g, Fencidil 65 bottles, Home made wine 100 Litres ) But How shall I do the sum with excel formula including text and number ?
reply
Ian
Follow up question: I've seen a friends spreadsheet where he moved the page break width on one page that impact the page break of the next page (so for example his page 2 was wider than page 1 which he used because the data on page 2 was wider than page 1). Do you know how to do that?
reply
Follow up question: I've seen a friends spreadsheet where he moved the page break width on one page that impact the page break of the next page (so for example his page 2 was wider than page 1 which he used because the data on page 2 was wider than page 1). Do you know how to do that?
reply
Faisal
Whenever I save an excel sheet in page break view then excel open two workbooks one with normal view and one with page break view. When there are 10 or 12 sheets then it becomes very difficult to handle it. Please, can you guide me on this.
reply
Whenever I save an excel sheet in page break view then excel open two workbooks one with normal view and one with page break view. When there are 10 or 12 sheets then it becomes very difficult to handle it. Please, can you guide me on this.
reply
Krishna
excel me data full page adjust nahi hota agaar 4 page hai to kabhi chhota page break hota hai to kabhi full page hota hai . Solution dedo
reply
excel me data full page adjust nahi hota agaar 4 page hai to kabhi chhota page break hota hai to kabhi full page hota hai . Solution dedo
reply
Add a review, comment
Other channel videos
