Useful Microsoft Excel shortcut keys you must know. 

Ctrl+A
 : Selects the entire worksheet. 
Ctrl+B
 : Applies or removes bold formatting. 
Ctrl+C
 : Copies the selected cells. 
Ctrl+D
 : Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below. 
Ctrl+E
 : Adds more values to the active column by using data surrounding that column. 
Ctrl+F
 : Displays the Find and Replace dialog box, with the Find tab selected. 
Shift+F5
: also displays this tab, while Shift+F4 repeats the last Find action. 
Ctrl+Shift+F
 : Opens the Format Cells dialog box with the Font tab selected. 
Ctrl+G
 : Displays the Go To dialog box. 
F5
 : also displays this dialog box. 
Ctrl+H
 : Displays the Find and Replace dialog box, with the Replace tab selected. 
Ctrl+I
 : Applies or removes Italic formatting. 
Ctrl+K
 : Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks. 
Ctrl+L
 : Displays the Create Table dialog box. 
Ctrl+N
 : Creates a new, blank workbook. 
Ctrl+O
 : Displays the Open dialog box to open or find a file. 
Ctrl+Shift+O
 : Selects all cells that contain comments. 
Ctrl+P
 : Displays the Print tab in Microsoft Office Backstage view. 
Ctrl+Shift+P
: Opens the Format Cells dialog box with the Font tab selected. 
Ctrl+Q
 : Displays the Quick Analysis options for your data when you have cells that contain that data selected. 
Ctrl+R
 : Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right. 
Ctrl+S
 : Saves the active file with its current file name, location, and file format. 
Ctrl+T
 : Displays the Create Table dialog box. 
Ctrl+U
 : Applies or removes Underlining. 
Ctrl+Shift+U
 : Switches between expanding and collapsing of the formula bar. 
Ctrl+V
 : Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents. 
Ctrl+Alt+V
 : Displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program. 
Ctrl+W
 : Closes the selected workbook window. 
Ctrl+X
 : Cuts the selected cells. 
Ctrl+Y
 : Repeats the last command or action, if possible. 
Ctrl+Z
 : Uses the Undo command to reverse the last command or to delete the last entry that you typed. 
Ctrl+1
 : Displays the Format Cells dialog box. 
Ctrl+2
 : Applies or removes bold formatting. 
Ctrl+3
 : Applies or removes italic formatting. 
Ctrl+4
 : Applies or removes underlining. 
Ctrl+5
 : Applies or removes strikethrough. 
Ctrl+6
 : Alternates between hiding and displaying objects. 
Ctrl+8
 : Displays or hides the outline symbols. 
Ctrl+9
 : Hides the selected rows. 
Ctrl+0
 : Hides the selected columns.

Comments

  1. Office Setup Help1 March 2021 at 09:51

    Learning shortcut keys can improve speed, thank you for sharing this. Find all available shortcut keys and create your custom keys with these instructions at www.Office.Com/Setup.

    ReplyDelete

Post a Comment

Popular posts from this blog

What does a Human Resources department do?

Image
HR department, likewise the name pertains they take care of everything related to employees/Human resources. A Human Resources  generalist ,  manager , or  director  plays a wide variety of roles in organizations. Depending on the size of the organization, these HR jobs may have overlapping responsibilities. In larger organizations, the HR generalist, manager, and director have clearly defined, separated roles in  HR management . Initially human resources department used to be involved more into personnel and administrative task along with core functions of human resources like recruitment, training & development, employee engagement, performance appraisal and exit process. In today’s scenario HR professionals are turned out to be in business partnering playing a vital role into strategic decision making affecting human resources and organization. The role of the HR manager must parallel the needs of this developing, changing organization. Successful organizations a
Read more

Skip level Meeting: One-on-One

As commonly said, a skip level meeting is one where a manager's manager meets with employees to discuss department concerns, obstacles, opportunities for improvement, etc. with a focus on maintaining and/or improving overall communication. To check the pulse of the floor and to know what is going around, skip level meetings are said to be an acute tool. It helps in achieving business objectives accurately as through help of this meeting we know exactly who is doing what: We can know about: What managers/leaders are doing Feedback from the team about their team leads/managers for their improvement. Trust factor with those lower in your organization so they stay engaged and contributing. Any miscommunication happening between levels Values and vision can be communicated & implemented across organization If we can spend little time to get these in
Read more

Internal Job transfer Policy (IJP)

Internal Iob transfer Policy (IJP) means selecting a candidate for a particular job within an organization. It is a recruitment process for existing employees. The idea is to provide growth & development to the existing employees by recognizing internal employees instead of hiring externally. It cannot happen for many positions but yes for few positions organizations do practice to promote their brand and building trust of the employees. Advantages of IJP Existing employees have better understanding of company: As the company decides to find a suitable candidate within the company, it makes things easier for that existing employee because he/she is already aware of all the working nature and background of the company. And even the company can be advantageous because the company knows all the skills and ability of that particular existing employee. And this decision of employing an existing employee through
Read more

What is diversity & inclusion?

