Excel Keyboard Shortcuts - Blogs
X

Below are some of the Keyboard shortcuts I use on a daily basis. Maybe helpful to others

 

Ctrl + R: Copy the contents from the left cell

Ctrl + D: Copy the contents from the above cell

End + : Go to the end till where there is text either to the left or right or up or down, depending on the arrow pressed.

Ctrl + W: Close the current Workbook

Ctrl + Home: Go to the starting of the sheet where data is present

Ctrl + End: Go to the end of the sheet where data is present

Ctrl + Pg Up: Go to the previous Worksheet

Ctrl + Pg Down: Go to the next Worksheet

Ctrl + +: When a column is selected, a new column is inserted to the left. When a row is selected, a new row is inserted above. Else it will prompt what needs to be inserted.

Ctrl +  – : When a column/row is selected then it is deleted. Else it will prompt what needs to be deleted.

Ctrl + : Select the current column

Shift + : Select the current row

F4: Repeat the last action

Related

Create Queries in Azure DevOps

let us learn how to create Queries. Queries are used to filter work items based on certain criteria....

Read More >

Microsoft Azure : Running JAVA Web Application using template

We will create Java web app in Azure App Service by using the Azure portal. The Azure...

Read More >

MS Dynamics

Canarys team has built a few vertical solutions on Microsoft Dynamics platform. These products are b...

Read More >

Data Mining for Supply Chain Management

IntroductionMarket turbulence arising from factors such as rapid introduction and customization of p...

Read More >

Creating a Simple Form with Validation Using ASP.NET MVC 4 Empty Template

There are multiple Validation attributes available in MVC. Validation attributes comes from System.C...

Read More >

Go for Gold. One More Gold for Canarys!

Canarys participated in the Go for Gold campaign conducted by Microsoft and have now achieved yet an...

Read More >

Bulk Export Import Test Cases to Azure DevOps Test Plans using CSV file

As a user of Azure DevOps Test Plans or TFS Test Management for manual testing, from a long time eve...

Read More >

The Ansible Architecture

Ansible is an open source, IT automation tool. It can configure systems, deploy software, and orches...

Read More >

Share

Try DevOpSmartBoard Ultimate complete Azure DevOps End-to end reporting tool

Sign Up

  • Recent
  • Popular
  • Tag
Monthly Archive
Subscribe
Name

Text/HTML
Contact Us
  • *
  • *