50 Short keys to use MS Excel faster

50 Short keys to use MS Excel faster 
Ms-office
MS Excel
Short cuts keys 

Here are the most useful 50 ms excel formulas which help you to use faster. These excel shorts cuts keys are specially used by the corporate workers on daily basis to make their work easier and faster.

All 50 short cuts keys with descriptions as below-



                    A to Z Letters with CTRL KEYS 

CTRL + A
- Select All

CTRL +C
- Copy all cells in highlighted area.

CTRL+ V
- Paste copied data

CTRL +B
- Bold all cells in highlighted area 

CTRL+ D
-Fills content of upper cells (as duplicate )

CTRL + R
-Fills content of Right cells

CTRL + U
- Underline the selected 

CTRL + P
- Print

CTRL +F
- To find 

CTRL +H
- Find and Replace dialogue box

CTRL + I
- Change font to italic 

CTRL + K
-To use hyperlinks 

CTRL + S
-Save the current wordbook 

CTRL + W
- Closes current wordbook 

CTRL + X
- Cuts all cells in selected areas 

CTRL + Y
- Repeat the last entry 

CTRL + Z
- Undo last entry 

                      1 to 10 with CTRL keys

CTRL + 1
-Change cells format 

CTRL + 2
- Bold all cells in highlighted 

CTRL + 3
-Puts italic all cells in highlighted area 

CTRL + 4
- Underline all cells in highlighted selection 

CTRL + 5
- Stikethrough all cells 

CTRL + 6
- Hide and unhide objects 

CTRL + 7
- Hide and unhide toolbar 

CTRL + 8
- Toggles the outline symbol 

CTRL +9
- Hides rows 

CTRL + 0
-Hides columns 

               To display current date and time 

CTRL + SHIFT + :
- To enter current time 

CTRL + ;
- To enter current date

              Insert/ Delete column or rows 
CTRL + +
-Insert 

CTRL + -
- Delete 

                 Hide / unhide coulms and rows

CTRL + SHIFT + ( 
- Unhide Rows

CTRL + SHIFT + )
- Unhide columns 

CTRL + Home 
- Move to cell A1

CTRL + END
- Move to last cell of worksheet 

CTRL + Enter
- Fills the selected cells with current entry

CTRL + Spacebar
- Selects the entire columns

CTRL + SHIFT + SPACEBAR 
- Select the entire worksheet 

ALT + =
- To sum all of the above 

F1 
- Opens the help menu

F2
- Edit the selected cells

F12
- Save as


These are the most useful excel formulas with short keys. 

Tags :-
#excel #excelkeys #msoffice #spreadsheet #formula #keys #excelatwork #Excelguru #formula 



Comments

Post a Comment

Popular posts from this blog

Threshold Transactions Reporting (TTR) - Nepal

Image
              Threshold Transactions Reporting (TTR)   Definitions: TTR : It stands for Threshold Transactions Reporting. TTR is a report that financial institutions and Designated Non-Financial Businesses and Professions are required to file to FIU-Nepal for : Deposit, Withdrawal, Exchange of currency, Other payment or transfer; if it exceeds prescribed threshold limit Provided by FIU-Nepal.  Reporting Thresholds for Reporting Entities The regulators of REs have designated different threshold limits as stated in their AML/CFT directives. The designated thresholds for REs have been categorized into; 1) Bank and Financial Institutions – 5 Regulators 2) Other Reporting Entities. – 6 Regulators Threshold :- Bank and Financial Institutions Currently, the designated thresholds for Bank and Financial Institutions in Nepal are as follows by the regulatory NBR ( Nepal Rastra Bank): Cash deposit or ...
Read more

How do you stay curious about product details as a project manager

How do you stay curious about product details as a project manager? Interview question asked in Infosys? Staying curious about product details as a project manager isn’t just helpful — it's often the secret to bridging the gap between vision and execution. Here’s how experienced PMs keep that curiosity alive and useful: How to Stay Curious About Product Details as a PM. 1. Ask “Why” Like a Newbie — Even When You’re Not > Don’t just manage tasks — ask why that feature matters, who it’s for, and what happens if it’s removed. “Why did we pick this flow?” “Why does this feature need to launch in Phase 1?” This opens up dialogue with devs, designers, and users — and reveals assumptions you may need to challenge. 2. Join Customer Support Channels or Feedback Loops Sit in on support calls or read user feedback in tools like Zendesk, Intercom, Reddit, or app reviews. Curiosity grows when you see the product through users’ eyes. > Real users ask the best questions — and t...
Read more

Interview as a Requirements Gathering Technique: A Business Analyst's Perspective

Interview as a Requirements Gathering Technique: A Business Analyst's Perspective Requirements gathering is a crucial phase in any project, as it lays the foundation for developing solutions that meet business and user needs. One of the most effective techniques for eliciting requirements is conducting interviews with stakeholders. This technique allows Business Analysts (BAs) to obtain detailed insights, clarify ambiguities, and understand business goals directly from key individuals. Interview as a Requirements Gathering Technique An interview is a structured conversation between the Business Analyst and stakeholders to extract necessary information regarding project requirements. It can be formal or informal, depending on the project's scope and complexity. Types of Interviews Structured Interviews – These follow a predefined set of questions to ensure consistency in data collection. Unstructured Interviews – These are open-ended and flexible, allowing for free discuss...
Read more