- Essays Database Online
- Argumentative Essay
- Comparative Essay
- 1200 Word Essay
- IB Extended Essay
- Scholarship Essay
- Discursive Essay
- Research Proposal
- Reaction Paper Writers
- Coursework Writing
- Book Report Writing
- Book Review Writing
- Term Paper Writing
- Write a Case Study
- Case Brief Writing
- Discussion Board Post
- Blog Article Writing
- Article Writing
- Article Review
- Literature Review
- Annotated Bibliography
- Article Critique
- Movie Critique
- Cover Letter Writing
- Motivation Letter Service
- Winning Synopsis
- Marketing Plan
- Business Plan Writing
- Winning White Paper
- Grant Proposal Writing
- Memo Essay Help
- Questions-Answers
- Professional Online Test
- Order Cool Posters Here
- PowerPoint Presentation
- Capstone Project Writing
- Dissertation Writing
- Dissertation Abstract
- Dissertation Literature
- Dissertation Conclusion
- Hypothesis
- Rewriting Services
- Editing Service
- Proofreading Service
- Revise a Paper
- Abstract Help
Keyboard Shortcuts for Microsoft Excel
Essay specific features
Written by:
Paul C
Date added:
February 8, 2017
Level:
University
Grade:
A
No of pages / words:
3 / 694
Was viewed:
7360 times
Rating of current essay:
Essay content:
(period)
Move from corner cell to corner cell in a selected range
Selection techniques
Keystroke
Function
[Shift][Spacebar]
Select a row
[Ctrl][Spacebar]
Select a column
[Ctrl]A
Select an entire worksheet
[Shift][Home]
Select from current cell(s) to the beginning of the row
[Shift][End][Enter]
Select from current cell(s) to last used cell in row
[Ctrl][Shift][Home]
Select from current cell(s) to the beginning of the worksheet
[Ctrl][Shift][End]
Select from current cell(s) to the end of the used portion of a worksheet
[Ctrl] and *
Select the data region surrounding the active cell
[Ctrl][Shift]O
Select all cells that contain a comment
[Ctrl] and [
Select cells that a selected formula directly references
[Ctrl] and ]
Select formulas that directly reference the active cell
Workbook basics
Keystroke
Function
[Ctrl]O
Open a workbook
[Ctrl]N
Create a new workbook
[Ctrl]S
Save a workbook
[F12]
Open the Save As dialog box
[Ctrl]P
Print a workbook
[Ctrl]W
Close a workbook
[Shift][F11]
Insert a new worksheet
[Ctrl]9
Hide selected rows
[Ctrl][Shift]9
Display hidden rows in selection
[Ctrl]0
Hide selected columns
[Ctrl][Shift]0
Display hidden columns in selection
[Ctrl]F
Open the Find tab of the Find And Replace dialog box
[Ctrl]H
Open the Replace tab of the Find And Replace dialog box
[F7]
Run a spelling check on a worksheet or selected text
Working with data
Keystroke
Function
[Enter]
Complete an entry and move to the next cell
[Alt][Enter]
Insert a new line within a cell
[F2]
Enable editing within a cell
[Ctrl][Enter]
Fill selected cells with an entry you type
[Ctrl]D
Fill data down through selected cells
[Ctrl]R
Fill data through selected cells to the right
[Ctrl][F3]
Create a name
[Ctrl]K
Insert a hyperlink
[Ctrl] and ; (semicolon)
Insert the current date
Working with data (continued)
[Ctrl] and : (colon)
Insert the current time
[Ctrl]X
Cut the selected text or objects to the Clipboard
[Ctrl]C
Copy the selected text or objects to the Clipboard
[Ctrl]V
Paste the contents of the Clipboard
[Ctrl]Y
Repeat last action
[Ctrl]Z
Undo last edit
[Ctrl][Delete]
Delete from the insertion point to the end of the line
[Ctrl][Shift]+
Add blank cells
[Ctrl]- (hyphen)
Delete selected cells
[F11]
Create a chart from a range of data
Formula shortcuts
Keystroke
Function
=
Begin a formula
[Ctrl][Shift][Enter]
Enter a formula as an array
[Shift][F3]
Display the Insert Function dialog box (Paste Function in Excel 97)
[F3]
Paste a defined name into a formula
[Alt]=
Insert a SUM AutoSum formula
Type a function in the Formula bar and press [Ctrl]A
Display the Function Arguments dialog box
[Ctrl][Shift] and "
Copy the value from the cell above the current cell into the current cell
[Ctrl] and '
Copy a formula from the cell above the current cell into the current cell
[Ctrl] and `
Toggle between display of formulas and cell values
[F9]
Calculate values for sheets in all open workbooks
[Shift][F9]
Calculate values for the current worksheet
[Esc]
Cancel an entry you're making in a cell or in the formula bar
displayed 300 characters
Custom written essay
All essays are written from scratch by professional writers according to your instructions and delivered to your email on time. Prices start from $10.99/page
Order custom paperFull essays database
You get access to all the essays and can view as many of them as you like for as little as $28.95/month
Buy database accessOrder custom writing paper now!
- Your research paper is written
by certified writers - Your requirements and targets are
always met - You are able to control the progress
of your writing assignment - You get a chance to become an
excellent student!
Get a price guote
(period)
Move from corner cell to corner cell in a selected range
Selection techniques
Keystroke
Function
[Shift][Spacebar]
Select a row
[Ctrl][Spacebar]
Select a column
[Ctrl]A
Select an entire worksheet
[Shift][Home]
Select from current cell(s) to the beginning of the row
[Shift][End][Enter]
Select from current cell(s) to last used cell in row
[Ctrl][Shift][Home]
Select from current cell(s) to the beginning of the worksheet
[Ctrl][Shift][End]
Select from current cell(s) to the end of the used portion of a worksheet
[Ctrl] and *
Select the data region surrounding the active cell
[Ctrl][Shift]O
Select all cells that contain a comment
[Ctrl] and [
Select cells that a selected formula directly references
[Ctrl] and ]
Select formulas that directly reference the active cell
Workbook basics
Keystroke
Function
[Ctrl]O
Open a workbook
[Ctrl]N
Create a new workbook
[Ctrl]S
Save a workbook
[F12]
Open the Save As dialog box
[Ctrl]P
Print a workbook
[Ctrl]W
Close a workbook
[Shift][F11]
Insert a new worksheet
[Ctrl]9
Hide selected rows
[Ctrl][Shift]9
Display hidden rows in selection
[Ctrl]0
Hide selected columns
[Ctrl][Shift]0
Display hidden columns in selection
[Ctrl]F
Open the Find tab of the Find And Replace dialog box
[Ctrl]H
Open the Replace tab of the Find And Replace dialog box
[F7]
Run a spelling check on a worksheet or selected text
Working with data
Keystroke
Function
[Enter]
Complete an entry and move to the next cell
[Alt][Enter]
Insert a new line within a cell
[F2]
Enable editing within a cell
[Ctrl][Enter]
Fill selected cells with an entry you type
[Ctrl]D
Fill data down through selected cells
[Ctrl]R
Fill data through selected cells to the right
[Ctrl][F3]
Create a name
[Ctrl]K
Insert a hyperlink
[Ctrl] and ; (semicolon)
Insert the current date
Working with data (continued)
[Ctrl] and : (colon)
Insert the current time
[Ctrl]X
Cut the selected text or objects to the Clipboard
[Ctrl]C
Copy the selected text or objects to the Clipboard
[Ctrl]V
Paste the contents of the Clipboard
[Ctrl]Y
Repeat last action
[Ctrl]Z
Undo last edit
[Ctrl][Delete]
Delete from the insertion point to the end of the line
[Ctrl][Shift]+
Add blank cells
[Ctrl]- (hyphen)
Delete selected cells
[F11]
Create a chart from a range of data
Formula shortcuts
Keystroke
Function
=
Begin a formula
[Ctrl][Shift][Enter]
Enter a formula as an array
[Shift][F3]
Display the Insert Function dialog box (Paste Function in Excel 97)
[F3]
Paste a defined name into a formula
[Alt]=
Insert a SUM AutoSum formula
Type a function in the Formula bar and press [Ctrl]A
Display the Function Arguments dialog box
[Ctrl][Shift] and "
Copy the value from the cell above the current cell into the current cell
[Ctrl] and '
Copy a formula from the cell above the current cell into the current cell
[Ctrl] and `
Toggle between display of formulas and cell values
[F9]
Calculate values for sheets in all open workbooks
[Shift][F9]
Calculate values for the current worksheet
[Esc]
Cancel an entry you're making in a cell or in the formula bar
displayed 300 characters
General issues of this essay:
Related essays:
-
1 pages, 267 words
-
5 pages, 1274 words
-
3 pages, 694 words
-
5 pages, 1303 words
-
2 pages, 390 words
-
8 pages, 2108 words
-
4 pages, 950 words