Key |
Function |
|
CTRL+A | - | Select All |
CTRL+B | - | Selected text Bold |
CTRL+C | - | Copy |
CTRL+D | - | Automatically paste above cell content |
CTRL+F | - | Find |
CTRL+G | - | Goto Line/Cell |
CTRL+H | - | Find and Replace |
CTRL+I | - | Italics the selected text |
CTRL+K | - | Insert Hyperlink |
CTRL+L | - | Create Format as Table |
CTRL+N | - | Open New spreadsheet |
CTRL+O | - | Open File |
CTRL+P | - | |
CTRL+R | - | Replace |
CTRL+S | - | Save File |
CTRL+T | - | Create Table (Where is the data for your table) |
CTRL+U | - | Underline the spreadsheet text |
CTRL+V | - | Paste |
CTRL+W | - | Spreadsheet close |
CTRL+X | - | Cut |
CTRL+Y | - | Redo |
CTRL+Z | - | Undo |
What
Do The Buttons Do?
View
This button will display the
worksheet containing the function example.
1. Click on the
function name, then
2. Click on the
View button.
|
Sort
This button sorts the list of
functions into alphabetical order.
|
|||
Category
This describes the category the
function is a member of.
Click this button to sort
alphabetically.
|
Location
This shows where the function is
stored in Excel.
1. Built-in indicates
that the function is part of Excel itself.
2. Analysis
ToolPak indicates the function is stored in the Analysis ToolPak
add-in.
3. Click this
button to sort alphabetically.
|
Hi Shiv, great stuff
ReplyDelete