Microsoft Excel 2001 for Mac OSX

Printer Friendly Version, note, this document prints on legal size paper.

Excel - Mac How To's

Task	Function
Alignment	Align Left icon Align Right icon Align Center icon Format-Cells-Alignment.
Arrange Windows	Windows-Arrange
AutoCorrect	Tools-AutoCorrect.
AutoSum	AutoSum icon. Press the down arrow and select More Functions to get additional functions.
Bold	Bold icon Format-Cells, Font tab, font style + Bold. -B
Cell Borders	Borders icon
Cell Shading	Format-Cells, Borders, tab. Fill Color icon Format-Cells, then choose Patterns tab
Center Across Columns	Center Across Columns icon Format-Cells, Alignment tab. In the Text Control area, choose Merge Cells
Close Book	-W File-Close
Column Hide	Format-Column-Hide
Column Unhide	Format-Column-Unhide
Column Width	Format-Column-Width
Copy (selection)	Copy icon -C Edit-Copy Cut icon
Cut (selection)	-X Edit-Cut Ascending Sort icon
Data Sort	Descending Sort icon Data-Sort
Delete Columns/Row	Highlight columns/row, then select Edit-Delete Edit-Delete, then choose Entire Column or Entire Row
Delete Cell Contents	Edit-Delete, then choose shift cells left or shift cells up Highlight cell contents and press the Delete key
Delete Sheet	Edit-Delete Sheet
Dictionary	Tools-Dictionary
Edit Cell	Double-click on the cell Select cell, place pointer in formula bar and make edits
Font	Font icon Format-Cells, Font tab, make changes
Format Painter	Format Painter icon.
Freeze Panes	(Used to keep data visible as you scroll through a sheet) Window-Freeze Panes.
Go To	-G Edit-Go To
Headers/Footers	File-Page Setup, Header/Footer tab View-Headers/Footers.
Help	Help icon Help-Microsoft Excel Help
Insert Worksheet	Insert-Worksheet
Insert Column	Insert-Column.
insert Row	Insert-Row
Italics	Italics icon Format-Cells, Font tab, choose Italics from the Font Style menu.
Margins	File-Page Setup, Margins tab
New Book	New icon File-New, then new pages appear.
Number Formatting	Format-Cells, Number tab, choose the desired formatting.
Office Assistant	Help-Turn Assistant on. Help-Turn Assistant off.
Open Book	Open icon -O File-Open
Page Break	Insert-Page Break
Page Orientation	File-Page Setup, Page tab, choose Portrait or Landscape Orientation
Page Setup	File-Page Setup File-Print Preview, Setup tab
Paste	Paste icon -V Edit-Paste
Print book or sheet	Print icon File-Print
Print Preview	File-Print Preview-Print Print Preview icon File-Print Preview
Select Printer (Laser)	File-Print-choose desired printer from drop-down menu
Select Printer (DeskJet)	Click Printer icon by clock
Save Book	Save icon File-Save File-Save As File-Save as Web Page
Sheet Name	Double-click on sheet name and type in a new name.
Spell check	Spelling icon Tools-Spelling
Split Windows	Window-Split
Underline	Underline icon Format-Cells, select the Font tab, and choose Underline from the Font Style menu.
Undo Edits	Undo icon Edit-Undo.

Excel Terminology

Cell	Intersection of a column and a row. Named by the column letter and row number: A1, B5.
Column	Identified by letter. There are 256 columns that run horizontally across.
Formula Bar	A bar near the top of the window that displays the formula or constant value stored in or used for the active cell.
Label Text	Text is any combination of numbers, spaces, and non-numeric characters.
Row	There are 65,536 rows that are sequentially numbered down the left side of the worksheet
Value	Numbers that can be calculated
Workbook	The file on which you work. Each workbook can contain many sheets.
Worksheet	The basic document used in Excel to store & work with data. It consists of cells organized into columns & rows and is always a part of a note book

Formulas and Functions

Formulas and functions start with an = (equal) sign

Mathematical operators:
Addition	+	Subtraction	-
Multiplication	*	Division	/
Examples of functions:
Average	Calculates the average in a list. = AVERAGE(B4:B10)
Count	Counts the number of entries in a list. Entries must be numeric. =Count(B4:B10)
Now	Returns the current date and time. =Now()
Sum	Adds a list of numbers. =SUM(B4:B10)
Today	Returns the current date. =TODAY()
$	Absolute reference a cell: $A$1

Selection Shortcuts

Extend the selection by one cell:	SHIFT-arrow key
Extend the selection to the beginning of the row:	SHIFT-home
Select the entire row:	SHIFT-spacebar
Select the entire worksheet:	-A
Extend the selection down one screen:	SHIFT-Page Down
Extend the selection up one screen:	SHIFT-Page Up
Move to the cell A1(Home position)	-Home

Shortcut Keys

-B	Bold
-C	Copy
-G	Go To
-I	Italics
-N	New workbook
-O	Open workbook
-P	Print
-V	Paste
-W	Close Documents
-X	Cut
-Z	Undo
Home	Moves cursor to beginning of row.
Page Up	Moves up one screen
Page Down	Move down one screen
Tab	Moves one cell to the right
Shift-Tab	Moves one cell to the left
-Page Down	Moves right one sheet
-Page Up	Moves left one sheet
Option-Page Down	Moves right one screen
Option-Page Up	Moves left one screen
Enter	Enters data in current cell and moves down
Edit Mode	Double click cell or single click in formulas tool bar to get into edit mode
Home	In EDIT mode moves cursor to first character in cell
End	In EDIT mode moves cursor to last character in cell

Formatting Palette

Go to View-Formatting Palette to use the majority of formatting options.