T7 [Ms Excel 2010]

MO1

MO2

Describe basic computer hardware, software, input, output, communication and network devices.

To apply the suitable office application to fulfill given task.

MO1

MO2



Objective & Learning Outcomes Outcomes Objective To ensure that each student can develop a basic spreadsheet with manipulation of formulas and functions in MS Office Excel 2010.

Learning Outcomes At the end of the lessons, students will be able able to: • Develop basic spreadsheet • Demonstrate the manipulation of data • Manipulate the formulas and functions • Illustrate charts using the spreadsheet data

MO1

MO2



INTRODUCTION store organize Excel is a spreadsheet program that allows you to … •

analyze information

You will learn your way around the Excel 2010 environment, including the new Backstage view, which replaces the Microsoft Button menu from Excel 2007.

MO1

MO2



Spreadsheet allows you to store, organize, and analyse information

Worksheet 1

Worksheet 2

Worksheet 3

Column is a group of cells that runs from the top of the page to the bottom WORKBOOK Row is a group of cells that runs from the left of the page to the right. right .

Each workbook holds one or more related worksheets (a.k.a spreadsheets). Three worksheets appear by default when you open an Excel workbook.

MO1

MO2



Quick Access Toolbar

Ribbon

Column

Formula Bar Name Box

Row

Worksheets Navigator

Horizontal Scroll Bar

Page View

Zoom Control

MO1

MO2



GETTING STARTED WITH EXCEL CREATING CREATING WORKBOOKS OPENING WORKBOOKS

SAVE SAVE WORKBOOKS W ORKBOOKS

AUTO-RECOVERY A WORKBOOK

To Create a New, Blank Workbook:

Click File tab | Select New | Select Blank workbook | Click Create

MO1

MO2



GETTING STARTED WITH EXCEL To Open An Existing Workbook: CREATING CREATING WORKBOOKS W ORKBOOKS OPENING WORKBOOKS

Click File tab | Select Open | Select desired workbook | Click Open

SAVE SAVE WORKBOOKS W ORKBOOKS


Other alternative, If you have opened the existing workbook recently, it may be easier to follow the below steps: s teps:

MO1

MO2



GETTING STARTED WITH EXCEL CREATING CREATING WORKBOOKS W ORKBOOKS OPENING WORKBOOKS SAVE SAVE WORKBOOKS W ORKBOOKS


It is advisable to save your workbook each time you update its contents. Below are the types of Save commands.

To Save Command: Click File tab | Click Save As

To Save As Command: Click File tab | Click Save As | Type in the name for the Workbook | Click Save

To Save As an Excel 97-2003 Workbook & others: Click File tab | Click Save As | Select Excel 97-2003 Workbook or any others that desired in the Save as type drop-down menu | Select location to save the file | Enter

MO1

MO2



GETTING STARTED WITH EXCEL CREATING CREATING WORKBOOKS W ORKBOOKS OPENING WORKBOOKS

SAVE SAVE WORKBOOKS W ORKBOOKS AUTO-RECOVERY A WORKBOOK

Excel automatically saves workbooks to a temporary folder. folder. If you forget to save your changes, or if Excel crashes, you can recover the autosaved file . To Use Auto Recover :

Open a workbook that was previously closed without saving | Click File tab | Click Info | A yellow caution note appear | Click Restore | Click OK

If you can find your file;

Go to Manage Versions button |

MO1

MO2



WORKSHEET BASIC INSERT NEW WORKSHEET Click Insert Worksheet icon | A new new worksheet will appear. appear.

RENAME WORKSHEETS Right-click the worksheet tab you want to rename | Select Rename | Type the name of your worksheet | Click anywhere outside of the tab.

DELETE WORKSHEETS Select the worksheets you want to delete | Right click on selected worksheets | Select Delete.

COLOUR WORKSHEET TAB Right click on the selected worksheet tab | Click Tab Color Menu | Select

COPY WORKSHEETS Right-click the worksheet tab you want to copy | Select Move or Copy | Check the Create a copy box | Click OK.

MO1

MO2



CELL BASICS INSERT CONTENT SELECT CELL COPY AND PASTE

To insert content using Active Cell: 1. Click in in the cell where you the data to appear 2. Beg Begin typ typing ing.

want

CUT AND PASTE DRAG AND DROP

