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

RCM- Reverse Charge Mechanism

-
Image
RCM - REVERSE CHARGE MECHANISM Under normal circumstances, the supplier of goods or services collects the tax and pays it to the Govt. But in case of Reverse Charge, the receiver becomes liable to pay the tax to the Govt., which means the chargeability gets reversed. Reverse charge is a mechanism where the recipient of the goods and/or services who is a registered dealer is liable to pay GST instead of the supplier. Normal GST Transaction Flow   RCM Transaction When is Reverse Charge Applicable A. Supply from an Unregistered dealer to a Registered dealer If a vendor who is not registered under GST, supplies goods to a person who is registered under GST, then Reverse Charge would apply. This means that the GST will have to be paid directly by the receiver to the Government instead of the supplier. The registered dealer who has to pay GST under reverse charge has to do self-invoicing for the purchases made. For Inter-state purchases the buyer ...
Read more

HTML CSS mcq Question Bank

-
Multiple Choice Questions 1) What does CSS stands for?        A) Creative Style Sheet                      B) Colorful Style Sheet     C) Cascading Style Sheet                    D) none of the above       2) Which HTML attribute is used to define inline style?      A) Style                                         B) font   C) Styles                             ...
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. ...
Read more