Isn’t it exciting to have the ability to create your own right-click menu and customize it according to your needs. The default right-click menu doesn’t give much options.

Let’s add some frills to it:

1) Make list

How would you like the idea of creating the list of all the files that are in your folder in just one click?

Here’s the way to do it: Read the rest of this entry »

Popularity: 12%

This article shows how to reach other tabs in a workbook quickly when you have lots of them. Apart from simple “CTRL+PageUP/Pagedown” option, it talks about other alternate solutions like “Excel’s activate sheet option” and “Insert hyperlink” which are less time consuming and more efficient ways to navigate comfortably between worksheets.

Read the rest of this entry »

Popularity: 20%

This article introduces you to “Define Name” feature of excel with which you can give a name to any cell or range of cells and then just use that particular name in other formula’s like vlookup, offset, match etc without having to select it manually every time.

Read the rest of this entry »

Popularity: 20%

This article gives you a quick and easy way to access applications like excel, word, notepad, mspaint, internet explorer etc. In addition, it shows how to display “Run” tab on the start menu. 

Read the rest of this entry »

Popularity: 17%

This article is about how to access your recent documents. Most of you would be familiar with the “My Recent Documents” option on the “Start” Menu but this just shows 15 recently visited files….Which is clearly not enough so in this article we have given alternate options which are more comprehensive.

Read the rest of this entry »

Popularity: 21%

This article shows the magic of Shift and Control keys and how we can use them with arrow keys to work faster.

Read the rest of this entry »

Popularity: 21%

If you hit F2 on any cell, you can see the formula of that particular cell only.This article gives you a shortcut with which you would be able to see all the formula’s present on your spreadsheet all together.

Read the rest of this entry »

Popularity: 5%

If you right click on the chart, you would not see a delete option. So to delete a
chart, just select the chart area with a single mouse click and press the Delete key.

Popularity: 5%

To hide the selected rows enter CTRL+9.Entire row can be selected by pressing (shift+spacebar) together and then holding the shift key use the up or down arrow key to select more than one row.

To unhide any hidden rows within a selection enter CTRL+SHIFT+(

Similarly, to hide the selected columns enter CTRL+0.Entire column can be selected by pressing (Ctrl+spacebar) together and then holding the shift key use the right or left arrow key to select more than one column.

To unhide any hidden columns within a selection enter CTRL+SHIFT+)

Popularity: 7%

Long route: Copy the cell (CTRL+C) and then select the range by holding the shift key and paste it((CTRL+V).

Short route: No need to copy the cell. Just select the range including the topmost cell by holding the shift key and hit CTRL+D.

Popularity: 5%

Excel’s handy tips:

CTRL+1 Displays the Format Cells dialog box.

CTRL+2/CTRL+B Applies or removes bold formatting.

CTRL+3 Applies or removes italic formatting.

CTRL+4 Applies or removes underlining.

CTRL+5 Applies or removes strikethrough.

CTRL+9 Hides the selected rows.

CTRL+0 Hides the selected columns.

CTRL+A Selects the entire worksheet.

CTRL+C Copies the selected cells.

CTRL+F Displays the Find and Replace dialog box.

CTRL+G/F5 Displays the Go To dialog box.

CTRL+D Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.

CTRL+N Creates a new, blank workbook.

CTRL+O Displays the Open dialog box to open or find a file.

CTRL+SHIFT+O selects all cells that contain comments.

CTRL+P Displays the Print dialog box.

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+S Saves the active file with its current file name, location, and file format.

CTRL+T Displays the Create Table dialog box.

CTRL+U Applies or removes underlining.

CTRL+W Closes the selected workbook window.

CTRL+X Cuts the selected cells.

CTRL+Y Repeats the last command or action, if possible.

CTRL+Z Uses the Undo command to reverse the last command or to delete the last entry that you typed.

CTRL+SHIFT+& Applies the outline border to the selected cells.

CTRL+SHIFT+_ Removes the outline border from the selected cells.

CTRL+SHIFT+~ Applies the General number format.

CTRL+SHIFT+$ Applies the Currency format with two decimal places.

CTRL+SHIFT+% Applies the Percentage format with no decimal places.

CTRL+SHIFT+# Applies the Date format with the day, month, and year.

CTRL+SHIFT+@ Applies the Time format with the hour and minute, and AM or PM.

CTRL+SHIFT+! Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.

CTRL+SHIFT+Plus (+) Displays the Insert dialog box to insert blank cells.

CTRL+Minus (-) Displays the Delete dialog box to delete the selected cells.

CTRL+’ Copies a formula from the cell above the active cell into the cell or the Formula Bar.

F1 Displays the Microsoft Office Excel Help task pane.

ALT+F1 Creates a chart of the data in the current range.

F2 Edits the active cell

SHIFT+F2 Adds or edits a cell comment.

CTRL+F2 Displays the Print Preview window.

SHIFT+F3 Displays the Insert Function dialog box.

F4 Repeats the last command or action, if possible.

CTRL+F4 Closes the selected workbook window.

F5 Displays the Go To dialog box.

CTRL+F6 Switches to the next workbook window when more than one workbook window is open.

F7 Displays the Spelling dialog box to check spelling in the active worksheet or selected range.

F9 Calculates all worksheets in all open workbooks.

SHIFT+F9 calculates the active worksheet.

CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.

CTRL+F9 minimizes a workbook window to an icon.

SHIFT+F10 displays the shortcut menu for a selected item.

CTRL+F10 maximizes or restores the selected workbook window.

F11 Creates a chart of the data in the current range.

SHIFT+F11 inserts a new worksheet.

ALT+F11 Opens the Microsoft Visual Basic Editor, in which you can

create a macro by using Visual Basic for Applications (VBA).

F12 Displays the Save As dialog box.

CTRL+HOME moves to the beginning of a worksheet.

CTRL+SHIFT+HOME extends the selection of cells to the beginning of the worksheet.

TAB Moves one cell to the right in a worksheet.

SHIFT+TAB moves to the previous cell in a worksheet or the previous option in a dialog box.

ESC Cancels an entry in the cell or Formula Bar.It also closes an open menu or submenu, dialog box, or message window.

CTRL+END moves to the last cell on a worksheet.

CTRL+SHIFT+END extends the selection of cells to the last used cell on the worksheet.

BACKSPACE Deletes one character to the left in the Formula Bar.

DELETE Deletes one character to the right in the Formula Bar.

ALT+DOWN ARROW opens a selected drop-down list.

SHIFT+ARROW KEY extends the selection of cells by one cell.

CTRL+TAB switches to the next tab in dialog box.

CTRL+SHIFT+TAB switches to the previous tab in a dialog box.

PAGE UP Moves one screen up in a worksheet.

ALT+PAGE UP moves one screen to the left in a worksheet.

CTRL+PAGE UP moves to the previous sheet in a workbook.

CTRL+SHIFT+PAGE UP selects the current and previous sheet in a workbook.

PAGE DOWN Moves one screen down in a worksheet.

ALT+PAGE DOWN moves one screen to the right in a worksheet.

CTRL+PAGE DOWN moves to the next sheet in a workbook.

CTRL+SHIFT+PAGE DOWN selects the current and next sheet in a workbook.

Popularity: 7%