The top 20 MS excel shortcuts key used for Microsoft Excel are:
- Home
- Ctrl + Page Down & UP
- Ctrl +Arrow Keys
- Ctrl + *
- Ctrl+5
- Shift + F10
- Ctrl + shift + [desired function key]
- Ctrl + F1
- F2
- F4 or Ctrl + Y
- F6
- F12
- Ctrl + Enter
- Ctrl + Alt + V
- Shift + Spacebar
- Alt
- End
- Enter
- Esc
- F1
Microsoft Excel
Shortcuts Key
- Home
When
working on the excel spreadsheet, the Home button on
the keyboard conveniently takes the user back to the beginning of a row with
just a click. If the scroll lock is turned on, clicking the ‘Home’ button takes
the user to the cell in the upper-left corner of the window. If a menu or sub menu
is open, the home button selects the first command on the visible menu.
Users
can move to the beginning of a worksheet by combining Ctrl + Home buttons. When
working in a cell, using the Home/End buttons allows users to conveniently move
to the beginning and the end of a cell data.
To
extend the selection to the starting point in a row, combine Shift + Home and
to extend the selection to the beginning of the worksheet, click Ctrl + Shift +
Home buttons.
2.
Ctrl + Page Down & UP
Ctrl + Page Down or Ctrl + Page Up button helps in
quickly surfing through worksheets
in excel. Instead of crawling through the lines, users can jump from one
worksheet to another with ease through this keyboard shortcut. Ctrl + Page Up
moves to the previous worksheet whereas the Ctrl + Page down moves to the next.
If the user has about 8 worksheets and is working on 7th but wants to check the some data on 3rd,
then all he is has to do is hold down the Ctrl button and press page up 4
times.
3.
Ctrl +Arrow Keys
The arrow keys are useful in moving one cell up,
down, left, or right in a excel worksheet. With the help of shortcut Ctrl +
Arrow keys the user can easily move to the edge of next data region, but only
if there are no blank cells on the worksheet. This helps to scroll through
pages faster. Pressing Ctrl + Down Arrow key will take the user to the last row
on the worksheet whereas clicking Ctrl + Up Arrow key will take the user to the
first row in the worksheet. The same applies for right and left arrow keys.
4.
Ctrl + *
When the user desires to either copy or delete the
current region around the actively working cell, the shortcut Ctrl + *
(asterisk) helps in selecting the current active range in the cell with the
entire data area that is enclosed by blank rows and blank columns.
The shortcut covers the data set in
all directions from the current active space up to the end of the worksheet or
a blank row or column. When working on a PivotTable in excel worksheet, the shortcut helps in selection of the entire PivotTable Data. The asterisk key is available on the numeric keyboard
for independent selection.
5.
Ctrl+5
For those who like to finish the task on the list and
strike it off, the shortcut Ctrl + 5 will do the job effectively. Striking a task off the ‘To Do List’ will make it
clear to the user what has been accomplished and what is left to do. If all the
task in the cell has been completed, the entire cell can be selected and strike
through by pressing Ctrl + 5 shortcut.
6.
Shift + F10
The shift + F10 shortcut functions like the
right-click on the mouse, opening up the menu for use. It is agreed that moving
hand to the mouse when working on keyboard can be annoyance, hence having this
option on the keyboard is a blessing. Further, users can use the arrow keys to
move through the menu and press enter to select the desired option. To check
the fly-out menus the right arrow can be used.
7.
Ctrl + shift + [desired function key]
The control + shift buttons helps in inserting
various functions in the worksheet with ease. To insert current time, click
Ctrl + Shift + ; Users can format date and time on their worksheet by inserting
desired function key along with Ctrl + Shift buttons.
The Ctrl + Shift + = will open the insert cells
options. Ctrl + Shift + W will wrap the text. Ctrl + Shift + 7 will select the
border or outline of the worksheet. Ctrl + Shift + # will apply date format
with the day, month and year. The new Ctrl + Shift shortcuts with various
helpful combinations makes the task of managing
the Excel worksheet much easier.
8.
Ctrl + F1
When working on the worksheet, at times the ribbon
can be distracting or encroaching on the work space. The problem can be handled
deftly by pressing the Ctrl + F1 shortcut which hides the ribbon. Pressing the
shortcut again will make the ribbon visible once again.
9.
F2
To edit the current working cell just click on F2
button on the keyboard. User can not only edit the active cell, but can also
efficiently position the insertion point at the end of the cell contents with
ease using this shortcut.
Clicking on F2 button helps in moving the insertion
point into the Formula Bar when editing in a cell is turned off. To display the
print preview area on the Print tab in the background, combine Ctrl and F2
keys.
10.
F4 or Ctrl + Y
When the user has to repeat a complicated command
previously applied to the Excel Worksheet, pressing the F4 key will do the job.
The shortcut repeats the last command except some cases where the action cannot
be repeated through the shortcut. The shortcut F4 will also deftly cycle
through all the combinations of locked and unlocked locations or data when a
formula in a cell is being edited.
For example – if the last function was to strike
through a column on to do list with shortcut key Ctrl + 5, the action can be
repeated with by pressing F4 key with ease. When
working on excel worksheet it is very convenient to have a shortcut to repeat last
formatting action for complicated lengthy functions with just a click of a
button which saves time.
11.
F6
When working with Microsoft Excel, users often have
to switch between the current worksheet, task pane, zoom-in and zoom-out
controls and ribbon for selecting various functions. Reaching out for the mouse
for selection can be tedious task, but fortunately the shortcut key F6 comes to
the rescue here. When the user has split the worksheet into more than one pane,
the shortcut will include the split panes when switching between different
areas.
12.
F12
Nothing can be more frustrating than the hard work
lost when the user fails to save the file, especially if it is data entered on
Spreadsheet. The right thing to do is use the shortcut F12 which brings up the
save as option for the file. It saves the user lot of unnecessary functions
which leads to the save option.
13.
Ctrl + Enter
Another useful excel shortcuts include the combination of Ctrl +
Enter key which fills the selected cell range with contents of current entry.
By using the shortcut the contents of an edited cell can be automatically
exported to other selected cells.
14.
Ctrl + Alt + V
It is easy to remember this particular shortcut since
everyone is quite familiar with the Ctrl + V option which is regularly used to
insert the copied content of the clipboard at the desired point. For some of
the complicated data used in Excel worksheet, users may have to use Paste
Special option. The shortcut Ctrl + Alt + V opens the Paste Special dialog box
for pasting the cut or copied object, text, or cell contents on a spreadsheet.
The copied content can be pasted in another program as well.
15.
Shift + Spacebar
Since every row in the Excel spreadsheet has an
individual function, users may be required to select an entire row for a
function. Using the shortcut Shift + Space makes the task easy. Once selected,
changes can be applied to the whole row.
16.
Alt
There is no argument that keyboard shortcuts are very
useful while working on excel spreadsheet. How about having a shortcut that
opens up a menu of excel shortcuts on the ribbon? Alt button is the key that
displays the Key Tips or new shortcuts on the ribbon of Microsoft Excel. For
example, when you click on the Alt button, the options for new shortcuts on the
ribbon open up – H for home, P for Page Layout and M for Formula. When you
further press Alt + M the formula function opens up. Alt key is also combined
with various keys for creating different shortcuts, the most popular being Alt
+ F4 to close an open file.
17.
End
The End button when used with Excel worksheet turns
the End Mode on or off. This can be viewed in the bottom corner of the
spreadsheet.
When
the end mode is on, user can press the arrow keys to move to next blank cell in
the column or row as required. Once the arrow key has been used to access the
blank cell, the end mode turns off. The End button has to be clicked once again
to activate it for further use. If the spreadsheet has only blank cells then
the shortcut moves to the last cell in the column or row.
The
End button is also used to select the last command on the menu when a menu or
submenu is visible.
18.
Enter
When
the entry in the cell or the Formula Bar is
completed, user can select the Enter shortcut to complete the entry and move on
to the next cell.
For
example when the date is entered in the column, by pressing enter key the Data entry for Rental Company can be
accessed for editing. When
the spreadsheet is in the data format, the shortcut moves to the first field in
the next record. It can be combined with different keys for accessing different
excel shortcuts. For example, using the Alt + Enter shortcut will create a new
line in the same cell.
19.
Esc
No matter how experienced you are, there are sticky
places you get on the Excel worksheet from which the escape route will be
through shortcut button Esc. The shortcut is also used to cancel undesired,
completed or wrong entry in a cell or formula bar. If there are menus,
submenus, message windows or dialog boxes open, the shortcut will close them.
20.
F1
Finally, if the user is still at loss and needs some
help, F1 is the right shortcut for call out for help.
0 Comments