DEVELOPING A PROFESSIONAL LOOKING WORKSHEET

1. DEVELOPING A PROFESSIONAL LOOKING WORKSHEET By Dr. Ennis - Cole

2. OBJECTIVES • Format data using the Number, Currency, Accounting, and Percentage • Align cell contents • Center text across columns • Change fonts, font style and font size • Clear formatting from cells

3. OBJECTIVES • Delete cells • Use borders and colors • Add text box and graphics using the drawing toolbar • Remove gridlines • Print in landscape orientation • Hide and unhide rows and columns

4. Starting Excel and Organizing the Desktop • Start Excel • Make sure data is in the drive • Maximize the Microsoft Excel Window • Click Open • Click File, Save As to save the workbook under another name

5. Formatting the Worksheet Data • Excel applies an automatic format known as the General Format • Numbers are right aligned, while text is left aligned • A minus sign is used for negative values • Numbers are displayed without trailing zeros to the right of the decimal point • AutoFormat changes formats

6. Formatting Numbers • Select the cells • Click Format, Cells, Numbers tab in the Format Cells dialog box • Select a format category from the Category list box • Select the desired options • Click OK

7. Currency and Accounting Formats • To Format columns with the currency format: • Select the cell range • Click Format, Cells • Click the Numbers tab • Click Currency • Click the third option in the negative numbers list box • Click OK to format the selected range

8. The Accounting Format • Select the range • Click Format, Cells • Click the Number tab • Click Accounting • Click the Decimal Places • Click OK • Click any cell to deselect the range

9. The Format Painter Button • Click any cell you want to copy • Click the Format Painter Button • Position your cursor, click, and drag • Notice the cell range contains ######

10. Percentage Format • Select the cell range • Click the Percent Style button • Click any cell to deselect the range and view the percent style • Refer to figure 3-12

11. Align and Wrap Text in a Cell • Select the cell range • Click the center button to center the content • Click Format, Cells • Click Alignment tab • Click Wrap text • Click OK • Refer to Figures 3-14 & 3-15

12. Indenting Text Within a Cell • Click any cell active • Click Increase Indent button • Click Save to save the worksheet

13. Changing the Font, Font Style and Font Size • Select the cells • Click Format, Cells, Font tab • Select a typeface • Select a font style • Select a type size • Click the Bold button for a boldface • Click OK

14. Creating a Style by Example • Select any cell • Click Format • Click Style to display the Style dialog box • Select Style name text box • Type a new name for the style • Click the OK button

15. Clearing Formats from cells • Select the cells, rows, or columns • Click Edit • Point to Clear • Click Formats

16. Deleting Cells From a Worksheet • Select the cells, rows, or columns • Click Edit, Delete • Select the direction you want the remaining cells to move • Select Shift cells left to move cells to left • Select entire row or column to delete • Click OK

17. Adding a Border • Select the cell • Click Format, Cells, and the Border tab • Click the line style you want • Click the appropriate button for the border Click OK

18. Applying Patterns and Color • Select the cells • Click Format, Cells and the Patterns tab • Select a pattern from the list • Select a color from the pattern palette • Select a colored background from the Cell shading color palette • Refer to figures 3-26 & 3-27

19. Activating and Removing Toolbars • To activate a toolbar, click the right mouse button • View the Toolbar Shortcut menu • Click the name of the toolbar • To remove a toolbar, click any toolbar with the right mouse • Click the name of the toolbar to remove

20. Adding a Text Box • Click the Text box button on the Drawing toolbar • Position the pointer where you want the text box to appear • Click and drag to outline the size and shape of the text box • Type the text for the text box • Click outside the text box

21. Adding an Arrow • Click the Arrow button • Move the mouse pointer and the pointer changes to + • Position + on the top edge of a cell • Make sure the line is straight • Release the mouse button • Click any cell to deselect the arrow

22. Removing the Drawing Toolbar • Click the Drawing button • Press Ctrl + Home to make the cell active • Click the save button • To remove display of gridlines • Click Tools, Options and the View tab • Click Gridlines checkbox to remove the check and deselect • Click OK

23. Hiding and Unhiding Rows and Columns • To hide rows and columns • Select the rows and columns • Click Format, Print Column and Click Hide • To unhide rows and columns • Select the rows and columns • Click Format, Print Column and Click Unhide • Save and close the workbook and exit Excel.

24. That’s All Folks !