We all deserve the opportunity to develop our skills and talents to our full potential, work in a safe, supportive and inclusive environment, be fairly rewarded and recognized for our work and have a meaningful voice on matters that affect us. Diversity means that each individual is exclusive in terms of unique traits and characteristics. It includes many factors like age, gender, race, socio-economic status, geographic factors, ethnicity, physical abilities/disabilities, religious & political beliefs and other ideologies but valuing everyone as an individual makes a productive environment in which everybody feels valued, their talents are fully utilized and organizational and personal goals are met. Whereas “Inclusion” is a distinct idea from diversity. SHRM defines inclusion as “the achievement of a work environment in which all individuals are treated fairly and respectfully, have equal access to opportunities and resources and can contribute fully to the organizat
Read more

How to answer “Tell me about yourself”

We often hear this question approaching us during an interview. Many people get nervous and starts babbling around it instead of knowing that interviewer is asking a very simple question about one on-self. In fact, it is not as simple as it looks. Interviewer is not asking your personal story or life story and they have your resume as well. So why this question? What they want to know? Interviewer wants to know your communication skills, your confidence, your ability to keep engage. Interviewer wants to know how you express your experience, qualifications and why you are fit for the said opening in a nutshell. You cannot bore the interviewer by underlining out much. This question should be answered max in 3minutes. Three Tips to answer the question Give snapshot of your work history You can start by mentioning your total experience and work history from starting of your career to the current job and can menti
Read more

Performance management

Performance management is critical for an organization’s success. Employees need to understand what’s expected of them, and to achieve those goals they must be managed so that they’re motivated, have the necessary skills, resources and support, and are responsible. Performance management is the attempt to take full advantage of this value creation and ensure that employees contribute to business objectives. It should align with organizational strategy. It is majorly done to improve performance, establish goals & Objectives & hold people to account for their performance by linking it to reward, career progression and termination of contracts. Having a performance conversation only once or twice a year is not that effective. Continuous feedback, mentoring, clear communication about objectives, necessary training is equally essential nowadays. This is not to pin point the mistakes but to uplift the necessary skillsets. There has to be readiness, not only from leadership but al
Read more

Dealing with impact of Covid-19 pandemic lockdown as an HR Professional

Due to Covid-19 pandemic, it has affected all our personal as well profession life. The way we used to operate has changed to meet the new normal situation. As a HR professional we have to adapt the changes and find new ways to implement HR practices. Every change comes with its pros and cons. This change taught an organization also to put more trust and confidence in its employees and also effective ways of communication so that we can work remotely in an effective manner. We also learnt that there is no impossible as right now if I remind myself how we used to work in offices at that time we never thought that the whole organization can work remotely. A big thanks to technology without which it was impossible to manage in such severe situation. One more thing that comes to my notice is the productivity of the employees drastically improved. Recently, I was having discussion with few team members to check the mental h
Read more

Case Studies: Addressing grievances through one-on-one meeting

We come across many times questions during an interview or discussion wherein we have to describe our experience in form of mini stories. You can follow a standard pattern to answer this question. STAR Method- Situation, Task, Action and Response Situation- Scenario of the situation Task- What task did you perform Action- What action you choose to solve the problem Response- The end result of the situation¬ In my role,we were conducting one-on-one meeting to know the pulse of the floor and get the opinions. I understand that the department was in difficult situation as received numerous complaints from staff about them being treated by departmental heads and managers. I also got aware that the recent high attrition taking place in the particular department was due to such manager & Departmental heads. It was a difficult project to work on as all dept heads and managers were in system for many years and they had not
Read more

Performance improvement plan

A performance improvement plan (PIP), also known as a performance action plan, is a means to give an employee with performance shortages the opportunity to succeed. It may be used to address failures to meet defined job goals or to improve behavior-related concerns. Responsibilities of HR Facilitator Checking whether a PIP is the appropriate action for the situation. Facilitating all PIPs in line with the manager to prevent bias. Providing ongoing guidance to both the manager and employee throughout the plan. Significance of PIP Plan PIP is used when there is an intention of a manager to give employee a chance to improve rather than finding ways of terminating an employee. It is necessary to check if there is an actual performance or behavioral issue that can be improved? Ask the manager to create a list of the performance lacks, including dates, specific data or detailed explanations, and any previous g
Read more

Is on-floor / agile meeting helpful for bringing productivity in an organization?

Image
I am working as an Assistant HR manager with an IT firm. I did observe that employees do talk internally across department but rarely discuss about the work going on currently or project progress or any cross functional training etc. To bring such things forward, I have introduced on floor agile meeting on monthly basis. This is usually to be done in morning during tea time when everyone is starting their day. The agenda of meeting is to let various team know about each other e.g: Sales team can discuss on which kind of leads they are working and in future if such projects come to us what kind of expectations would be there from technical team and certain technology updates can be shared among all. Even team can discuss their latest project experience and learning’s so that it might help another department also in certain decision making. Also, Team lead or Project manager can highlight specific achievement related to work or any team member and give appreciation in front o
Read more