Microsoft excel 2002 l.jpg
1 / 37

Microsoft Excel 2002.


101 views
Uploaded on:
Category: General / Misc
Description
Microsoft Excel 2002 Tutorial 3 – Developing a Professional Looking Worksheet Open the Format Cells dialog box Formatting is the process of changing the appearance of your workbook.
Transcripts
Slide 1

Microsoft Excel 2002 Tutorial 3 – Developing a Professional Looking Worksheet New Perspectives on Microsoft Excel 2002 Tutorial 3

Slide 2

Open the Format Cells dialog box Formatting is the procedure of changing the presence of your exercise manual. A legitimately organized exercise manual can be less demanding to peruse, seem more expert, and help attract regard for vital focuses. The arranging toolbar is the speediest approach to organize your worksheet. With catches on this toolbar, you can apply a comma configuration, modify the quantity of decimal spots in a number, apply Currency and Percent arrangements and even rapidly duplicate organizations. In the event that you select a cell or reach, snap Format on the menu bar and after that snap Cells, the Format Cells dialog box opens. New Perspectives on Microsoft Excel 2002 Tutorial 3

Slide 3

The Format Cells dialog box The Format Cells dialog box has six tabs, each committed to an alternate arrangement of organization properties. The Font tab will be utilized to design the textual style, size and style of content in your worksheets. New Perspectives on Microsoft Excel 2002 Tutorial 3

Slide 4

Format information utilizing distinctive text styles, sizes and textual style styles A textual style is the outline connected to letters, characters and accentuation marks. Every text style is distinguished by a textual style name or sort face. Text styles can be shown in different sizes and you can even change the textual style's shade or the foundation shading in the cell. These choices are accessible in the Format Cells dialog box and there are additionally catches accessible for the arranging toolbar to make designing quicker. New Perspectives on Microsoft Excel 2002 Tutorial 3

Slide 5

Examples of different configurations Excel, as a matter of course, will organize every one of your entrances utilizing a style called the General organization. This figure demonstrates illustrations of a few things designed with the General organization. You can likewise see the Percent Style and Currency Style connected to different cells. New Perspectives on Microsoft Excel 2002 Tutorial 3

Slide 6

Copy existing configurations to different cells One approach to duplicate an organization is to utilize the Format Painter catch. To utilize the Format Painter: Select a cell, then tap the Format Painter catch, which has a photo of a paintbrush on it Select the cell or reach you wish to design and the operation is finished Another approach to duplicate an arrangement is to drag the fill handle and snap the Auto Fill Options catch, then tap the Fill Formatting Only alternative. Another approach to organization cells is through the Format Cells dialog box. New Perspectives on Microsoft Excel 2002 Tutorial 3

Slide 7

Align cell substance When you enter numbers and equations into a phone, Excel naturally adjusts them to the cell's correct edge and base outskirt, while content passages are adjusted to one side edge and base fringe. You can control the arrangement of information inside of a phone evenly and vertically. Left, Right and Center arrangements can be chosen utilizing their particular arrangement catches on the Formatting toolbar. To adjust the phone's substance vertically, open the Format Cells dialog box and pick the vertical arrangement alternatives on the Alignment tab. New Perspectives on Microsoft Excel 2002 Tutorial 3

Slide 8

Align utilizing Merge and Center Another choice accessible for arrangement in the Format Cells dialog box and on the Format toolbar is the Merge and Center alternative, which focuses content in one cell over a scope of cells. On the off chance that you need to fit a considerable measure of content inside of a cell yet without needing to grow the segment width to be substantial, you can utilize the content wrapping choice on the Alignment tab, or even decide to indent content. You can likewise have Excel shrink the content to fit inside of the given section width you have picked or even turn content from - 90 to +90 degrees. New Perspectives on Microsoft Excel 2002 Tutorial 3

Slide 9

The Alignment tab of the Format Cells dialog box The Alignment tab gives numerous alternatives to adjusting information. Click the check boxes to choose these choices. Pivot content by moving the bolt with the mouse, or determine the quantity of degrees in the content box. New Perspectives on Microsoft Excel 2002 Tutorial 3

Slide 10

Examples of content designing This segment header demonstrates a sample of content wrapping. The content in segment An is indented. New Perspectives on Microsoft Excel 2002 Tutorial 3

Slide 11

Add cell outskirts and foundations Excel gives a scope of instruments to arrange the substance of a cell, as well as the cells themselves. The gridlines you see in Excel in another worksheet are not showed on printed pages. You can add an outskirt to a cell utilizing either the Borders catch on the Formatting toolbar or the alternatives on the Border tab in the Format Cells dialog box. New Perspectives on Microsoft Excel 2002 Tutorial 3

