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

Why move to VSTS?

Using many features of VSTS allow you to get started quickly and even make it easier to build, ...

Read More >

Token Based Authentication for Web API's

Securing ASP.NET Web API using Custom Token Based AuthenticationProviding a security to the Web API&...

Read More >

Kubernetes RBAC (Role Based Access Control)

The Kubernetes RBAC (role bases access control) system helps us in defining set of rules in controll...

Read More >

Maven’s Project Object Model

Maven’s POM.xml – A file to build ProjectsIn the previous article i.e. ‘Apache Maven – A tool to...

Read More >

Twitter Bootstrap – An UI Framework for Web Applications

Twitter Bootstrap is an open source front end framework for HTML, CSS and JS, using which we can cre...

Read More >

MIGRATION OF ACTIVE DIRECTORY USERS TO FORMS BASED AUTHENTICATION USERS

This document explains step by step information on configuring Form Based Authentication (FBA) in Sh...

Read More >

TFS to VSTS Migrations

The next evolution of TFSWhether you’re a startup or Enterprise or you’re a team of just...

Read More >

How to enable Lync Addin and create Lync Meetings using the Outlook 2013

 How to enable Lync Addin and create Lync Meetings using the Outlook 20131.   &n...

Read More >

Introduction to Azure DevOps Server (TFS) and Azure DevOps Services (VSTS)

In this blog we will talk about introduction to Azure DevOps Sever earlier called as Team Foundation...

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
  • *
  • *