To insert content using Formula Bar:

HEADER & FOOTER

1. 2. 3.

FREEZE ROWS AND COLUMNS FILL HANDLE FOR AUTO FILL OPTION

Click Click the the cell cell whe where re you you wou would ld like like the the dat data a to appe appear ar Place the cursor in the Formula Bar Type in the data

MO1

MO2



CELL BASICS To Select a Cell: INSERT CONTENT SELECT CELL COPY AND PASTE CUT AND PASTE

1. Clic Click k on a cell cell to to sel selec ectt it. it. 2. The cell appear appear bold and and the column heading and row heading of the cell are highlighted. 3. The cell cell will will stay stay selec selected ted unti untill you you click click on another cell in the worksheet.

DRAG AND DROP HEADER & FOOTER

To Select Multiple Multipl e Cells :

FREEZE ROWS AND COLUMNS

1. Click Click and and drag drag your your mouse mouse unti untill all all of the adjoining cells you want are highlighted.

FILL HANDLE FOR AUTO FILL OPTION

2. Releas Release e your your mous mouse. e. The cells cells will will stay selected until you click on

MO1

MO2



CELL BASICS INSERT CONTENT SELECT CELL COPY AND PASTE CUT AND PASTE DRAG AND DROP HEADER & FOOTER FREEZE ROWS AND COLUMNS FILL HANDLE FOR AUTO FILL OPTION

To Copy and Paste cell content :

1. Sele Select ct the the cel cells ls you you wis wish h to copy. 2. Click the Copy command. The border of the selected cells will change appearance. 3. Sele Select ct the the cel celll or cell cells s wher where e you want to paste the content. 4. Click the Paste command. The copied content will be entered into the highlighted cells.

MO1

MO2




To Cut and Paste cell content:

1. Sele Select ct the the cel cells ls you you wis wish h to cut. Click the Cut command. 2. The The bor borde derr of of the the sel selec ecte ted d cells will change appearance.

3. Sele Select ct the the cel cells ls whe where re you you want to paste the content. Click the Paste command. 4. The The cut cut cont conten entt wil willl be be removed from the original cells and entered into the highlighted cells.

MO1

MO2




To Drag and Drop cells:

1. Selec Selectt the the cells cells that that you you wish wish to move and position your mouse on one of the outside edges of the selected cells. 2. The The mou mouse se chan change ges s fro from m a white cross to a black cross with 4 arrows.

3. Click and drag the cells to the new location. 4. Rele Releas ase e you yourr mou mouse se and and the the

MO1

MO2



CELL BASICS INSERT CONTENT

To create Header and Footer :

1. Click the Header & Footer button on the Insert tab. SELECT CELL

2. This This will ill dis displ play ay the the Header & Footer Design Tools Tab

COPY AND PASTE

3. Click Go to Header or Go to Footer button to switch between the Header and Footer.

CUT AND PASTE DRAG AND DROP

To insert text in Header / Footer area:

1. To inser insertt text, text, enter enter the the text text in the the header or footer . HEADER & FOOTER FREEZE ROWS AND COLUMNS FILL HANDLE FOR AUTO FILL OPTION

2. To enter enter pre-progr pre-programmed ammed data data such as page numbe numbers, rs, date, date, time, file name or sheet name, click the appropriate button. 3. To change change the the location location of of data, data, click the the desired desired cell.

MO1

MO2



CELL BASICS INSERT CONTENT

1. Click the Freeze Panes button on the View tab.

SELECT CELL

2. Either Either select select a section section to be frozen frozen or or click click the defau defaults lts of top row or left column

COPY AND PASTE CUT AND PASTE DRAG AND DROP HEADER & FOOTER FREEZE ROW AND COLUMNS FILL HANDLE FOR AUTO FILL OPTION

3. To unf unfre reez eze, e, cli click ck the the Freeze Panes button; then click Unfreeze

MO1

MO2



CELL BASICS INSERT CONTENT SELECT CELL COPY AND PASTE CUT AND PASTE

1. Sele Select ct the cell cell.. 2. Posit Position ion your your mouse mouse over over the the fill handle so that the white cross becomes a black cross. cross. 3. Click and drag the fill handle until all the cells you want to fill are highlighted.. highlighted

DRAG AND DROP HEADER & FOOTER FREEZE ROWS AND COLUMNS FILL HANDLE FOR AUTO FILL OPTION

