Page Layout (Page Layout Tab Microsoft-Excel)
Page Layout Tab Microsoft-Excel 2007 You can bring a line or border line number on the four sides of the page through the option present in it. Apart from this, write down from the bottom or middle of the page, fix these things. You can set the theme etc.
Through this, you can get the designs made in the document. It is such a set of unified design elements and color schemes. Which helps in producing professional and designed documents. Due to which the document is easy to view on MS Word, e-mail and web.
Fonts: – In this option you can set the font of your page theme.
Effects: – This option you can set the effect of the theme of your page.
Page Setup (Page Layout Tab Microsoft-Excel)
Let’s set the page by this. Through this, you can set orientation in the page and page columns and margins etc.
Margins: – By clicking on the option in it, you can fix the space for Margin and Header and Footer on the four sides of the page.
Orientation: – With this option you can set the orientation of your page. If you want to keep the landscape, click on the landscape, otherwise you can select it by clicking on the portrait.
Size: – From here you can change the size of your page. It has many types of sizes.
Like- (Letter, Letter Small, Tabloid, Ledger, Legal, Statement, Executive, A3, A4, A4 Small).
A4 Size is usually keep but here you have to decide what kind of print out you want to take out. So, you can select that.
Print Area: – With this option you can print by selecting from here how much area of the sheet you want to print. The part to be print. Similarly, you can print the column and row line and column and row heading.
Break: – On clicking this, two options will appear, in which you select the cell from which to insert the brake. Click on Insert Brake and the break will be insert and if you want to remove it, then click on Remove Page break. Will be remove.
Background: – Through this, you can add colors, different designs, wallpaper etc. to the background of your page.
Print Titles: – It prints the file opened by it.
Scale to Fit
With this option, you set the length and width of the page.
Width: – Set which page of the number you want to print from here.
Height: – With this option, how many number of pages you want to print.
Scale: – Let ‘s set the scale of the page from here.
You can hide and show the line of column and row and the heading of column and row from here. Page Layout Tab Microsoft-Excel 2007.
Gridlines: – To hide the gridline which shows inside the sheet with this option, if you tick in the box of view, it will show and removing the tick will remove the gridline.
If you put a tickmark in the print box, then these gridline will be print in the page after removing the print and if you remove the tick mark, the grid line will not show in the print.
Headings: – With this option, columns A, B, C, and Row 1,2,3, which are visible inside the sheet, will show it if they tick in the box of the view to hide it and on removing the tick, Column and Row’s Heading will also be removed.
If you put a tickmark in the print box, then these headings will be printe in the page after removing the print and if you remove the tickmark, the heading will not show in the print. Page Layout Tab Microsoft-Excel 2007.
With this option, you have to arrange the pictures, clip art, shapes, etc. inserted in your page.
#Bring to Front:- Select The object by this option can be brought up.
Bring Forward: – Object select by this option can be move up one by one in sequence.
#Bring in front of text: – The object select by this option can be brought above the text.
#Send tor Beck: – The object selected by this option can bring down.
Send Backward – The object select by this option can be order one by one below.
Send Behind Text – The object select by this option can be text below.
Selection Pane: – By clicking on it, a pan will open in the right side. From where you can hide and show objects.
Align: – The object selected by this option is to keep as per his wish. There are many options in it, you can see all.
Group: – Through this option, several objects can be select and formed into groups.
Regroup – Through this option, ungroup objects etc. can be group twice.
Ungroup – You can separate objects grouped by this option.
Rotate: – You can rotate the object selected by it as per your wish. Page Layout Tab Microsoft-Excel 2007.