Shortcut Keys in MS Excel

-
Microsoft Excel Shortcut Keys
To Carry out the task
Shortcut Keys 
Close a workbook
Ctrl+W
Open a workbook
Ctrl+O
Go to the Home tab
Alt+H
Save a workbook
Ctrl+S
Copy
Ctrl+C
Paste
Ctrl+V
Undo
Ctrl+Z
Remove cell contents
Delete
Choose a fill color
Alt+H, H
Cut
Ctrl+X
Go to Insert tab
Alt+N
Bold
Ctrl+B
Center align cell contents
Alt+H, A, C
Go to Page Layout tab
Alt+P
Go to Data tab
Alt+A
Go to View tab
Alt+W
Open context menu
Shift+F10, or
Context key
Add borders
Alt+H, B
Delete column
Alt+H, D, C
Go to Formula tab
Alt+M
Hide the selected rows
Ctrl+9
Hide the selected columns
Ctrl+0
 Edit the active cell.
F2
 Displays the Go To box.
F5
 Open the Spelling dialogue box to check a selected range.
F7
 Create a chart of data in the current range in a separate sheet.
F11
 Insert a new worksheet.
Alt + Shift + F1
 Opens Insert Function dialogue box.
Shift + F3
 Opens the Find and Replace dialogue box.
Shift + F5
Enter the current time.
Ctrl + Shift + :
 Enter the current date.
Ctrl + ;
 Select all content in the worksheet.
Ctrl + A
 Bold highlighted selection.
Ctrl + B
 Italicize highlighted selection.
Ctrl + I
 Open the Insert hyperlink dialogue box.
Ctrl + K
 Underline highlighted selection.
Ctrl + U
 Apply strikethrough formatting.
Ctrl + 5
 Brings up the print dialog box.
Ctrl + P
 Undo.
Ctrl + Z
 Minimize a workbook window to an icon.
Ctrl + F9
 Maximize a selected workbook window.
Ctrl + F10
 Switch to the next workbook window when multiple are open.
Ctrl + F6
 Move to previous sheet in a workbook.
Ctrl + Page Up
 Move to next sheet in a workbook.
Ctrl + Page Down
 Switch to next tab in dialogue box.
Ctrl + Tab
 Insert the value of the above cell into the cell currently selected.
Ctrl + Apostrophe (')
 Apply the Number format.
Ctrl + Shift + !
 Apply the Currency format.
Ctrl + Shift + $
 Apply the Date format.
Ctrl + Shift + #
 Apply the Percentage format.
Ctrl + Shift + %
 Apply the Exponential format.
Ctrl + Shift + ^
 Apply the Time format.
Ctrl + Shift + @
 Move to the edge of the current data region in a worksheet.
Ctrl + Arrow Key
 Select an entire column
Ctrl + Space
 Select an entire row
Shift + Space
Insert a Blank Cell
Ctrl+(+)Plus Sign
To Delete a Cell
Ctrl+(-)Minus Sign


Comments

Post a Comment

Most Popular Posts

Functions in Excel

-
Image
Functions in Excel 2013 A  function  is a  predefined formula  that performs calculations using specific values in a particular order. Excel includes many common functions that can be useful for quickly finding the  sum ,  average ,  count ,  maximum value , and  minimum value  for a range of cells. In order to use functions correctly, you'll need to understand the different  parts of a function  and how to create  arguments  to calculate values and cell references The parts of a function A function must be written a specific way,  called   syntax . The basic syntax for a function is the  equals sign (=) , the  function name  (SUM, for example), and one or more  arguments . Arguments contain the information you want to calculate. The function in the example below would add the values of the cell range A1:A20. Working with arguments Arguments can refer to both  individual cells  and  cell ranges  and must be enclosed within  parentheses . You can include one argumen
Read more

Mixed Supply and Composite Supply under GST

-
Mixed Supply and Composite Supply under GST Let us understand first the term   “supply” simply means all forms of supply of goods/ services. It is carried out during the course of business. There are two types of supplies under GST, Composite and Mixed. Both of these supplies help to determine the correct GST rate and provides uniform tax treatment under GST for such supplies. Bundled Supply A bundled supply means supply of goods and/or services in a combination. This concept was mainly found in service tax where a bundled service meant a combination of two or more services. Here are some ways to identify whether it is a naturally bundled(Composite) or mixed one them: 1.      If buyers mostly expect such services to be provided as a package, then the package will be treated as naturally bundled. For example, most business conventions look for combination of hotel accommodation, auditorium and food. 2. If most of the service providers in the industry provide a package o
Read more

Learn How to Create Company in Tally.ERP9

-
Image
Company Creation Tally.ERP9 Tally.ERP 9 is not a just an  accounting software  but its a complete ERP solution to business organisations such as managing Accounts, Inventory, Payroll and taxations (GST)   compatibility from version Tally.ERP 9 release 6. How to create a company in Tally.ERP 9? To create a company in Tally.ERP 9, Double Click on   tally icon on the desktop. Press Alt+F3 -> Create Company Details to be filled in company creation screen Directory The tally directory will store all data you entered in Tally ERP 9. By default, the data storage will be inside the installation folder. i.e. c:\users\public\tally.erp9\data Name In this field, we are required to type the name of the company, for example. XYZ INC. Primary mailing details Mailing name In this field, we are required to type the name of the company, for example. XYZ INC. Address In this data field, we are required to enter the address of the company. Country Here we
Read more