4. Rele Release ase the the mouse mouse and your your cell cells s

MO1

MO2



FORMATTING FORMATTING CELL To Add a Border: ADD AND APPLY BORDERS FONT COLOUR AND FILL COLOUR TEXT ALLIGNMENTS

1. Select Select the cells cells you you want want to modi modify fy.. 2. Click the drop-down arrow next to the Borders command on the Home tab. The border drop-down menu appears. 3. Select Select the border border style style you you want want to use. use. To Apply Borders & C Colours olours Using Styles: St yles:

FORMATTING NUMBERS & DATE DATE

1. Click Cell Styles on the Home tab 2. Choo Choose se a sty style le or clic click k New Cell Style

MO1

MO2



FORMATTING FORMATTING CELL Change the Font Colour: ADD AND APPLY BORDERS FONT COLOUR AND FILL COLOUR TEXT ALLIGNMENTS FORMATTING NUMBERS & DATE DATE

1. Sele Select ct the font font.. 2. Click the Drop-down Arrow next to the Font Color command Color command on the Home tab. 3. Select Select any colou colourr you you want want fro from m the the Color Menu. Menu.

Add a Fill Colour: 1. Sele Select ct the cell cell.. 2. Click the Drop-down Arrow next to the Fill Color command Color command on the Home tab. 3. Selec Selectt any any colour colour you you want want from from the Color Menu

MO1

MO2



FORMATTING FORMATTING CELL ADD AND APPLY BORDERS FONT COLOUR AND FILL COLOUR

Horizontal Text Alignment: 1. Select Select the cells cells you want want to modify modify.. 2. Sele Select ct one one of of the the thr three ee horizontal Alignment commands on the Home tab.

TEXT ALLIGNMENTS FORMATTING NUMBERS & DATE DATE

Vertical Text Alignment:

1. Select Select the the cells cells you you want want to modif modify y. 2. Sele Select ct one one of of the the thre three e vertical Alignment commands on the Home tab.

MO1

MO2



FORMATTING FORMATTING CELL ADD AND APPLY BORDERS FONT COLOUR AND FILL COLOUR TEXT ALLIGNMENTS FORMATTING NUMBERS & DATE

To format numbers and date: 1.

Select the ce cells.

2.

Click the drop-down arrow next to the Number Format command on the Home tab.

3.

Sele elect the num numb ber for form mat.

MO1

MO2



FORMATTING THE WORKSHEET INSERT & DELETE CELLS & SHEETS COLUMN WIDTH ROW HEIGHT MERGING TEXT

To INSERT Cells, Rows, R ows, and Columns: 1. Place Place the the curs cursor or in in the row row belo below w wher where e you want the new row to appear, or in the column to the left of where you want the new column to appear. 2. Click Home tab | Choose Insert button | Click the appropriate choice: Cell, Row, or Column

WRAPPING CELLS

To DELETE Cells, Rows, and Columns: HIDE OR UNHIDE ROWS OR COLUMN HIDE / UNHIDE WORKSHEETS

1. Place Place the the curs cursor or in in the the cell, cell, row row,, or column that you want to delete 2. Click Home tab | Choose Insert

MO1

MO2



FORMATTING THE WORKSHEET INSERT & DELETE CELLS & SHEETS COLUMN WIDTH ROW HEIGHT

To Modify Column Width: 1. Posit Positio ion n your your mouse mouse over over the the column line so that the white cross becomes a double arrow. arrow. 2. Click and drag the column to the right to increase the column width or to the left to decrease the column width. 3. Rele Releas ase e the the mous mouse. e.

MERGING TEXT WRAPPING CELLS HIDE OR UNHIDE ROWS OR COLUMN HIDE / UNHIDE WORKSHEETS

To Set Column Width with a Specific Measurement: Select the columns you want to modify | Click Home tab | Click the Format command | Select Column Width | Enter a specific measurement in the

MO1

MO2



FORMATTING THE WORKSHEET Modify Row Height : INSERT & DELETE CELLS & SHEETS

1. Position th the cursor over cursor over the row line so that the white cross becomes a double arrow .

COLUMN WIDTH

2. Click and drag the row downward to increase the row height or upward decrease the row height.

ROW HEIGHT

