Microsoft®

Excel 2013 Basic

Free Cheat Sheets
Quick Reference Guide Visit ref.customguide.com

The Excel 2013 Program Screen Keyboard Shortcuts

General
Quick Access Toolbar Title Bar Formula Bar Close Button
Open a workbook ................ Ctrl + O
Create a new workbook ....... Ctrl + N
File Tab
Save a workbook ................. Ctrl + S
Ribbon Print a workbook ................. Ctrl + P
Close a workbook................ Ctrl + W
Name
Box Help .................................... F1

Active Cell Spell check ......................... F7

Columns Calculate worksheets .......... F9
Create absolute reference ... F4

Scroll Bars
Navigation
Rows
Move between cells ............. , , , →
Right one cell ...................... Tab
Left one cell ........................ Shift + Tab
Down one cell ..................... Enter
Up one cell.......................... Shift + Enter
Down one screen ................ Page Down
Worksheet Tab Views Zoom To first cell of active row ...... Home
Slider Enable End mode ................ End
To cell A1............................ Ctrl + Home
Getting Started To last cell........................... Ctrl + End

Editing
Create a Workbook: Click the File Select an Entire Worksheet: Click the
tab and select New or press Ctrl + Select All button where the Cut ..................................... Ctrl + X
N. Double-click a workbook. column and row headings meet.
Copy................................... Ctrl + C
Open a Workbook: Click the File tab Select Non-Adjacent Cells: Click the Paste .................................. Ctrl + V
and select Open or press Ctrl + O. first cell or cell range, hold down the Undo .................................. Ctrl + Z
Select a recent file or navigate to the Ctrl key, and select any non-adjacent
location where the file is saved. cell or cell range. Redo ................................... Ctrl + Y
Find .................................... Ctrl + F
Preview and Print a Workbook: Click Cell Address: Cells are referenced by
Replace .............................. Ctrl + H
the File tab and select Print. an address made from their column
letter and row number, such as cell Edit active cell ..................... F2
Undo: Click the Undo button on A1, B2, etc. Clear cell contents............... Delete
the Quick Access Toolbar.
Formatting
Redo or Repeat: Click the Redo
button on the Quick Access Toolbar. Bold .................................... Ctrl + B
The button turns to Repeat once Jump to a Cell: Click in the Name
everything has been re-done. Box, type the cell address you want Italics .................................. Ctrl + I
to go to, and press Enter. Underline ............................ Ctrl + U
Use Zoom: Click and drag the zoom Open Format Cells Ctrl + Shift
slider to the left or right. Change Views: Click a View button in
the status bar. Or, click the View tab dialog box ........................... + F
Select a Cell: Click a cell or use the and select a view. Select All............................. Ctrl + A
keyboard arrow keys to select it. Select entire row ................. Shift + Space
Recover an Unsaved Workbook:
Select a Cell Range: Click and drag Restart Excel. If a workbook can be Select entire column ............ Ctrl + Space
to select a range of cells. Or, press recovered, it will appear in the Hide selected rows .............. Ctrl + 9
and hold down the Shift key while Document Recovery pane. Or, click Hide selected columns ........ Ctrl + 0
using the arrow keys to move the the File tab, click Recover unsaved
selection to the last cell of the range. workbooks to open the pane, and
select a workbook from the pane.

© 2022 CustomGuide, Inc.

Click the topic links for free lessons!
Contact Us: [email protected]
Edit a Workbook Basic Formatting Insert Objects

