Format & Arrange:
Summary

Title: Jan's Illustrated Computer Literacy 101
Did you want Working with Numbers: 2007,2010,2013,2016  or españolIcon: Change web



In Excel Project 3, you learned how to format cells and text and how to move, insert, and copy data.

Cells can be formatted by adding background color, changing text formats, aligning cell contents both horizontally and vertically, wrapping text, and merging cells.

Data can be moved, inserted, and copied with several methods. When inserting, the existing data can be moved only to the right or down.

Linking cells by typing the references or with Paste Link keeps copies of data updated with the latest information.

Every aspect of a chart can be changed after it is created.

Printing choices include the entire workbook, the active sheet(s), a selection, specific page(s). Showing formulas instead of values can help you see where things went wrong.


Additional Information:

     Error Values Table

     Compare Formatting Available in Word & Excel Table


Where you are:
JegsWorks > Lessons > Numbers

Before you start...

Project 1: Excel IntroTo subtopics

Project 2: Excel BasicsTo subtopics    

Project 3: Format & Arrange
    Format CellsTo subtopics
    Format ChartTo subtopics
    ArrangeTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics

Project 4: Groups & FormulasTo subtopics

Project 5: DesignTo subtopics


Search 
Glossary
  
Appendix


What You Printed for Excel Project 3:

 

File and sheet

What is it?

# of pages

1.

trips11.xls

AutoFormat. Print selection.

1 page

2.

trips12.xls

Removed all formats.

1 page

3.

trips14.xls - Sheet1

Print formulas. Landscape orientation

1 page

4. trips15.xls - Pie Chart

Number of people pie chart

1 page
5. trips16.xls - Tickets Sold Chart Columns chart with cloud background 1 page
6. trips17.xls - Sheet 1 After moving columns & cells 1 page

7.

trips20.xls

Print Entire Workbook.

6 pages


Important Terms