Microsoft Excel 2013 Cheat Sheet
Microsoft?
Excel 2013 Cheat Sheet
Program Layout
Quick Access Toolbar
Title Bar
Minimize Maximize Close
Tab
Cell Name
Act i v e Cell Rows
Dialog Box Launcher Gro u p
Columns Scroll Bars
Ribbon
Microsof t Off ice Button: Holds the o pti o n s to s t a r t a n ew workbo o k, o pe n a saved f ile, sa v e, prin t, pr e pa re for d is t ribut io n, publish t he sp re a d s h e e t, close the program and show recently viewed documents
Status Bar
Add Worksheet Icon
Work sheet Tabs
Keyboard Shortcuts
Views
Customize the Quick Access Toolbar to hold commands such as Save, Prin t, Undo, Red o, Copy and Paste.
Zoom S lider
Program Shortcuts
Editing Shortcuts
N avi gation Shor tcu t s
Formatting Shortcuts
Ctrl+O Ctrl+N Ctrl+S Ctrl+P Ctrl+W F 7 F 1
Open Create New Save Print Close Spell Check Open Help
Ctrl+X Ctrl+C Ctrl+V Ctrl+Z Ctrl+Y Ctrl+F Ctrl+A
Cut Copy Pas te Undo Re d o Find Select All
Change Cell
Ctrl+B
Tab Go Ri g ht One Cell Ctrl+I
S hif t+Tab Go Lef t One Cell Ctrl+U
En t er Do wn One Cell
S hif t+Enter Up One Cell
Ctrl+Home To Cell A 1
Ctrl+End To Last Data Cell
Bold Italics Underli ne
Program Basics
Create New Workb ook: C li 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
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
Page Setup Group
Illustrations Group
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
Formulas & Functions Formulas Tab
Insert Function Button
Defined Names
Always start with an equals sign.
Function Library Cell Name Box Insert Function Button Formula Bar
To Insert a Formula: Select the cell, press = and enter the formula
Formulas
Formula Auditing Calculation
If multiple operators, Excel will
follow the order of operations.
Math Operators for Formulas: Addition + Multiplication * Subtraction - Division /
Functions
To Insert a Function: Select the cell, click the Insert Function button on the Formula Bar or on the Formulas Tab
Symbols used in Functions: To indicate a range of cells use a colon : Always place parentheses around the cells
Charts
To Create a Chart: Select the cell range that contains the data you want to make into a chart and click the Insert tab on the Ribbon. Click a chart type in the Char ts group and select the chart you want to use from the list.
Use the Chart Tools section of the Ribbon and the Design and Form at tabs to change the look of the char t.
Insert Tab
Bar Chart
Chart Tools Chart Data
Pivot Table Table Illustrations Group Charts Group
Items to Add
Sparklines Filters Links Group Group Group
Header & Footer Button
Header & Footer: Click the Insert tab on the Ribbon and click the Header & Footer button in the Text group Hyperlinks: Select the cell, click hyperlink in the Links group, on the Insert tab Comments: Select the cell, click the Review tab on the Ribbon, click the New
Spreadsheet ViewsNormal View- allows worksheet to take up the entire window Page Layout View- breaks down worksheet page by page Full Screen View- expands spreadsheet to f it
Comment button in the Comments group, type the comment, then
your screen size
click outside the comment text box
View Tab
Workbook Views Show Group Zoom Group Group
Window Group
Macros Group
Formatting 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
Editing Basics
Edit a Cell's Contents:
Select the cell and begin typing Clear a Cell's Contents:
Editing Shortcuts
Ctrl+X
Cut
Ctrl+C
Copy
Select the cell and press Delete Ctrl+V Pas te
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
Font Group
Alignment Buttons
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
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
Your Notes...
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- excel formula cheat sheet pdf
- excel formulas cheat sheet pdf
- excel formula cheat sheet printable
- excel macro cheat sheet pdf
- excel 2016 cheat sheet pdf
- excel 2016 cheat sheet printable
- excel functions cheat sheet pdf
- excel symbols cheat sheet pdf
- excel shortcuts cheat sheet pdf
- excel shortcuts cheat sheet 2020
- excel free cheat sheet printable
- basic excel formulas cheat sheet pdf