11- Enhancing worksheets

(Open Exercise file) Back To Excel Index Page Back To Edmond Home Page

111- Adding themes to your worksheet Play Video

View and Apply a Theme:

1) Click the Page Layout tab. 

2)  Click the Themes button to display the themes gallery. 

3)  The current theme appears highlighted in the gallery.

4) Point to a theme and a live preview appears in the worksheet, along with a ScreenTip. 
           Click the theme you want to apply to the active worksheet.

1) Check the result

Create a theme by customizing theme colors, theme fonts, and theme effects

1) Click the Page Layout tab. 

2) Click the Themes button. 

3) Then click Save Current Theme.

4) Type a name for the theme file. Click Save.

Choose and Apply a Custom Theme:

1) Click the Page Layout tab. 

2) Click the Themes button to see additional themes.

3) Point to gallery to display the theme name. 
           Then click the one you want.

Select and Apply a Custom Theme From a File:

1) Click the Page Layout tab. 
           Click the Themes button and then click Browse for Themes.

2) Click the theme file you want. Click Open.

Apply or Create Theme Colors:

1) Click the Page Layout tab. 
To apply theme colors, click the Theme Colors button, 
and then click a color theme.

2) To create theme colors, 
           click the Theme Colors button, 
           and then click Create New Theme Colors.

3) Click the Theme Colors buttons: Text/Background, Accent, or Hyperlink, ... to change colors.

4) Click a new color to select a color from the Standard or Custom tab, and then click OK.

5) Click the Reset button to return all color changes to their original colors.

6) Type a new name for the color theme. 
           Click Save.

Edit a custom color theme:

1) Click the Page Layout tab. 
Click the Theme Colors button. 
Right-click the theme color. Click Edit

2) Make changes. 
Then click Save.

Delete a custom color theme:

1) Click the Page Layout tab. 
Click the Theme Colors button. 
Right-click the theme color. Click Delete.

2) Then click Yes.

Select a Windows related color scheme:

1) Click the Office button, 
and then click Excel Options.

2) In the left pane, click Popular. 
Click Color Scheme. Click OK.

Apply and Choose Theme Fonts:

1) Select the cell or a range. 
Click the Home tab. Click the Font list and then click the theme font. 
The current theme fonts appear highlighted in the menu.

2) Point to the Fonts button and click the theme fonts.

3) Check the result

Create Theme Fonts:

1) Click the Page Layout tab. 
Click the Theme Fonts button. 
Then click Create New Theme Fonts.

2) Click the Heading font list arrow and then select a font. 
Click the Body font list arrow and then select a font.

3) Type a name for the custom theme fonts. 
Click Save.

View and Apply Theme Effects:

1) Click the Page Layout tab. 

2) Click the Theme Effects button. 

3) The current theme effects appear highlighted in the menu.

4) Click the theme effects.

Delete a custom theme effects or fonts:

1) Click the Page Layout tab. 

2) Click the Theme Effects or Theme Fonts button.

3)  Right-click the theme.

4)  Click Delete.

5) Click Yes to confirm.

·

112- Page setup options Play Video

1) Click the Page Layout tab. 
Click the Margins button. 
The current margin setting is highlighted on the submenu.

2) Click the option: Last Custom Setting, Normal, Wide, Narrow.

1-

113- Scale to fit Play Video

Select scaling options in Page Layout view:

1) Click the worksheet that you want to work on in Page Layout view.

2) On the View tab, in the Workbook Views group, click Page Layout View.

3) You can also click Page Layout View on the status bar.

4) On the Page Layout tab, in the Scale to Fit group, do one of the following:

Ø To shrink the width of the printed worksheet to fit a maximum number of pages, select the number of pages that you want in the Width list.

Ø To shrink the height of the printed worksheet to fit a maximum number of pages, select the number of pages that you want in the Height list.

Ø To stretch or shrink the printed worksheet to a percentage of its actual size, select the percentage that you want in the Scale box.

5) To scale a printed worksheet to a percentage of its actual size, the maximum width and height must be set to Automatic.

Return to Normal view

· On the View tab, in the Workbook Views group, click Normal.

114- Worksheet options Play Video

Insert a new worksheet

To insert a new worksheet, do one of the following:

1) To quickly insert a new worksheet at the end of the existing worksheets, click the Insert Worksheet tab at the bottom of the screen.

2) To insert a new worksheet before an existing worksheet, select that worksheet, and then on the Home tab, in the Cells group, click Insert, and then click Insert Sheet.

3) You can also right-click the tab of an existing worksheet, and then click Insert. On the General tab, click Worksheet, and then click OK.

Insert multiple worksheets at once:

1. Hold down SHIFT, and then select the same number of existing sheet tabs of the worksheets that you want to insert in the open workbook.

For example, if you want to add three new worksheets, select three sheet tabs of existing worksheets.

2. On the Home tab, in the Cells group, click Insert, and then click Insert Sheet.

· You can also right-click the selected sheet tabs, and then click Insert. On the General tab, click Worksheet, and then click OK.

Rename a worksheet:

1. On the Sheet tab bar, right-click the sheet tab that you want to rename, and then click Rename.

2. Select the current name, and then type the new name.

Ø You can include the name of the sheet when you print the worksheet.

Delete a worksheet:

Ø On the Home tab, in the Cells group, click the arrow next to Delete, and then click Delete Sheet.

Ø You can also right-click the sheet tab of the worksheet that you want to delete, and then click Delete

115- Inserting images Play Video

Adding a Picture:
To add a picture:

1) Click the Insert tab

2) Click the Picture button

3) Browse to the picture from your files

4) Click the name of the picture

5) Click Insert

6) To move the graphic, click it and drag it to where you want it

Adding Clip Art:
To add Clip Art:

1) Click the Insert tab

2) Click the Clip Art button

3) Search for the clip art using the search Clip Art dialog box

4) Click the clip art

5) To move the graphic, click it and drag it to where you want it

Editing Pictures and Clip Art:
When you add a graphic to the worksheet, an additional tab appears on the Ribbon.  The Format tab allows you to format the pictures and graphics.  This tab has four groups:

Adjust:  Controls the picture brightness, contrast, and colors
Picture Style:  Allows you to place a frame or border around the picture and add effects
Arrange:  Controls the alignment and rotation of the picture
Size:  Cropping and size of graphic

Adding Shapes:
To add Shape:

1) Click the Insert tab

2) Click the Shapes button

3) Click the shape you choose

4) Click the Worksheet

5) Drag the cursor to expand the Shape

6) To format the shapes:

7) Click the Shape

8) Click the Format tab

Adding SmartArt:
SmartArt is a feature in Office 2007 that allows you to choose from a variety of graphics, including flow charts, lists, cycles, and processes.  To add SmartArt:

1) Click the Insert tab

2) Click the SmartArt button

3) Click the SmartArt you choose

4) Select the Smart Art

5) Drag it to the desired location in the worksheet

6) To format the SmartArt:

7) Select the SmartArt

8) Click either the Design or the Format tab

9) Click the SmartArt to add text and pictures.

Back To Top Back To Excel Index Page (Open Exercise file)

Back To Edmond Home Page

Copyright © Edmond Hakmeh 2009. All Rights Reserved