Best Online Tutorials

SQL Tutorial

Free SQL Tutorial

SQL Interview Questions

SQL Practice Questions

SQL Tips & Tricks

SQL Errors

SQL Books

Angular Tutorial

Free Angular Tutorial

Angular Interview Questions

Angular Practice Questions

Angular Tips & Tricks

Angular Errors

Angular Books

Node.js Tutorial

Free Node.js Tutorial

Node.js Interview Questions

Node.js Practice Questions

Node.js Tips & Tricks

Node.js Errors

Node.js Books

React.js Tutorial

Free React.js Tutorial

React.js Interview Questions

React.js Practice Questions

React.js Tips & Tricks

React.js Errors

React.js Books

SSIS Tutorial

Free SSIS Tutorial

SSIS Interview Questions

SSIS Practice Questions

SSIS Tips & Tricks

SSIS Errors

SSIS Books

SEO Tutorial

Free SEO Tutorial

SEO Interview Questions

SEO Practice Questions

SEO Tips & Tricks

SEO Errors

SEO Books

Javascript Tutorial

Free Javascript Tutorial

Javascript Interview Questions

Javascript Practice Questions

Javascript Tips & Tricks

Javascript Errors

Javascript Books

MongoDB Tutorial

Free MongoDB Tutorial

MongoDB Interview Questions

MongoDB Practice Questions

MongoDB Tips & Tricks

MongoDB Errors

MongoDB Books

Next.js Tutorial

Free Next.js Tutorial

Next.js Interview Questions

Next.js Practice Questions

Next.js Tips & Tricks

Next.js Errors

Next.js Books

Microsoft Excel Shortcut keys-General Program Shortcuts 

Pooja Goel  |   May 7, 2020  |  Views: 88

Description:

Microsoft Excel is the most used tool for all types of users. To manage data in excel is easy , but think if you have to manage large amount of data in Excel
You have to give your precious time to manage large data. So to help you Microsoft had provided some shortcut keys which are very helpful working on Excel, which increases your speed and save a lot of time and efforts. 

But the bad thing is that there ar a lot of keyboard shortcuts available which is not a easy task to remember to all. That's why we on DritalConnect have come up with some collection of important shortcut keys which you can try to remember.

Version of Excel don't matter for these listed shortcut keys, as it remains same whatever the version came and come in future.

General Program Shortcuts:


Action

Shortcut Keys

Create a new workbook

Ctrl+N

Open an existing workbook

Ctrl+O

Save a workbook

Ctrl+S

Open the Save As dialog box

F12

Close a workbook

Ctrl+W

Close Excel

Ctrl+F4

Repeat the last command or action

F4

Insert a new worksheet

Shift+F11

Undo an action

Ctrl+Z

Redo an action

Ctrl+Y

Switch to Print Preview

Ctrl+F2

Open the Help pane

F1

Go to the “Tell me what you want to do” box

Alt+Q

Check spelling

F7

Calculate all worksheets in all open workbooks

F9

Calculate active worksheets

Shift+F9

Turn key tips on or off

Alt or F10

Show or hide the ribbon

Ctrl+F1

Expand or collapse the formula bar

Ctrl+Shift+U

Minimize the workbook window

Ctrl+F9

Create a bar chart based on selected data (on a separate sheet)

F11

Create an embedded bar chart based on select data (same sheet)

Alt+F1

Search in a spreadsheet, or use Find and Replace

Ctrl+F

Open the File tab menu

Alt+F

Go to the Home tab

Alt+H

Open the Insert tab

Alt+N

Go to the Page Layout tab

Alt+P

Go to the Formulas tab

Alt+M

Go to the Data tab

Alt+A

Go to the Review tab

Alt+R

Go to the View tab

Alt+W

Go to the Add-ins tab

Alt+X

Go to the Help tab

Alt+Y

Switch between open workbooks

Ctrl+Tab

Insert a function

Shift+F3

Create, run, edit, or delete a macro

Alt+F8

Open the Microsoft Visual Basic For Applications Editor

Alt+F11


Comments:
Content Contributor
Pooja Goel

Pooja Goel

Sr. Software developer at Damco Solutions Pvt. Ltd.  |   Noida, Uttar Pradesh, India

I am a sr. software developer working on technologies like SQL, SSIS, SSRS, DB2,Tableau, ASP.NET having 7 years of experience.


Want to sell your software ?-

If you want to sell your readymade software to the genuine clients or businessman, list your software with details and demo links.

  • Sell ERP
  • Sell Website Clones
  • Sell App Clones
  • Sell Readymade Portals
  • Sell Readymade Websites
  • Sell Mobile Apps
  • Sell Window Apps

Clients will find it using our advanced search filter and will contact you directly.

No any charge for the product lsiting.

Do you own a Company ?+

Property.sale

Buy or Sell Commercial Property+

Are you a freelancer ?+

Looking for a job ?+

Are you a Service Provider ?+

Are you a blogger ?+

Do you own an IT Institute ?+


Property.sale