Topic Title: The Best Shortcut Keys in Microsoft Excel
Excel Keyboard Shortcuts
Ctrl+Z
Undo
Ctrl+C
Enter,
Ctrl+V
Ctrl+XCopy,
Paste,
Multiple Paste,
Cut
Ctrl+F,
Ctrl+HFind,
Find&Replace
Ctrl+P,
Ctrl+S, Ctrl+F4, Alt+F4Print,
Save, Close,
Close
Excel
Ctrl+Arrow
Move
to edge of region
Ctrl+*
Select
current region
Ctrl+A
Select
all cells
Ctrl+Home
Ctrl+EndSelect
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
UpMove
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,
F3Define
name, Paste name
Ctrl+Spacebar
Shift+SpacebarSelect
columns, Select rows
Ctrl+1,
Ctrl+B, Ctrl+UFormat
cells, Bold, Underline
Ctrl+;
, Ctrl+shift+:Current
date, Current time
By Vikas
Moving to the Last (or First) Cell in a Range
Using keyboard shortcuts
To move to the last (or first) cell in a range:
• Vertically from top to bottom, press Ctrl+Down Arrow.
• Vertically from bottom to top, press Ctrl+Up Arrow.
• Horizontally from left to right, press Ctrl+Right Arrow.
• Horizontally from right to left, press Ctrl+Left Arrow.
By Vikas
To select a range of non-adjacent cells:Selecting a Range of Non-Adjacent Cells
1. Select cell A1, and press Ctrl+Shift+Down Arrow.
2. Continue holding down Ctrl, and select another range.
3. Select additional ranges while continuing to press Ctrl.
By Vikas
Using keyboard shortcutsSelecting the Current Region/List
The Current Region/List is a range of cells containing data bounded by blank rows and columns.
To select the Current Region/List:
• Select a cell inside the Current Region/List range and press Ctrl+Shift+* (when using the * on the numeric keypad, press Ctrl+*).
• New keyboard shortcut in Excel 2003: Select a cell inside the Current Region/List and press Ctrl+A (you can still use Ctrl+Shift+*).
By Vikas
Can u plz let me know how to move curser while using keyboard.
By CA Amit Bajaj
Use Scroll Bar Amit to move the cursor...
By CA Anuj Sharma
Reply to this discussion
