Excel Tips and Tricks Cheat Sheet
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
- excel 2010 cheat sheet high plains elementary school
- excel 2016 keyboard shortcuts cheatsheet
- excel formulas and functions for dummies cheat sheet for
- excel tips and tricks cheat sheet
- excel 2010 cheatsheet
- excel quick reference
- excel 2010 cheat sheet
- dragon for excel nuance communications
- microsoft access 2016
- excel 2013 quick reference customguide
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