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

SAP RPA 2.0: Out of Office (Outlook Automation)

In this blog we will see how Out of Office messages can be set by searching for approved emails for ...

Read More >

ASP .Net MVC Error Logging Using Elmah

ASP .Net MVC Error Logging Using Google ElmahIntroduction: ELMAH is one of the popular Library to lo...

Read More >

Handling Radio buttons and Checkboxes using Selenium Webdriver

The main difference between Radio button and Checkbox is that, using radio button we will be able to...

Read More >

How to upload documents to SharePoint 2013

IntroductionSharePoint is a browser-based collaboration, content management, and extensible platform...

Read More >

CxO Roundtable at C-SOaP- SUMMIT 2013

   img{ display:block; } #outlook a{ padding:0; } body{ width:100% !importa...

Read More >

Technical Consultant | Visual Studio

Should be able to perform independently and with the team. Experience in creating reports using SQL...

Read More >

Building an Outlook 2010 Add In Using C#.NET With Visual Studio 2010

How to build an outlook 2010 Add In using C#.Net and Visual Studio 2010?In this post, I’l...

Read More >

How to download YouTube Videos using .NET

Are you interested in downloading YouTube Videos?Want to download YouTube Videos in device specific ...

Read More >

Unit testing in .NET

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

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