Slide 12

The Borders catch versus the Border tab When you tap the rundown bolt for the Borders catch, a Borders palette seems demonstrating regular decisions and a Draw Borders catch at the Border's base palette display. The Borders catch permits you to make outskirts rapidly, while the Format Cells dialog box permits you to refine your decisions further. The Border Tab in the Format Cells dialog box is particularly valuable for controlling how a piece of cells or an extent shows up with fringes. You have the choice to change the furthest top, base and sides of the reach freely, and additionally focus diverse outskirts for the lines isolating the cells inside the range's lattice. New Perspectives on Microsoft Excel 2002 Tutorial 3

Slide 13

Add examples or hues to cells Patterns and hues can be utilized to improve the presence of spreadsheet cells. The speediest approach to apply foundation clicking so as to shade to cells in the worksheet is the rundown bolt of the Fill shading catch and picking a shading from the palette. To apply a fill example to cells, utilize the Patterns tab on the Format Cells dialog box. New Perspectives on Microsoft Excel 2002 Tutorial 3

Slide 14

The Border tab of the Format Cells dialog box The Border tab of the Format Cells dialog box gives you finish control over the outskirt you need to make for a cell, scope of cells, or the whole worksheet. Click a catch to kill on or turn the fringe for the showed territory. New Perspectives on Microsoft Excel 2002 Tutorial 3

Slide 15

The Patterns tab of the Format Cells dialog box Using the Patterns tab of the Format Cells dialog box, not just would you be able to change the foundation shade of the worksheet, additionally you can choose from a palette of examples, as appeared in the figure to one side. The shading palette on the Patterns tab is the same one that is additionally accessible from the rundown bolt of the Fill Color catch. New Perspectives on Microsoft Excel 2002 Tutorial 3

Slide 16

A worksheet with organizing connected This figure demonstrates how you may utilize outskirts, foundation hues and examples to enhance the presence of a worksheet. Certain foundation examples can overpower the content in a few cells so you can enhance the appearance by changing the design's shade itself to a lighter shading in the event that you are utilizing standard dark content. New Perspectives on Microsoft Excel 2002 Tutorial 3

Slide 17

Merge a scope of cells To consolidation a scope of cells into a solitary cell: Use the Merge alternative on the Alignment tab in the Format Cells dialog box Click the Merge and Center catch on the Formatting toolbar To part a combined cell once more into individual cells: Select the blended cell Click the Merge and Center catch again Or uncheck the Merge Cells check enclose on the Alignment tab the Format Cells dialog box New Perspectives on Microsoft Excel 2002 Tutorial 3

Slide 18

Hide lines and/or sections You can conceal lines or segments, which does not influence the information put away there, nor does it influence any cell that may have an equation reference to a cell inside of the shrouded line or segment. To shroud a line or segment: Select the line or segment and afterward pick Hide from either the Row or Column alternative of the Format menu, or, from the easy route menu that appears when you right tap the line or segment going to unhide a line or section: Select the lines' headings or segments that fringe the concealed zone, then pick Unhide from either the Row or Column choice of the Format menu, or, from the alternate route menu that appears when you right tap the line or segment heading New Perspectives on Microsoft Excel 2002 Tutorial 3

Slide 19

Merge headings over numerous phones This figure demonstrates an example worksheet with a flagrant title in the first line blended and focused over the segments utilized for information. The Merge and Center catch is the quickest approach to combine a few cells into one or to part one blended cell once again into a few cells New Perspectives on Microsoft Excel 2002 Tutorial 3

Slide 20

Worksheet with concealed cells This figure demonstrates the same worksheet that was appeared in the past slide, yet it has now had a few cells covered up. Concealing unessential cells can much of the time enhance the general appearance of the worksheet. New Perspectives on Microsoft Excel 2002 Tutorial 3

Slide 21

Format the worksheet foundation and sheet tabs You can utilize a picture record as a foundation for a worksheet. Pictures can be utilized to give the foundation a textured appearance, similar to that of stone, wood, or fibered paper. The foundation picture does not influence the configuration or substance of any cell in the worksheet, and on the off chance that you have effectively characterized a foundation shading for a cell, Excel shows the shading on top, concealing that partition of the picture. You can't have any significant bearing a foundation picture to every one of the exercise manual's sheets in the meantime. New Perspectives on Microsoft Excel 2002 Tutorial 3

Slide 22

Insert a foundation picture and change a worksheet tab shading To add a foundation picture to a worksheet: Click Format on the menu bar, point to Sheet and snap Background Locate and select a picture from your hard commute, floppy commute, organize, and so forth., and click the Insert catch You can likewise arrange the foundation shade of the worksheet tabs, yet this shading is just vis