In this tutorial, I am going to tell you about Microsoft Excel Shortcuts which will let save lots of time for your family and friends also save your time in office work and in your school projects. In your daily computer work you may be using lots of word, excel or PowerPoint shortcuts. Here, I am going to describe lots of excel shortcuts 2007 that will really make good at working on excel 2007. You can also use these excel shortcuts in other versions of Microsoft Excel.
 |
| Excel Shortcuts |
Select the whole column
Selection
CTRL +
SPACE
Select the whole row
Selection
SHIFT +
SPACE
Select table
Selection
SHIFT +
CTRL + SPACE bar
Save
Selection
CTRL + s
Select visible cells only
Selection
ALT + ;
Select entire region
Selection
CTRL + A
Select range from start cell to far
left
Selection
SHIFT +
Home
Select range from start cell to end
in direction of arrow
Selection
SHIFT +
End + arrow
Select a continuous range of data
(e.g. pivot), no matter where your cursor is.
Selection
CTRL + *
Select blank cells
Selection
F5 + ALT +
S + K + ENTER
Select all cells with comments
Selection
CTRL +
SHIFT + O
Select all cells that are directly
or indirectly referred to by formulas in the selection
Selection
CTRL +
SHIFT + {
Select all cells with formulas that
refer directly or indirectly to the active cell
Selection
CTRL +
SHIFT + }
Selects all the way to a1 from
cursor position
Selection
CTRL +
SHIFT + HOME
Select cells in the direction of
arrow
Selection
CTRL +
SHIFT + Arrow
Previous sheet
Navigation
CTRL +
Page Up
Next sheet
Navigation
CTRL +
Page Down
Launch GO TO Dialog (from here you
can select special or jump to a cell or range)
Navigation
F5
Go to top left (will go to top left
of freezed pane if set)
Navigation
CTRL +
Home
Go to last non-blank cell
Navigation
CTRL + end
Go to previous sheet
Navigation
CTRL +
PgUp
Go to next sheet
Navigation
CTRL +
PgDn
Print
Navigation
CTRL + p
Toggle between workbooks in a given
session of excel.
Navigation
CTRL + TAB
Change the type of cell reference
from relative to absolute or semi-absolute
Formulas
F4
Repeat whatever you did last
Formulas
F4
Debug portions of a formula (select
and press)
Formulas
F9
Sum range
Formulas
ALT + =
Enter array formula
Formulas
CTRL +
SHIFT + Enter
Select array formula range
Formulas
CTRL + /
Display range names (can be used
when typing formulas)
Formulas
F3
Evaluate formulas. (its easy to
remember when working with some “tuf” formulas!)
Formulas
ALT + TUF
Copy a formula from above cell and
edit
Formulas
CTRL + '
Display the formula palette after
you type a valid function name in a formula
Formulas
CTRL + A
(while writing a formula)
Alternate between displaying cell
values and displaying cell formulas
Formulas
CTRL + `
(Single Left Quotation Mark)
Calculate formulas
Formulas
F9
Select all precedent cells
Formulas
CTRL + [
Select all dependent cells
Formulas
CTRL + ]
Format Selection (cells, objects,
charts)
Formatting
CTRL + 1
Bold a cell’s content
Formatting
CTRL + B
Format Painter – Paste formats from
selection
Formatting
ALT + EST
Format as number with 2 dp
Formatting
CTRL +
SHIFT + 1
Format as local currency
Formatting
CTRL +
SHIFT + 4
Format as percentage with 0 dp
Formatting
CTRL +
SHIFT + 5
Hide row
Formatting
CTRL + 9
Hide column
Formatting
CTRL + 0
Unhide row
Formatting
CTRL +
SHIFT + 9
Unhide column
Formatting
CTRL +
SHIFT + 0
Display the style command format
menu
Formatting
ALT + '
Sets/removes strikeout in current
cell
Formatting
CTRL + 5
Show/hide the top bar when you have
a group
Formatting
Crtl + 8
Single border around selected cells
Formatting
CTRL +
SHIFT + 7
Sort
Formatting
ALT + DS
Insert hyperlink
Formatting
CTRL + K
Freeze panes
Formatting
ALT + WFF
Remove grid lines or
(alt+t)ov(alt+g)[enter]
Formatting
ALT + WVG
(2007+)
To wrap lines
Formatting
ALT + HW
(2007+)
Save as
Excel Options
F12
Collapse the ribbon (press again to
expand)
Excel Options
CTRL + F1
Opens print preview
Excel Options
CTRL + F2
Maximize the current window
Excel Options
ALT +
SPACE X
Activate next window
Excel Options
ALT + TAB
Activate previous window
Excel Options
ALT +
SHIFT + TAB
Close an excel workbook
Excel Options
crtl + F4
Split screens
Excel Options
ALT + W +
S
Create a pivot table in new sheet
(of course after selecting the range)
Everything Else
ALT + DPF
Create a pivot table in the same
sheet.
Everything Else
ALT + DPN
Show visual basic editor
Everything Else
ALT + F11
Macro dialog
Everything Else
ALT + F8
Apply/remove filter
Everything Else
ALT + DFF
Keep filter on columns, but show all
rows
Everything Else
ALT + DFS
Insert pivot table
Everything Else
ALT + NVT
Turn filter on or off
Everything Else
CTRL +
SHIFT + L
Paste values only
Editing
ALT + ESV
Edit a cell, place cursor at the end
Editing
F2
Show in-cell drop down with
previously entered values
Editing
ALT + Down
arrow
Fills down value from cell above
Editing
CTRL + D
Add a comment or Edit comment
Editing
SHIFT + F2
Insert new sheet
Editing
SHIFT +
F11
Insert row
Editing
CTRL + +
Delete row
Editing
CTRL + -
Copy
Editing
CTRL + C
Paste
Editing
CTRL + V
Cut
Editing
CTRL + X
Undo
Editing
CTRL + Z
Get a line break inside the cell
Editing
ALT +
Enter (while editing the cell)
Clear all contents
Editing
ALT + EAA
Copy
Editing
CTRL +
insert
Paste
Editing
SHIFT +
Insert
Make chart/pivot chart
Editing
F11
Edit a cell in Apple Macs
Editing
CTRL + U
Copy the value from the cell above
the active cell into the cell or the formula bar
Editing
CTRL +
SHIFT + "
Copies whatever is in the cell to
the left of it.
Editing
CTRL + R
Delete box (cell, row, column)
Editing
ALT + ED
Insert box (cell, row, column)
Editing
ALT + IE
Enter current date
Auto Complete
CTRL + ;
Enter current time
Auto Complete
CTRL + :
I hope all these excel 2007 shortcuts help you in your excel work. I hope you will also love all these Microsoft Excel shortcuts. If I left some excel shortcuts here, you can post them in comments and soon I will include them in this tutorial.
0 comments:
Post a Comment