Excel Tips and Tricks Cheat Sheet - SASFAA
Excel Tips and Tricks Cheat Sheet
Keystroke Shortcuts
Ctrl + s
Ctrl + c
Ctrl + v
Ctrl + n
Ctrl + p
Ctrl + b
Ctrl + i
Ctrl + u
Ctrl + z
Ctrl + y
Ctrl + x
Ctrl + mouse scroll
Ctrl + arrow
Shift + arrow
Ctrl + shift + arrow
F11
F12
Saves your workbook
Copies highlighted cells
Pastes copied contents into new cells
Creates a new workbook
Opens the print option
Turns text bold
Makes text italic
Underlines text
Undo
Redo
Cut
Zooms in and out
Jumps from the currently active cell to the last entry in the column or row
Highlights one cell at a time in the direction of the arrow
Selects an entire row or column (stopping at blank cells)
Creates a chart out of highlighted data
Opens the Save As option
Customize the Quick Access
Toolbar
To customize the tools on the status bar:
1. Right click on it
2. Take one of two actions:
a. Select a checked item to
remove it
b. Select an unchecked item to
add it
1
Tips for Shared Workbooks
Under the Review Tab there are several useful options:
?
?
?
?
Protect Sheet prevents other
users from making changes to the
sheet
Protect Workbook prevents other
users from making changes to the
workbook
Share Workbook allows changes
to be made by multiple users in
one workbook at the same time
Track changes will highlight the
changes made to the workbook
Printing Tips
Preview your print page by selecting:
1. File (the home button)
2. Print
Here you can change the margins and page orientation. You can also use
the scaling option to (see image, right):
1. Fit sheet to one page
2. Fit all columns to one page
3. Fit all rows to one page.
Printing Titles
Go to Page Layout (see image, below)
1. Select Print Titles
a. Choose how many rows at the top to include in titles
b. Choose how many columns on the left to include in titles
2
Excel Element Names
Letter
A
B
C
D
E
F
G
H
I
Name
Workbook
Worksheet or Sheet
Column
Row
Name Box
Function Box
Formula Bar
Marquee
Dialogue Box Launchers
Description
A file containing multiple worksheets
An individual spreadsheet with rows, columns, and/or charts
A vertical space where data can be entered
A horizontal space where data can be entered
Displays the name of the currently active cell
Displays available functions
Displays the contents of the currently active cell
Marks the currently active cell
Launches the associated dialogue box
3
................
................
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 download
- alt codes reference sheet useful shortcuts
- exceljet excel shortcuts pdf bu
- the most useful windows keyboard shortcuts tips tricks
- microsoft excel keyboard keys
- microsoft excel cheat sheet customguide
- keyboard shortcuts windows
- advanced excel keyboard shortcuts excel keystrokes action
- keyboard shortcuts for french characters
- shortcuts guide
- excel 2016 keyboard shortcuts cheatsheet
Related searches
- excel formula cheat sheet pdf
- tips and tricks for life
- excel formulas cheat sheet pdf
- excel cheat sheet 2016 pdf
- free excel cheat sheet download
- onenote tips and tricks 2019
- excel formula cheat sheet printable
- excel macro cheat sheet pdf
- vba excel cheat sheet pdf
- excel tips and tricks cheat sheet
- onenote tips and tricks pdf
- tips and tricks for cleaning