CUSTOMIZING VIEW OPTIONS/ Customizing the Excel Window Display Customizing the Comments View Options Customizing the Objects View Options Customizing the Worksheet View Options

♦Customizing the Excel Window Display

1- From the main menu, choose Tools  →  Options to display the Options dialog box. 
2- Click on the View tab, and select any of the following options from the Show area:Formula bar: Select to show the Formula bar.

Printing Headers and Footers Setting Page Breaks Setting Paper Size and Orientation Showing and Hiding Gridlines Print Preview

The first thing you need to do before printing is to fix or modify the page setup of your worksheet(s). PageSetup controls such things as margins, headers and footers, paper size, orientation, …Headers and Footers To automatically repeat text such as a page number, worksheet title, or date, you can add headers or footers to your printed worksheet.

Grouping and Ungrouping Layering Rotating and Flipping Objects

Grouping objects is useful when you need to make the same change to a group of objects, such as resizing or moving. 

 ● To group objects:

1- Make sure the Select Object icon is highlighted on Drawing toolbar.

2- While holding the Shift key down, click on all the objects you want to group.

3- Click on the down arrow next to  Draw iconon Drawing toolbar.

Using AutoShapes Clip Arts and Pictures Cropping or Trimming Pictures Wrapping Text Around a Picture

AutoShapes are pre-drawn shapes that offer an easy alternative to drawing your own shapes. AutoShapes come in several shape categories including Lines, Connectors, Basic Shapes, Block Arrows, Flowcharts, Stars and Banners, and Callouts.

 AutoShapes can be inserted into your sheet through the AutoShapes menu on the Drawing toolbar, or through the AutoShapes toolbar.

Changing Fill Line Color Line Style Dash Style Arrow Style Shadow Style And Adding 3-D Style Resizing Objects Moving Objects Excel

♣Changing Fill Color

► To change fill color:

1- Select the object you want to fill. 

2- Click the down arrow next to the Fill Color icon  on the Drawing toolbar, the fill color dialog box appears:

Graphics Excel / Drawing Objects Line Arrow Rectangle Oval Text Box Adding WordArt Text

In this section, you will learn how to draw objects (Line, Arrow, Rectangle, Oval, Text Box…), add WordArt, change the objects attributes, use the Auto shapes and add Clip Art and Pictures.

♣Drawing Objects To draw or add an object you must display the Drawing toolbar. To display the drawing toolbar:

From main menu, click →view  →  Toolbars  Drawing, the drawing toolbar will appear at the bottom of MS Excel screen

Formatting Charts,Plot,Axis, Legend, Gridlines,Data Series Area

 When you are satisfied with your chart, you can customize the chart by formatting the following:

1-Chart Area                        5- Axis                   

2- Chart Title                       6- Legend 

3- Plot Area                         7- Gridlines

4- Axis                                8- Data Series