MS Excel page layout tab – In this series of learning MS Excel, we had informed you about the MS Excel insert tab in the previous blog, so today we will give information about the tab next to Insert i.e. MS Excel page layout tab.
With the help of MS Excel Page Layout Tab, you can make the page of your document attractive, with the help of this you can change the theme of your document or you can setup the page of the document, Access the MS EXCEL PAGE LAYOUT TAB You can use Alt + P shortcut to do this.
What is MS EXCEL PAGE LAYOUT TAB?
MS Excel page layout tab – Page Layout tab is the third tab of MS Excel, in this tab we get the option to do the settings of the page of our document, inside it we get the option of theme, from which we can make our document attractive,
Along with this, you can setup your page by using features like margin, orientation, apart from this you will also be able to see other options like height, width of the page in this tab, with the help of which you can do the settings of the page of your document. Are.
MS EXCEL PAGE LAYOUT TAB SECTIONS
In MS Excel Page Layout Tab, we get to see 5 sections -:
- Page Setup
- Scale to Fit
- Sheet Options
If you have used MS Word, then you will know that, we also get to see some of these options in the MS Word Page Layout tab, so let us now know these options in detail -:
MS Excel page layout tab – The first section we get to see in MS Excel is the theme, in this section we get to see 4 options, with the help of which we can change the theme of our document and also change the color, font etc. of our selected theme. can.
Themes– In this option, we get to see many themes, with the help of which we can change the design of our document, we can change the color, font and effects of the entire document.
Colors– If you applied a theme and you did not like its color, then you can change the color of that theme only with the help of this option.
Fonts– With the help of this option, you can change the default font of any theme, in this we get to see many fonts.
Effects– With the help of this option, you can change the effect of your theme, in this you get to see many effects.
MS Excel page layout tab – Next option is available in the Excel Page Layout tab, Page Setup, in this we get to see 7 options, with the help of which you can change the settings of the page of your document, as with the help of this option you can change the margin of your page. can you,
You can change the orientation, apart from this, you can change the page size of the document, background, etc., with the help of these options in the section.
MS Excel page layout tab – With the help of this option, you can change the margin of your entire document or any section, if you do not know what is the meaning of margin in MSExcel then when you print your document
So when the data is printed on your page, it is not printed from the left end of the page, first there is a little space and then the data is printed and likewise there is a little space on the right end, it is called margin.
MS Excel page layout tab – In this you get to see 2 options Portrait and Landscape, initially we get Portrait Mode selected, in this the length of the page is more than the width of the page and in landscape mode the width of the page is more than the length of the page.
In this, we get to see different sizes of the page, when you select these sizes, you will not see any difference, but when you print your document, then this option will be useful to you, because you have to take care of the size while printing the page. it happens.
If you want that you want to print only a particular part of your document, then with the help of this option, you can select that part and print that part.
With the help of this option, you can break the page of your document from anywhere, so that your data is printed on different pages while printing.
By clicking on this option, you can select any image from your computer and that image will appear in the background of your document and your data will appear on top of that image.
If you have entered any data in the document and now there is a row or a column or a header in that data that you want it to be printed on every page in your document.
So with the help of this option, you can do this, if you want to see its result after applying it, then you can see it in the print preview.
Scale to Fit
Next to the page setup, we get to see the scale to fit section, in this we get to see 3 options, with the help of these options, we can set the height and width of our document i.e. length and width and if you want it Can also be set to automatic.
If you want to print any data but its width is so large that some part of your data is coming on a separate page and you do not want this, then with the help of this option you can decide how much your data pages, this option reduces the width of the data.
The work of this option is also similar to width, but this option comes in handy when the length of your data is more, then this option prints that long data in as many pages as you want.
You can use this option only when your height and width option is on automatic, this option also works like width and height option but in this we get value in percentage, which we can adjust according to our own. .
Next to this we get to see a section named Sheet Options, in this we get to see 2 options, Gridlines and Headings, to understand them, you read below and use these options in Excel, you can see them very easily. You’ll understand
In MS Excel, we get to see lines in rows and columns, from which we can understand cells, that lines are called Gridlines, in this option we get to see 2 options, a view and a print,
Which we can turn on or off, by turning on or off the View option, we can decide whether we want to see these Gridlines in our document or not, while with the Print option we decide which Gridlines are, Whether to print them on the page or not.
In MS Excel, we get to see the number of rows on the left side and the column letters that are seen above the document, they are called headings here, in this option also we get to see 2 options, view and print,
With the help of the View option, we can decide whether we want to see those headings in the document or not, whereas with the print we decide whether we want to print those headings on the page or not.
You get the options of this section on when we have added some objects in our document, objects means any image, shape or clip art or anything else, which we can do with the help of Insert Tab of MS Excel,
In this section, we get to see 6 options, with the help of these options, we can change the position of these objects, as if one of your objects is on top of another object and you want to lower it.
Or if you want to do the opposite, then you can do so with the help of the options in this section, apart from this we also get to see more options in it, such as group, with the help of which we can combine 2 or more objects into one. can be used as an object,
Read below to know more about them.
Bring to Front
If you have added 2-3 objects to your document and they are all one on top of the other and now you want the object which is at the bottom to come on top then you can use this option,
In this, we get 2 options, first Bring to Front, by clicking on it, whatever object you have selected, it will win the rest of the objects above all of them and the second option is Bring Forward so that your object is one. Will come on tax.
Send to Back
So with the help of Bring Front, we used to bring the objects up, while with the help of Send to Back, we can take the objects back, in this also we get 2 options,
The first is Send to Back, clicking on which your selected object will move below all the other objects and the second option is Send Backward, in which the object goes one by one.
On clicking this option, we get to see a bar in the right side, in which we get to see all our objects, from where we can show or hide them and also change their order.
With the help of this option, you can select many objects and align them according to each other, you can bring an object in the middle of another object or you can also do it on the side, apart from this we also need more Options are found in this.
If you do not know how to select more than one object, then we tell you, for that first you click on one object and then by pressing Ctrl or Shift with the keyboard, click on the other object, both those objects should be selected. You can select more objects in the same way.
With the help of this option, you can select more than one object and create a group of them, so that you can move or edit those objects as one object.
With the help of this option, you can rotate or flip your selected object, you get to see the options related to this in this option, you can flip your object vertically or horizontally with the help of this.
Conclusion (MS Excel Page Layout Tab)
So in today’s article, we gave you information about the MS Excel page layout tab, we tried our best to give you the best information in the simplest language possible,
If you liked this effort of ours, then you must share this article, if you have any question or you have found any deficiency in this article, then you can talk to us by writing in the comments below, we will definitely reply to your comment. .
FAQs (MS Excel Page Layout Tab)
What is a page layout program?
A page layout program is one in which you get the option to change the design of the page of your document, with the help of these options, you can make the page of your document beautiful, so that your entire document looks attractive.
What options are included in page layout?
In MS Excel page layout, we get to see sections like themes, page setup, scale to fit, sheet options and arrange, in which we get to see many different types of options, such as themes, effects, orientation We get to see many other options in this.