Friday, 9 December 2016

Simple shortcut keys in excel spreadsheet

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 - Print
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
--------------------------------------------------------------------------------------------------------------

Image result for Instruction

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.







1 comment: