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

Unit testing in .NET

Unit Testing – ExplainedA process which involves writing code to verify a system at a lower an...

Read More >

Create custom project templates in Visual Studio

Visual studio installation comes with the various predefined project templates, and we can use one o...

Read More >

LDAP Integration with Sonatype Nexus

Sonatype Nexus supports the Repository Manager integration with various active directory systems for...

Read More >

Single Team Project Migration from TFS to Azure DevOps Services

Does your client want to break out from the existing older version of TFS (2015 and later) to Azure ...

Read More >

How to Create an Azure Virtual Network by using a Deployment Template

Hello Folks!In this Blog post, we will try to learn how to create an Azure V-Net using an ARM templa...

Read More >

Mobile Webinars Registration

h2{ margin-bottom:10px;}#wrapper{ margin: -40px auto 0; }#wrapper h1{ color:#FFF; text-align:center...

Read More >

How to Install TestNG framework (Step by Step installation process)

Steps to Install Eclipse using install new Software:Step 1: In Eclipse, on top menu bar, Under Help ...

Read More >

Analysis of Load Test Results

Analysis of Performance DataAfter you capture and consolidate your results, analyze the captured dat...

Read More >

Share

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

Sign Up

  • Recent
  • Popular
  • Tag
Tags
Monthly Archive
Subscribe
Name

Text/HTML
Contact Us
  • *
  • *