3. Rele Releas ase e the the mous mouse. e.

MERGING TEXT WRAPPING CELLS HIDE OR UNHIDE ROWS OR COLUMN HIDE / UNHIDE WORKSHEETS

To Set Row Height with a Specific Measurement: Select the rows you want to modify | Click Home tab | Click the Format command | Select Row Height | Enter a specific measurement in the Row Height dialog box | Click OK

MO1

MO2



FORMATTING THE WORKSHEET INSERT & DELETE CELLS & SHEETS COLUMN WIDTH ROW HEIGHT MERGING TEXT WRAPPING CELLS HIDE OR UNHIDE ROWS OR COLUMN HIDE / UNHIDE WORKSHEETS

To Merge Text: 1. Selec Selectt the the cel cells ls you you want want to merge together. 2. Select the Merge & Center command on the Home tab. 3. The The sel selec ecte ted d cell cells s wil willl be be merged and centered.

4. To unm unmerg erge e by by re-c re-clic lick k the the Merge & Center command Center command •

Others commands:

MO1

MO2




To Wrap Cells: C ells:

1. Sele Select ct the the cel cells ls with with text text you want to wrap. 2. Select the Wrap Text command on the Home tab.

3. The The tex textt in in the the sele select cted ed cells will be wrapped in your worksheet. 4. To unw unwra rap; p; re-cl re-clic ick k the the Wrap Text command.

MO1

MO2




To Hide/Unhide Rows Row s or Columns:

Select the row or column you wish to hide or unhide | Click Home tab | Click Format button | Click Hide & Unhide

MO1

MO2




To Hide Worksheets:

To Unhide Worksheets:

1. Sele Select ct the the tab tab of the the she sheet et you wish to hide

1. Righ Rightt-cli click ck on any any work worksh shee eett tab

2. Righ Rightt-cl clic ick k on on the the tab tab

2. Click Unhide

3. Click Hide.

3. Choo Choose se the the work worksh shee eett to unhide.

MO1

MO2



CREATING CREATING FORMULAS SIMPLE FORMULAS

To create simple Formulas: 1. Select Select the the cell cell where where the answ answer er will will appea appearr.

CELL REFERENCES POINT AND CLICK METHOD COMPLEX FORMULA RELATIVE REFERENCES ABSOLUTE REFERENCES

2. Type the equal sign (=). For every formulas; must begin with an equal sign (=). 3. Type in the the formu formula la you you want want Excel Excel to calcu calculat late. e.

4. Press Enter . Excel uses standard operators for equations, such as: 

Plus sign (+) for addition



Minus sign (-) for subtraction



Asterisk (*) for multiplication

MO1

MO2



CREATING CREATING FORMULAS SIMPLE FORMULAS CELL REFERENCES POINT AND CLICK METHOD COMPLEX FORMULA RELATIVE REFERENCES ABSOLUTE REFERENCES

