|  

» The Best Shortcut Keys in Microsoft Excel

Ctrl+Z Undo
Ctrl+C

Enter,
Ctrl+V
Ctrl+X
Copy,

Paste,
Multiple Paste,
Cut
Ctrl+F,
Ctrl+H
Find,
Find&Replace
Ctrl+P,
Ctrl+S, Ctrl+F4, Alt+F4
Print,
Save, Close,
Close
Excel
Ctrl+Arrow Move
to edge of region
Ctrl+*
Select
current region
Ctrl+A Select
all cells
Ctrl+Home
Ctrl+End
Select
A1,
Select
last cell in used range
Ctrl+Shift+End Select
from active cell to last cell in used range.
Ctrl+Shift+Home Select
from active cell to A1
Ctrl+Page
Down
Ctrl+Page
Up
Move
to the next sheet,
Move
to the previous sheet
Ctrl+Tab Move
to next open workbook
Ctrl+N Open
new workbook
Shift+F11 Insert
new worksheet
Shift+F3 Paste
function window
=+FunctionName+Ctrl+A Insert
new function
Alt+F11 Open
VBE
Ctrl+Shift+Enter Array
formula
Ctrl+F3,
F3
Define
name, Paste name
Ctrl+Spacebar
Shift+Spacebar
Select
columns, Select rows
Ctrl+1,
Ctrl+B, Ctrl+U
Format
cells, Bold, Underline
Ctrl+;
, Ctrl+shift+:
Current
date, Current time


Rate This Tip
12 34 5
Rating: 2.59     Views: 1347999
Copy, Paste, Multiple Paste, Cut code confusing
Jill  Posted on: 31-12-1969
The "Copy, Paste, Multiple Paste, Cut" shortcuts are confusing. "Ctrl+C Enter, Ctrl+V Ctrl+X" are listed, but that's only three shortcuts, not four, and Ctrl-C (not Ctrl-C Enter) is Copy.
From range of relative references to absolute references
Brian Kelly  Posted on: 31-12-1969
I have a range of formulas linking to another sheet, the cells are linked with relative references (A1). I want to select the range of formulas and change all of the cell references to be absolute ($A$1). I dont want to have to click on each cell to change manually using the F4 key - how can I change the cell reference for the entire range of formula from being relative to absolute in one go??
wanna know
santosh  Posted on: 31-12-1969
i wanna know what is the short cut for fill color and
what is formula to delete row or colum
formula
mohamedali  Posted on: 31-12-1969
anybody know all list of formulas can using in excel?
Reply: formula - mohamedali from mak wrote on August 30, 2003 5:34 PM EST
aLAN  Posted on: 31-12-1969
Hi Mihamedali,

All of the standard (core) functions are listed in Excel's help sections.

Alan.
Copy, pasteetc
Chitra  Posted on: 31-12-1969
Jill, there are 4 shortcuts,
Copy - Ctrl C
Paste - Enter
Multiple Paste - Ctrl V
Cut - Ctrl X
Uppercase
Connie Fink  Posted on: 31-12-1969
How do you convert lowercase text to uppercase text without retyping?
Reply: Uppercase - Connie Fink from Ann Arbor, MI wrote on September 2, 2003 2:46 PM EST
Alan  Posted on: 31-12-1969
Hi Connie,

Use the UPPER function?

Alan.
Filtering
Liam Hoy  Posted on: 31-12-1969
Is there any way in excell to filter a record as soon as it is entered instead of always going to data, fiter. i would like it so every time i enter a new record into a row it will jump into the right order on the spreadsheet!
Name
Comment Title
Comments