Edit a Cell’s Contents: Select a cell and click in Format Text: Use the commands in the Font Complete a Series Using AutoFill: Select the
the Formula Bar, or double-click the cell. Edit group on the Home tab, or click the dialog box cells that define the pattern, i.e. a series of
the cell’s contents and press Enter. launcher in the Font group to open the dialog months or years. Click and drag the fill handle
box. to adjacent blank cells to complete the series.
Clear a Cell’s Contents: Select the cell(s) and
press the Delete key. Or, click the Clear Format Values: Use the commands in the
button on the Home tab and select Clear Number group on the Home tab, or click the
Contents. dialog box launcher in the Number group to Insert an Image: Click the Insert tab on the
open the Format Cells dialog box. ribbon, click either the Pictures or Online
Cut or Copy Data: Select cell(s) and click the Pictures button in the Illustrations group,
Cut or Copy button on the Home tab. Wrap Text in a Cell: Select the cell(s) that select the image you want to insert, and click
contain text you want to wrap and click the Insert.
Paste Data: Select the cell where you want to Wrap Text button on the Home tab.
paste the data and click the Paste button in Insert a Shape: Click the Insert tab on the
the Clipboard group on the Home tab. Merge Cells: Select the cells you want to ribbon, click the Shapes button in the
merge. Click the Merge & Center button Illustrations group, and select the shape you
Preview an Item Before Pasting: Place the list arrow on the Home tab and select a merge wish to insert.
insertion point where you want to paste, click option.
the Paste button list arrow in the Clipboard Hyperlink Text or Images: Select the text or
group on the Home tab, and hold the mouse Cell Borders and Shading: Select the cell(s) graphic you want to use as a hyperlink. Click
over a paste option to preview. you want to format. Click the Borders the Insert tab, then click the Link button.
button and/or the Fill Color button and Choose a type of hyperlink in the left pane of
Paste Special: Select the destination cell(s), select an option to apply to the selected cell. the Insert Hyperlink dialog box. Fill in the
click the Paste button list arrow in the necessary informational fields in the right
Clipboard group on the Home tab, and select Copy Formatting with the Format Painter: pane, then click OK.
Paste Special. Select an option and click OK. Select the cell(s) with the formatting you want
to copy. Click the Format Painter button in Modify Object Properties and Alternative Text:
Move or Copy Cells Using Drag and Drop: the Clipboard group on the Home tab. Then, Right-click an object. Select Size and
Select the cell(s) you want to move or copy, select the cell(s) you want to apply the copied Properties in the menu, and make the
position the pointer over any border of the formatting to. necessary modifications under the Properties
selected cell(s), then drag to the destination and Alt Text headings.
cells. To copy, hold down the Ctrl key before Adjust Column Width or Row Height: Click and
starting to drag. drag the right border of the column header or View and Manage Worksheets
the bottom border of the row header. Double-
Find and Replace Text: Click the Find & click the border to AutoFit the column or row Insert a New Worksheet: Click the Insert
Select button, select Replace. Type the text according to its contents. Worksheet button next to the sheet tabs
you want to find in the Find what box. Type the below the active sheet. Or, press Shift + F11.
replacement text in the Replace with box. Click Basic Formulas
the Replace All or Replace button. Delete a Worksheet: Right-click the sheet tab
Enter a Formula: Select the cell where you and select Delete from the menu.
Check Spelling: Click the Review tab and click want to insert the formula. Type = and enter
the Spelling button. For each result, select the formula using values, cell references, Rename a Worksheet: Double-click the sheet
a suggestion and click the Change/Change operators, and functions. Press Enter. tab, enter a new name for the worksheet, and
All button. Or, click the Ignore/Ignore All press Enter.
button. Insert a Function: Select the cell where you
want to enter the function and click the Insert Change a Worksheet’s Tab Color: Right-click
Insert a Column or Row: Right-click to the right Function button next to the formula bar. the sheet tab, select Tab Color, and choose
of the column or below the row you want to the color you want to apply.
insert. Select Insert in the menu, or click the Reference a Cell in a Formula: Type the cell
Insert button on the Home tab. reference (for example, B5) in the formula or Move or Copy a Worksheet: Click and drag a
click the cell you want to reference. worksheet tab left or right to move it to a new
Delete a Column or Row: Select the row or location. Hold down the Ctrl key while clicking
column heading(s) you want to remove. Right- SUM Function: Click the cell where you want to and dragging to copy the worksheet.
click and select Delete from the contextual insert the total and click the Sum button in
menu, or click the Delete button in the Cells the Editing group on the Home tab. Enter the Freeze Panes: Activate the cell where you
group on the Home tab. cells you want to total, and press Enter. want to freeze the window, click the View tab
on the ribbon, click the Freeze Panes
Hide Rows or Columns: Select the rows or MIN and MAX Functions: Click the cell where button in the Window group, and select an
columns you want to hide, click the Format you want to place a minimum or maximum option from the list.
button on the Home tab, select Hide & value for a given range. Click the Sum
Unhide, and select Hide Rows or Hide button list arrow on the Home tab and select Select a Print Area: Select the cell range you
Columns. either Min or Max. Enter the cell range you want to print, click the Page Layout tab on
want to reference, and press Enter. the ribbon, click the Print Area button, and
Basic Formatting select Set Print Area.
COUNT Function: Click the cell where you
Change Cell Alignment: Select the cell(s) you want to place a count of the number of cells in Adjust Page Margins, Orientation, Size, and
want to align and click a vertical alignment a range that contain numbers. Click the Sum Breaks: Click the Page Layout tab on the
, , button or a horizontal alignment button list arrow on the Home tab and select ribbon and use the commands in the Page
, , button in the Alignment group on the Count Numbers. Enter the cell range you Setup group, or click the dialog box launcher
Home tab. want to reference, and press Enter. in the Page Setup group to open the Page
Setup dialog box.

Recover Autosaved Versions: Click the File

tab on the ribbon and select Info. Select an
© 2022 CustomGuide, Inc.
Click the topic links for free lessons! autosaved version from the versions list. Or,
Contact
click Us: Versions
the Manage [email protected]
button and select
Recover Unsaved Workbooks.
Get More Free Quick References!
Visit ref.customguide.com to download.

Microsoft Google Software Business Skills

Access Gmail Adobe Captivate Business Writing
Excel Google Chrome Computer Basics Cyber Security
Office 365 Google Classroom macOS Email Etiquette
OneNote Google Docs QuickBooks Manage Meetings
Outlook Google Drive Salesforce Presentations
PowerPoint Google Meet Slack SMART Goals
Teams Google Sheets Storyline Time Management
Windows Google Slides Zoom
Word Google Workspace + more, including Spanish versions

Everything you need to

provide amazing training

View Demo

Interactive Skill Customizable

Online Learning Assessments Courseware

Over 3,000 Organizations Rely on CustomGuide

Request a Free Trial: [email protected] 612.871.5004