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