21 best Excel shortcuts you must know

By | January 18, 2016

Here’s a collection of the best Excel shortcuts you must know to work more faster and conveniently on Excel.

CTRL+R — Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.

CTRL+7 — Hides or displays the standard toolbar.

CTRL — Shift & Outline border to the selected cells.

CTRL Shift : —  For the current time.

CTRL ; — For current date.

CTRL 0 — Hide selected columns.

CTRL Shift # — Change Date format with day, month and year.

CTRL Shift @ — Change Time format with hour and minute, AM or PM.

CTRL 9 — Hide selected rows.

CTRL ` — Display Formulas/Alternate in the worksheet.

CTRL+K — To insert Hyperlink.

CTRL+H — Opens up the Find and Replace dialog box.

ALT+F1 — This creates a chart out of the data in the current range (selected cells). This is the most well-known feature of Excel, and now you know a new way to use it!

CTRL+SHIFT+$ Applies the currency format to the selected cells.

CTRL+` Alternates between showing the value of a cell and the formula in the worksheet. Great for complex worksheets.

ALT+SHIFT+F1 — Inserts a new worksheet into a workbook.

F6 — Switches between the worksheet, Ribbon, task pane, and Zoom controls. This is probably the most useful shortcut of all. This cool shortcut is also the most beloved to all the anti-mouse users out there.

CTRL+D Fill down command on the selected cells. Fill down copies the content and format of the topmost cell into the cells below.

CTRL+R Fill right command on the selected cells. Fill right copies the content and format of the leftmost cell to the cells to the right

SHIFT+F6 The reverse of the F6 shortcut.

CTRL+F6 Switches to the next workbook window when multiple workbook windows are open.

 

.

Leave a Reply

Your email address will not be published. Required fields are marked *