Download Excel 2013 Cheat Sheet and more Lecture notes Auditing in PDF only on Docsity!
Excel 2013 Cheat Sheet
Ed i ti n g Sho r t cu t s
Ctrl+X Cut
Ctrl+C Copy
Ctrl+V Pas te
Ctrl+Z Undo
Ctrl+Y Redo
Ctrl+F Find
Ctrl+A Select All
N avi gati on Shor tcu t s
Change Cell
Tab Go Right One Cell
Shif t+Tab Go Left One Cell
En t er Down One Cell
S h if t+Enter Up One Cell
Ctrl+Home To Cell A 1
Ctrl+End To Last Data Cell
Prog ram Shortcuts
Ctrl+O Open
Ctrl+N Create New
Ctrl+S Save
Ctrl+P Print
Ctrl+W Close
F 7 Spell Check
F 1 Open Help
Formatting Shor tcu ts
Ctrl+B Bold
Ctrl+I I talics
Ctrl+U Underline
Microsoft
®
Keyboard Shortcuts
Keys to Remember:
Backspace: erases back one space
Delete: erases forward one space
Page Up: moves up one sheet
Page Down: moves down one sheet
F5: Open Go To Dialog Box
Home: moves to the f irst cell in a row
Num Lock: controls the 10-key pad
Create New Workb o o k:
C l i ck File Tab, select New, click Create
Open a Workbook:
Click File Tab, select open, choose workbook
Save a Workbook:
Click File Tab, select Save
Save Workbook with a New Name:
Click File Tab, select Save As, type in the title
Print Preview:
Click File Tab, click Print, Print Preview appears
Print Workbook:
Click File Tab, click Print, click Print button
Program Basics
Program Layout
Colum n s
Microsof t Off ice B utton:
Holds the o ptio n s to st art
a new workbo ok, open a
saved f ile, save, prin t,
pr e pa re for dis tribution,
publish the sp read s heet,
close the progra m an d
sho w recent ly viewed
documents
Customize the Quick Access
Toolbar to hold comm and s such
as Save, Print, Undo, Redo,
Copy and Paste.
Ribbon
Work sheet Tabs
Cell
Name
Act i v e Cell
Rows
Maximize
Quick Access Toolbar
Title Bar Minimize^
Close
Zoom S lider Views
Status
Bar
Scroll Bars
Group
Tab
Dialog Box Launcher
Add Worksheet Icon
Workbook Tips
Add Worksheet:
Click Add Worksheet icon next to sheet tabs at the bottom of
the program screen
Delete Worksheet:
Select the worksheet, click the delete button in the Cells group
on the Home tab and select Delete Sheet
Rename Worksheet:
Double-click sheet tab, type in new name and
press enter
Add Illustrations to Worksheet:
Click on the Insert tab and look in the
Illustrations group
Adjust Margins, Orientation, Size and Breaks:
Click the Page Layout tab on the Ribbon and use
the Page Setup group
Page Setup Group
I l l u s t r a t i o n s G r o u p
Formulas & Functions
Always start with an
equals sign.
Formulas Tab
Function Library
Formula Auditing
Calculation
D e f i n e d N a m e s
Formula Bar Cell Name Box
Formulas
To Insert a Formula:
Select the cell, press = and enter the
formula
Math Operators for Formulas:
Addition + Multiplication *
Subtraction - Division /
If multiple operators,
Excel will
follow the order of
operations.
To Insert a Function:
Select the cell, click the Insert
Function button on the Formula Bar or
on the Formulas Tab
Insert Function Button
Insert Function Button
Symbols used in Functions:
To indicate a range of cells use a colon :
Always place parentheses around the cells
Functions
Formatting Basics
Adjust Row Height:
Drag the bottom border of the row header
Add Cell Borders:
Select the cell, click the Border button list arrow
in the Font group on the Home tab and select a
border type
Add Cell Shading:
Select the cell, click the Fill Color button list arrow
in the Font group on the Home tab and select a color
Ed i ti n g Sho r t cu t s
Ctrl+X Cut
Ctrl+C Copy
Ctrl+V Pas te
Insert a Row or Column:
Right-click the row or column heading to the
right of the column or below the row you want to insert, select
Insert from the menu
Delete a Row or Column:
Select the row or column heading, right-click and choose
Delete from the menu
Edit a Cell’s Contents:
Select the cell and begin typing
Clear a Cell’s Contents:
Select the cell and press Delete
Drag and Drop to Move Cells:
Select the cells, point the mouse over any
border of the cells, then drag to the destination
Drag and Drop to Copy Cells:
Select the cells you want, point to any border
of the cells and press the Ctrl key while dragging
Editing Basics
Format Text:
Use the Font group on the Home tab
Format Values:
Use the Number group on the Home tab
Change Cell Alignment:
Select cell and click the alignment button in
the Alignment group on the Home tab
Adjust Column Width:
Drag the right border of the column header
Your Notes...
Font Group
Alignment Buttons
