Working with Sheets

Opening a Recent Document

Anatomy of a Sheet

Back to: Tutor for Mac OS X Numbers ’09 > Working with Sheets

Tutor for Mac OS X Numbers ’09

Previous
Next

Collapse

Expand

Tutor for Numbers '09
Tutor for Numbers '09 - Introduction
What is a Spreadsheet?
Terminology
Numbers '09 Interface
Interface Overview
The Numbers Window Up Close
Inspector Window
Creating Spreadsheets
Creating a Spreadsheet
Using the Template Chooser
Importing from Excel
Importing from a CSV File
Opening a Recent Document
Working with Sheets
Working with Sheets
Anatomy of a Sheet
Adding, Deleting, and Organizing Sheets
Working with Tables
Working with Tables
Anatomy of Table
Types of Tables
Moving, Resizing, and Deleting Tables
Resizing Rows and Columns
Working with Headers and Footers
Adding, Deleting, and Hiding Rows and Columns
Arrange, Sort, and Filter Rows and Columns
Categorizing your Data
Styling Tables
Working with Cells
Working with Cells
Anatomy of a Cell
Autofilling Cells
Formatting and Adding Borders to Cells
Custom Formatting
Checkboxes, Sliders, Steppers and Pop-ups
Using Conditional Formatting
Moving, Merging, and Splitting Cells
Working with Formulas
Working with Formulas
Using Instant Calculations
Adding Formulas to Tables
Adding Functions to Formulas
Adding Decision Making with If-Then
Working with Charts
Working with Charts
Creating a Chart
Moving, Resizing, and Renaming Charts
Formatting Charts and The Chart Inspector
Working with Text
Working with Text
Adding and Formatting Text
Spell Checking
Substituting Text
Images, Shapes, and Objects
Working with Images, Shapes and Objects
Adding and Formatting Images
Masking and Using Instant Alpha
Adding and Modifying Shapes
Creating Custom Shapes
Adding Hyperlinks, Audio, and Movies
Arranging and Grouping Objects
Saving and Sharing Documents
Saving and Sharing Options
Printing Options
Exporting to Excel, CSV, and PDF Files
Sharing via Email
Adding Comments
Sharing Data with Pages and Keynote
Adding Security
Advanced Options
Advanced Options
Importing from your Address Book
Customizing the Toolbar

Latest News

Tutor for Apple Watch with watchOS 5 Now AvailableMay 28, 2019 - 12:21 pm
Flick Keys on the iPad to access Numbers and SymbolsApril 15, 2019 - 10:50 am
LESSON PREVIEW: Which watchOS am I using?April 8, 2019 - 9:15 am
Apple Didn’t Solve Our Horrible Gadget-Charging Mess and Nobody Else Has, EitherApril 4, 2019 - 1:00 pm
Tutor for using AutoFill with Forms and Passwords is now availableMarch 18, 2019 - 3:38 pm

Like this page? Please share with friends/family.

App Store Availability

Select Tutorials are also available in the App Stores

Account Info

Log In
My Account
Contact Us

App Store Availability

Select Tutorials are also available in the App Stores

Terms of Use and Privacy Policy

Terms of Use
Privacy Policy

© 2019 Noteboom Productions, Ltd. All Rights Reserved. Noteboom Productions, Ltd, and Noteboom Tutorials are independent websites and have not been authorized, sponsored, or otherwise approved by Apple Inc.

Opening a Recent Document Anatomy of a Sheet

Scroll to top

Wait...

I have a new home for my tutorials!

Check out my new home for my tutorials - Dan's Tutorials. Why a new home? I started redesigning the site and one thing lead to another. What's new? Faster. Better organized. New plans. Reminders before renewals. Subscriptions can be paused. And more!

Check out Dan's Tutorials.