Excel 2010 Page Layout Tab Lesson-5

Excel 2010 Page Layout Tab Lesson-5

Page Layout:- The Page Layout Tab holds all the options that allow you to arrange your document pages just the way you want them. You can set margins, apply themes, control of page orientation and size, add sections and line breaks, display line numbers, and set paragraph indentation and lines.

Themes - From the Page Layout tab, click the Theme Colors command. A drop-down menu will appear. ... Hover your mouse over the different sets of theme colors to see a live preview.Select the set of theme colors you want, or select Create New Theme Colors to customize each color individually.

Colors-From the Page Layout tab, click the Theme Colors command. A drop-down menu will appear.Hover your mouse over the different sets of theme colors to see a live preview.Select the set of theme colors you want, or select Create New Theme Colors to customize each color individually.

Fonts - From the Page Layout tab, click the Theme Fonts command. A drop-down menu will appear.Hover your mouse over the different sets of theme fonts to see a live preview.Select the set of theme fonts you want, or select Create New Theme Fonts to customize each font individually.

Effects -From the Page Layout tab, click the Theme Effects command. A drop-down menu will appear. Hover your mouse over the different sets of theme effects to see a live preview.Select the set of theme effects you want.

Margins - used to alter the tools from which we can change the properties of a page. The first tool is margins , used to alter the size of the margins for all of the margins for all of the in your document. A margin is the invisible space at the sides and top and bottom of your document that you cannot type into . Altering these margins allows you to have more less text on the page. Next tool is used to change the orientation of a page 

Orientation - Page orientation is the direction in which a document is displayed or printed. The two basic types of page orientation are portrait (vertical) and landscape (horizontal). Most monitors have a landscape display, while most documents are printed in portrait mode.

Size - Drop-Down. Lets you select from all the different available paper sizes. The More Paper Sizes displays the "Page Setup" dialog box, Page tab.

Print Area - A print area is a range of cells to be included in the final printout. In case you don't want to print the entire spreadsheet, set a print area that includes only your selection. When you press Ctrl + P or click the Print button on a sheet that has a defined print area, only that area will be printed.

Breaks - This drop-down contains the commands: Insert Page Break, Remove Page Break and Reset All Page Breaks.

Background - Displays the "Sheet Background" dialog box to let you add a background image to the back of a worksheet. This caption changes to 'Delete Background' if an image is assigned to the active worksheet.

Print Titles - Displays the "Page Setup" dialog box, Sheet tab. This allows you to enter rows or columns to repeat.

Width - The combo box contains Automatic, 1 to 9 pages and More Pages. The More Pages displays the "Page Setup" dialog box, Page tab. Provides a shortcut to (Page Setup)(Page tab, Scaling).

Height - The combo box contains Automatic, 1 to 9 pages and More Pages. The More Pages displays the "Page Setup" dialog box, Page tab. Provides a shortcut to (Page Setup)(Page tab, Scaling).

Scale - Changes the page scale in increments of 5%. Provides a shortcut to the (Page Setup)(Page tab, Scaling).

Gridlines View - Toggles the display of gridlines on the active worksheet. Provides a shortcut to (Page Setup)

Gridlines Print - Toggles whether the gridlines are printed. Provides a shortcut to (Excel Options)

Headings View - Toggles the displays of row and column headers on the active worksheet. Provides a shortcut to (Excel Options)(Advanced tab, "Show row and column headers").

Headings Print - Toggles whether the row and column headers are printed. Provides a shortcut to (Page Setup)

Bring to Front:- Bring an object to the front of the stack: On the Home tab in the Arrange group, click the arrow next to or under Bring Forward, and then click Bring to Front.

Bring Forward - The button brings the selected object forward one level. The drop-down contains the commands: Bring to Front and Bring Forward. Bring to Front will bring the selected object in front of all the other objects.

Send to Back:-Send an object to the back of the stack: On the Home tab in the Arrange group, click the arrow next to or under Send Backward, and then click Send to Back.

Send Backward - Button with Drop-Down. The button brings the selected object back one level. The drop-down contains the commands: Send to Back and Send Backward. Send to Back will send the selected object to the back of all the other objects.

Selection Pane - Drop-Down. Displays the Selection Task Pane.

Align - Drop-Down. This drop-down contains the commands: Align Left, Align Center, Align Right, Align Top, Align Middle, Align Bottom, Distribute Horizontally, Distribute Vertically, Snap to Grid, Snap to Shape, View Gridlines.

Align Left:-Left align, left alignment, or left justify is text, pictures, tables, graphics, or page formatting that aligns text along the left side (margin) of a document, page, or containing element. This text has a ragged right edge because it is left-aligned instead of being right aligned.

Align Center:-To align your data horizontally, Microsoft Excel provides these options: Align Left - aligns the contents along the left edge of the cell. Center - puts the contents in the middle of the cell. Align Right - aligns the contents along the right edge of the cell.

Align Right:- Align Right – It aligns the text to the right edge of the cell.

Top Align - aligns the contents to the top of the cell.

Middle Align - centers the contents between the top and bottom of the cell.

Bottom Align - aligns the contents to the bottom of the cell 

Distribute Horizontally:- To arrange the objects horizontally, click Distribute Horizontally. To arrange the objects vertically, click Distribute Vertically

Distribute Vertically:- To arrange the objects vertically, click Distribute Vertically.

Snap to Grid:-To position shapes or objects to the closest intersection of the grid, click Snap to Grid. To position shapes or objects to grid lines that go through the vertical and horizontal edges of other shapes or objects, click Snap to Shape.

Snap to Shape:-The Snap to Shape feature allows us to quickly align a shape with other shapes on a worksheet. When we move a shape by dragging it with the mouse, it will snap into alignment with other shapes on the worksheet. Snap to Shape is a mode that can be toggled on or off

View Gridlines:-Can view gridlines show & hide

Group - To group several objects, select all objects you want to group by pressing Ctrl or Shift and clicking every of these objects: 

Regroup:- A super handy trick after you’ve grouped and then ungrouped your objects is that you can easily regroup them. The best part is that you don’t have to click each one.Simply select one of the objects that was in the group and go to the Layout tab once more. Click “Group” and select “Regroup.”

Ungroup:- To ungroup pictures, go to Picture Format or Picture Tools Format > Group  > Ungroup.

Rotate - Rotate or flip the selected object. Drop-Down. This drop-down contains the commands: Rotate Right 90, Rotate Left 90, Flip Vertical, Flip Horizontal and More Rotation Options