5. Worksheet Tools Lecture-1.pptx - Formatting Workbooks Themes Selecting a different theme affects the workbook font and color scheme Open the Room

5. Worksheet Tools Lecture-1.pptx - Formatting Workbooks...

This preview shows page 1 - 12 out of 45 pages.

Formatting Workbooks – Themes Selecting a different theme affects the workbook font and color scheme Open the “Room Inventory Theme Exercise” file Slide 1 of 22
Image of page 1
Format Painter The format painter is used to copy formatting from one place and applies it to another. 1. Select the shape, text, picture, or worksheet with the formatting to be copied 2. Click Home, and in the Clipboard group, click Format Painter. 3. After the pointer changes to a paintbrush, click and drag to select the shape, text, or worksheet cell that needs formatting, then release the mouse button. To copy a format to an entire worksheet, use the the “select all” button at the top left corner of the spreadsheet Slide 2 of 22
Image of page 2
Formatting Multiple Worksheets at a Time 1.Select the tabs by left clicking on each one while holding the control key 2.All tabs become active 3.Anything written or formatted the first spreadsheet will be copied to the other ones 4.To ungroup the spreadsheet, click on one tab Caution: Make sure to ungroup the spreadsheet if you want to modify one of them without affecting the others. Slide 3 of 22
Image of page 3
5. Worksheet Tools HM 271 4
Image of page 4
Last lecture How to print a selection How to format cells, rows and columns How to format tabs How to reproduce formatting from one selection to another 5
Image of page 5
This week’s objectives Make use of copy/paste tools Compare absolute vs. relative cell references and utilize them in exercises How to freeze panes How to group/ungroup columns/rows 6
Image of page 6
Inserting rows and columns 7
Image of page 7
Inserting Rows & Columns Columns and can be inserted anywhere in Excel. Excel moves the existing columns to the right and rows one line below to make room for the new one. The Insert command is located in the Cells group ( Home tab). It is also accessible via the Mini Toolbar (right clicking)
Image of page 8
Deleting Rows & Columns The procedure is similar to copying Rows and columns, the command used in the Cells group is the Delete command instead.
Image of page 9
Custom Number Formats 10
Image of page 10
Custom Number Formats Although Excel provides many options for displaying numbers (percentages, currency, dates…), they may not meet your needs and you may want to customize number format to create your own.
Image of page 11
Image of page 12

You've reached the end of your free preview.

Want to read all 45 pages?

  • Spring '16

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture