Here are some of the shortcuts of Excel 2010 to work in
better way.
better way.
Ctrl + pgup :
switches between worksheet tabs, from left to right
switches between worksheet tabs, from left to right
Ctrl + pgdn :
switches between worksheet tabs, from right to left
switches between worksheet tabs, from right to left
Ctrl + shift + & :
applies the outline border to the selected cells
applies the outline border to the selected cells
Ctrl + shift + _ :
removes the outline border from the selected cells
removes the outline border from the selected cells
Ctrl + shift + ~ :
applies the general number format
applies the general number format
Ctrl + shift + $ :
applies the currency format with two decimal places
applies the currency format with two decimal places
Ctrl +shift + % :
applies the percentage format with no decimal places
applies the percentage format with no decimal places
Ctrl +shift + # :
applies the date format with the day, month and year
applies the date format with the day, month and year
Ctrl +shift + @ :
applies the time format with the hour and minute and AM or PM
applies the time format with the hour and minute and AM or PM
Ctrl +shift + ! :
applies the number format with two decimal places, thousand separator, and
minus sign for negative value
applies the number format with two decimal places, thousand separator, and
minus sign for negative value
Ctrl +shift + : :
enters the current time
enters the current time
Ctrl +shift + “ :
copies the value from the cell above the active cell into the cell or the
formula bar
copies the value from the cell above the active cell into the cell or the
formula bar
Ctrl +shift + + :
displays the insert dialog box to insert blank cells
displays the insert dialog box to insert blank cells
Ctrl +shift + – :
displays the delete dialog box to delete the selected cells
displays the delete dialog box to delete the selected cells
Ctrl + shift + ( : unhide any hidden rows within selection
Ctrl + shift + ) : unhide any hidden columns within selection
Ctrl + ; :
enters the current date
enters the current date
Ctrl + ` :
alternate between displaying cell values and displaying formulas in the
worksheet
alternate 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
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
displays the format cells dialog box
Ctrl + 6 :
alternates between hiding and displaying objects
alternates between hiding and displaying objects
Ctrl + 8 :
displays or hides the outline symbols
displays or hides the outline symbols
Ctrl + D : uses
the fill down command to copy the contents and format of the topmost cell of a
selected range into the cells below
the fill down command to copy the contents and format of the topmost cell of a
selected range into the cells below
Ctrl + G or F5 :
displays the go to dialog box.
displays the go to dialog box.
Ctrl + I :
applies or removes italic formatting
applies or removes italic formatting
Ctrl + L :
displays the create table dialog box
displays the create table dialog box
Alt+shift+1 : inserts new worksheet
Alt + F1 : creats a chart from the data selected
Shift + F2 : adds or edits cell comment
Ctrl + F2 : shows print preview
Hope you find it useful. Comment if you have doubts or suggestions. Like, tweet and + post if you find it useful. follow us to get more.
Leave a Reply