Page Layout Data Menu excel

Page Layout Menu:-

Themes:-                             To set the font face style, back ground, color combination etc from this option.

Colors:-                               To Set the color scheme of the sheet.

Font:-                                    To set the font face style of the sheet.

Effects:-                               To set the object or buttons effects from this option.

Margins:-                            To set the top, bottom, left and right blank space in the page called margins.

Page orientation:-           To set the landscape or portrait orientation of the page.

Size:-                                     To set the size of the work sheet page where you want to type the data.

Print Area:-                         To select the print area of your work sheet which you want print on paper.

Breaks:-                               To insert the break for shifting the data in new page.

Line numbers:-                 To Insert line numbers on in front of each typed line.

Back Ground:-                   To set the color of the page you type the data.

Print Title:-                          To set the top row to repeat at each page and left column repeat at each page.

Gird Line:-                           Show all cell lines.

Headings:-                          Show or hide the column headings and row numbers to  each sheet.

 Data Menu:-     

 Refresh all:-                        To refresh all the external links and put new inserted data in the sheet.

Connections:-                    To set all the created connections.

Properties:-                        To set the external links properties.

Edit link:-                             To change the given links addresses.

Sort:-                                     To sort the cell data lowest to largest or reverse.

Filter:-                                   To set filter on the data easy to watch particular data.

Text to Column:-              To set the simple text line in the column data.

Remove Duplicates:-       To remove the duplicate values from selected column area.

Data Validation:-             To Set the validation options on  given area, if you enter wrong data in that area excel alerts you.

Circle Invalid data:-         To set the circle on invalid inserted data in  the given range.(if the validation option applied).

Clear Circle:-                       To remove the given circles from the invalid entered data.

Consolidation:-                                 To consolidate or combine to different columns for watch the difference.

Analysis:-                            To distingious the difference between two data s.

Scenario Manager:-        To create a scenario of the given data.

Goal seek:-                         To set target and set changing cell address and achieve the goal.

Group:-                                                To set data in groups.

Auto outline:-                    To set automatically outline on the groups.

Un group:-                          Clear groups if given.

Clear outlines:-                  Remove the outlines from groups.

Subtotal:-                            To set the sub total of all given data.

Show detail :-                    To show the detail of groups.

Hide Detail:-                       To hide the detail of grouping data.