Ms Excel Shortcut Keys

Shortcut

Command

How useful(?)

CTRL combination shortcut keys

Microsoft Excel 2007

CTRL+SHFT+(

Unhides any hidden rows within the selection.

+ ����� –

CTRL+SHFT+)

Unhides any hidden columns within the selection.

+ ����� –

CTRL+SHFT+&

Applies the outline border to the selected cells.

+ ����� –

CTRL+SHFT_

Removes the outline border from the selected cells.

+ ����� –

CTRL SHFT ~

Applies the General number format in Microsoft Excel.

+ ����� –

CTRL+SHFT+$

Applies the Currency format with two decimal places (negative numbers in parentheses).

+ ����� –

CTRL+SHFT+%

Applies the Percentage format with no decimal places.

+ ����� –

CTRL+SHFT+^

Applies the Exponential number format with two decimal places.

+ ����� –

CTRL+SHFT+#

Applies the Date format with the day, month, and year.

+ ����� –

CTRL+SHFT+@

Applies the Time format with the hour and minute, and AM or PM.

+ ����� –

CTRL+SHFT+!

Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.

+ ����� –

CTRL+SHFT+*

Selects the current region around the active cell (the data area enclosed by blank rows and blank columns). In a PivotTable, it selects the entire PivotTable report.

+ ����� –

CTRL+SHFT+:

Enters the current time.

+ ����� –

CTRL+SHFT+

Copies the value from the cell above the active cell into the cell or the Formula Bar.

+ ����� –

CTRL SHFT Plus ( )

Displays the Insert dialog box to insert blank cells in Microsoft Excel.

+ ����� –

CTRL+Minus (-)

Displays the Delete dialog box to delete the selected cells.

+ ����� –

CTRL+;

Enters the current date.

+ ����� –

CTRL+`

Alternates between displaying cell values and displaying formulas in the worksheet.

+ ����� –

CTRL+'

Copies a formula from the cell above the active cell into the cell or the Formula Bar.

+ ����� –

 

CTRL+1

Displays the Format Cells dialog box.

+ ����� –

CTRL+2

Applies or removes bold formatting.

+ ����� –

CTRL+3

Applies or removes italic formatting.

+ ����� –

CTRL 4

Applies or removes underlining in Microsoft Excel.

+ ����� –

CTRL+5

 

 

Others

Circle Hover Effects CSS3
Circle Hover Effects with CSS3 Transitions
Radial Blur
Create attractive effect from photoshop of your photo.
Draw a Mobile â Photoshop Tutorial
Draw a Realistic Samsung Galaxy S2. To follow this tutorial, you will need the following resources...
Clean and Stylish CSS3 Form
This article is about creating a form using some of CSS3 properties. You can easily customize the style.

SIGN UP FOR NEWSLETTER

Sign up to received our free newsletter!
Name:
E-mail ID:

MOST READ

Views: 4954 Times
Making a Surreal Manipulation in Photoshop READ MORE
Views: 2836 Times
Facebook promises to fix email contacts deleting bug READ MORE
Views: 3984 Times
Microsoft Word 2013: Hands On READ MORE
Views: 5529 Times
How to add favicons to your Google search results READ MORE
Views: 7237 Times
Glossy Shiny Professional Icon Generator - Photoshop READ MORE

Home|IT News|Computer Tips|Video Tutorials|Download Softwares|Subjects|Contact Us
Copyright © 2018. Jumbo Education (Information Technology). All rights reserved.
Free counter and web stats

Large Visitor Globe