Function keys, keyboard shortcuts for excel

Instead of having to enter duplicate data in the table often leave a blank cell. The presence of empty cells in the table difficult to use filters, sorting and building Pivot tables. Fill the blank cells with values from the upstream cells.

Sometimes you need to enter the same values in the incoherent range of cells. Show how to do it quickly.

On a worksheet containing lot of data and tables, it is often difficult to find the necessary information. Use standard search CTRL+F to search for data only in the desired range of cells in EXCEL worksheet.

using the mouse wheel and keys CTRL you can quickly change the display scale of a sheet EXCEL.

When placing shapes (or pattern) in the EXCEL worksheet, such as a rectangle, it is often necessary to align it along the cell borders. To accelerate this process helps key ALT.

IN EXCEL there are several ways to quickly fill cells with values from adjacent ranges.

SUM() is probably the most used function in EXCEL. Of course I want to spend on her input as possible.

Using the keyboard F4 to repeat the last user action.

worksheet, you can highlight the cell (adjacent and nonadjacent), ranges, rows or columns.

When composing complex formulas, it can be useful to quickly learn the intermediate result of the calculations made a part of the formula.

If a cell contains a long formula, with the help ofthe creed line Break (ALT+ENTER) convenient to display it in multiple lines in the box formula bar.  

Knowing the decimal value of the character code, you can enter this character using the key combination ALT+code. Of course, any character can be entered through a command Insert/ Text/ Symbol but sometimes, for example, if you enter a custom format using Format cells, but this command is not available.

a Dialog Transition, called by F5, allows you to quickly navigate not only between the defined in the book of names cells and ranges, but also remembers the last 4 places (address ranges) you've visited, and those places can be on all the currently open workbooks.