To Create a Formula using Cell References: R eferences: 1. Select Select the cell where where the the answ answer er will will appear appear 2. Type the equal sign (=) 3. Type the address address that that contains contains the first first number in the the equation equation [example: B1] 4. Type ype the the opera operato torr you you need need for your formula [example: type the addition sign (+). (+).

5. Type the the cell address address that that contai contains ns the second second numbe numberr in the equation [example: B2] 6. Press Enter .

MO1

MO2




To Create a Formula using the Point Poi nt and Click Method: 1. Select Select the cell where where the the answ answer er will will appear appear 2. Type the equal sign (=). (=). 3. Click Click on on the first first cell cell to to be includ included ed in the form formula ula [example: A3] 4. Type ype the the opera operato torr you you need need for your formula [example: type the multiplication sign (*). (*) . 5. Click Click on on the next cell in the the formu formula la [exam [example: ple: B3] B3] 6. Press Enter .

MO1

MO2




Complex formulas have more than one mathematical operation, such as 5+ 5+5-2.

CELL REFERENCES

Excel calculates formulas based on the following order of operations :

POINT AND CLICK METHOD

   

COMPLEX FORMULA RELATIVE REFERENCES ABSOLUTE REFERENCES

Operations enclosed in parentheses ( ). Exponential calculations (^). Multiplication (*) and division (/), whichever comes first. Addition (+) and subtraction (-), whichever comes first.

The following example demonstrates how to use the order of operations to calculate a formula:

MO1

MO2




Relative references can save you time when you are repeating the same kind of calculation across multiple rows or columns.

CELL REFERENCES

To Create and Copy a Formula Using Relative References:

POINT AND CLICK METHOD COMPLEX FORMULA RELATIVE REFERENCES ABSOLUTE REFERENCES

1. Select Select the the first first cell cell wher where e you want want to enter enter the the formul formula. a.

2. Enter Enter the the formula formula to calcula calculate te the the value value you want want 3. Press Enter . 4. Select Select the the cell cell you you want want to to copy copy and click click on the Copy command. 5. Select Select the the cells cells where where you you want want to paste paste the the formul formula a and click click on on the Paste command. (You may also drag the fill handle to fill cells) 6. Your formula formula is is copied copied to the the selected selected cells as a relati relative ve reference reference (C4=C2+C3, D4=D2+D3, E4=E2+E3, etc.)

MO1

MO2




An absolute reference is designated in the formula by the addition of a dollar sign ($) . To Create and Copy a Formula Using Absolute References:

1. Select Select the the first first cell > Click Click on the cell cell that that contain contains s the first first value you want in the formula > Type Type the first standard operator. 2. Type the dollar sign ($) > Enter the column letter of letter of the cell you are making an absolute reference to. 3. Type the dollar sign ($) > Enter the row number of number of the same cell you are making an absolute reference to. 4. Press Enter Enter > > Select the cell you want to copy & click on the Copy command. 6. Select Select the the cell cells s whe where re you you want want to paste the formula and click on the (You may also a lso drag Paste command. (You the fill handle to fill cells.) 7. Your form formula ula is is copie copied d to the the select selected ed

MO1

MO2



WORKING WITH EXCEL FUNCTIONS EXCEL FUNCTIONS AUTOSUM FUNCTION LIBRARY

Sum

= SUM(range) • Adds all cells in the argument. •

•

Max

FUNCTION COMMAND

Min

Average

•

• •

• •

•

Count Number

•

=SUM(B3:B5)

= MAX(range) Calculates the average of the cells in the argument.

=MAX(C4:J4)

= MIN(range) Finds the minimum value.

=MIN(E4:H4)

= AVERAGE(range) Finds the maximum value.

=MIN(E4:H4)

= COUNT(range) Finds the number of cells that contain a numerical value within a range of the

=COUNT(C4:H9)

MO1

MO2



WORKING WITH EXCEL FUNCTIONS EXCEL FUNCTION AUTOSUM FUNCTION LIBRARY

The AutoSum command allows you to automatically return the results for a range of cells for common functions like SUM and AVERAGE

To calculate a Function using AutoSum:

1. 2. 3. 4. 5. 6.

Click the cell where you want the function applied. Click Home tab Click on the AutoSum drop-down arrow. Select th the function. A formul formula a will will appea appearr in the the select selected ed cell cell Press Enter .

MO1

MO2



WORKING WITH EXCEL FUNCTIONS EXCEL FUNCTION AUTOSUM FUNCTION LIBRARY

AutoSum

:

Easily calculates the sum of a range

Recently Used

:

All recently used functions

Financial

:

Accrued interest, cash flow return rates and additional financial functions

Logical

:

And, If, True, False, etc.

Text

:

Text based functions functi ons

Date & Time

:

Functions calculated on date and time

MO1

MO2



ADDING EXTRA TOUCHES PICTURES & CLIP ART SHAPE

To add pictures in Excel: E xcel: 1. Click the Insert tab. 2. Click the Picture button. 3. Browse Browse to the picture picture from from your your files. files.

SMARTART CHART

4. Click the name of the picture. 5. Click Insert. 6. To move move the graphic, graphic, click it and drag it to where where you want want it. it.

To add clip art in Excel: 1. Click the Insert tab. 2. Click the Clip Art button. 3. Search Search for for the clip art using using the the sear search ch Clip Art dialog box. 4. Click the clip art. art.

MO1

MO2



ADDING EXTRA TOUCHES PICTURES & CLIP ART SHAPE

To edit pictures and clip art in Excel: 1. Click the Format tab. 2. Choose Choose button buttons s according according to to your adjust adjustment ment pref prefere erences nces..

SMARTART CHART

Adjust:

: Controls Controls the picture brightness, contrast, and colours

Picture Style

: Allows you to place a frame or border around around the picture and add effects

Arrange

: Controls the alignment alignment and rotation of the picture

MO1

MO2



ADDING EXTRA TOUCHES PICTURE & CLIP ART SHAPE SMARTART CHART

To add shape in Excel: 1. Click the Insert tab.

2. Click the Shapes button. 3. Clic Click k the the sha shape pe you you cho choos ose. e. 4. Click the Worksheet Worksheet.. 5. Drag Drag the the cur cursor sor to exp expand and the the Shape Shape..

To format shape in Excel: You are able to edit (reshape) by selecting any command in Insert Shapes; or change the style in Shape Style; relocate and arrange the shape or sizing it.

MO1

MO2



ADDING EXTRA TOUCHES PICTURE & CLIP ART

To add SmartArt in Excel: 1. Click the Insert tab and then click the SmartArt button.

SHAPE

2. Select any Smart Art of your choice and click OK

SMARTART

To format SmartArt in Excel:

CHART

1. Select the SmartArt 2. Clic Click k eit either her the the Design or the Format tab 3. Click the SmartArt to add text and pictures .

MO1

MO2




Charts allow audience to see the meaning behind the numbers, and it makes comparisons and trends a lot easier. easier. To Create a Chart: 1. Select th the cells that contain the data you want to use in the chart. 2. Click the Insert tab on the Ribbon. 3. Cli Click the type of Chart of Chart you want to create. To modify a Chart: 1. Select the Design tab. 2. Click the More drop-down arrow in the Chart Styles group to see all of the available styles. 3. Select the desired desired style style and the chart chart will will update to reflect reflect the

MO1

MO2




Once you insert a chart, a set of Chart Tools, Tools, arranged into three tabs, will appear on the Ribbon. These are only visible when the chart is selected. You can use these three tabs to modify your chart: •

Change the Chart Type

•

Switch Row and Column Data

•

Change the Chart Layout

MO1

MO2



ADDING EXTRA TOUCHES PICTURE & CLIP ART SHAPE

To Change the data included in chart: 1. Click the Chart 2. Click the Select Data button on the Design tab

SMARTART CHART

To Change chart title & label: 1. Click the Chart 2 O th Layout tab, click the Chart Title or the Data Labels button

MO1

MO2



SORTING DATA BASIC SORT

To perform Basic Sorting: 1. Highlig Highlight ht the cells cells that that will will be sorte sorted. d.

CUSTOM SORT MULTIPLE SORT DATA FILTER

2. Click the Sort & Filter button Filter button on the Home tab. 3. Click the Sort Ascending (A-Z) button or Sort or Sort Descending (Z-A) button.

MO1

MO2



SORTING DATA BASIC SORT CUSTOM SORT

To perform Custom Sorting: 1. Click the Sort & Filter button Filter button on the Home tab 2. Choose Choose whic which h column column you want want to to sort sort by first first

MULTIPLE SORT

3. Click Add Level

DATA FILTER

4. Choose Choose the next next colum column n you you want want to sort sort and click click OK

MO1

MO2



SORTING DATA BASIC SORT CUSTOM SORT MULTIPLE SORT DATA FILTER

To perform Multiple Sort: 1. From the Data tab, click the Sort command to open the Sort dialog box. 2. Ident Identif ify y the the firs firstt item item you you want to Sort by. by. 3. Click Add Level to add another item. 4. Iden Identi tify fy the the item item you you wan wantt to sort by next. We will sort Last Name from A to Z. 5. Click OK OK..

MO1

MO2



SORTING DATA BASIC SORT

To Filter Data and Clear Filter:

CUSTOM SORT

1. Clic Click k the the colum column( n(s) s) that that conta contain in the data you wish to filter. filter.

MULTIPLE SORT

2. On the Home tab, click on Sort & Filter .

DATA FILTER

3. Click Filter button. Filter button. 4. Click the Arrow at the bottom of the first cell. 5. Click the Text Filter F ilter . 6. Click the Words you wish to Filter.

MO1

MO2



PRINT WORKSHEETS PRINT PANE PRINTING OPTIONS

In previous version, there was a Print Preview option that allowed you to preview and modify the workbook before printing. In new version of Excel (Excel 2010), it combined with the Print window to create the Print pane, which located at the Backstage view.

PAGE PAGE ORIENTA ORIE NTATION TION

To View the Print Pane: PAGE MARGIN PAGE BREAK SCALING OPTIONS

1. Click the File tab. This takes you to Backstage view. view . 2. Select Print Print.. The Print pane appears, with the print settings on the left and the Print Preview on the right.

MO1

MO2



PRINT WORKSHEETS PRINT PANE PRINTING OPTIONS PAGE PAGE ORIENTA ORIE NTATION TION PAGE MARGIN PAGE BREAK SCALING OPTIONS

To Print Active Sheets: 1. Selec Selectt the the works workshee heets ts you you want want to to print print.. To print multiple worksheets, worksheets , Click on the first worksheet >hold down the Ctrl key > Click on the other worksheets you want to select. 2. Click the File tab. 3. Select Print to access the Print pane.. pane 4. Select Print Active Sheets from the print range drop-down menu. 5. Click the Print button. To Print Entire Workbook: 1. Select Print Entire Workbook ;

MO1

MO2



PRINT WORKSHEETS PRINT PANE

Print a Selection/ Set S et the Print Area:

PRINTING OPTIONS

1. Select Select the cells cells that that you want want to to print print.. Click the File tab.

PAGE PAGE ORIENTA ORIE NTATION TION

2. Select Print Print..

PAGE MARGIN

3. Select Print Selection from the print range drop-down menu.

PAGE BREAK

4. You can can see see what what your your select selectio ion n will look like on the page in Print Preview

SCALING OPTIONS

5. Click the Print Button.

MO1

MO2



PRINT WORKSHEETS •

PRINT PANE PRINTING OPTIONS PAGE PAGE ORIENT ORIEN TATION PAGE MARGIN

•

Change the page orientation to Portrait to orient the page vertically Portrait is useful for worksheets needing to fit more rows on one page. While, Landscape to orient the page horizontally. Landscape is useful for worksheets needing to fit more columns on one page.

To change the orientation: 1. Click the File tab.

PAGE BREAK SCALING OPTIONS

2. Select Print to access the Print pane.. pane 3. Select ect either her Portrait Portrait Orientation or Landscape Orientation from the orientation drop-down menu.

4. Then Then the the page page orie orienta ntatio tion n will will

MO1

MO2



PRINT WORKSHEETS PRINT PANE PRINTING OPTIONS PAGE PAGE ORIENT ORIEN TATION PAGE MARGIN

To use Margin options: 1. Click the File tab. Select Print to access the Print pane. pane. 2. Selec Selectt one one of of the the mar margi gin n opti options ons from the margin drop-down menu.

PAGE BREAK

Other commands to Set Page Margin:

SCALING OPTIONS

1. Click the Margins button on the Page Layout tab 2. Selec Selectt one one of of the the giv give e choi choices ces,, or

3. Click Custom Margins

MO1

MO2




To Set Page Break: 1. Click the Page Layout tab.

PRINTING OPTIONS PAGE PAGE ORIENT ORIEN TATION PAGE MARGIN PAGE BREAK SCALING OPTIONS

2. Determ Determine ine the placeme placement nt of the break. break. - Clicking on the row below, below, cell below, below , or column to the right of where you want the break to appear. [Example: select column C and a break will appear after column B] 3. Select the Insert Page Break command from the Breaks drop-down menu.

4. Go to Print Preview to confirm it appears in the correct place on the page; or go to Page Break Preview.

MO1

MO2




To Set Page Break Preview: 1. Select the View tab.

PRINTING OPTIONS PAGE PAGE ORIENT ORIEN TATION PAGE MARGIN

2. Select Page Break Preview. Preview . 3. You wil willl then then see the the pages pages of your worksheet, separated by blue lines. The blue lines represent the page breaks.

PAGE BREAK SCALING OPTIONS

4. Click Click and drag drag the the blue blue line lines s to to where you want the page breaks.

MO1

MO2




To Use scaling options:

PRINTING OPTIONS

1. Click the File tab. Select Print to access the Print pane. pane.

PAGE PAGE ORIENTA ORIE NTATION TION PAGE MARGIN PAGE BREAK SCALING OPTIONS

2. Select one of the scaling options from the scaling dropdown menu.

T7 [Ms Excel 2010]

Recommend Documents