If you work A lot with the spreadsheet program Microsoft Excel, then you will wish to be able to perform frequently recurring actions faster. In the following you will receive ten Right away actionable tips on how you will work through the use of keyboard shortcuts and mouse tricks noticeably faster.

The most tips work in all versions of Excel, only Tip 10 refers only to the versions of Excel 2013, Excel 2010 and Excel 2007. At the end of the article, you To find an image and a link to a PDF file that summarises the tips in the short form.

Excel Tip 1: Current date or current time using the keyboard shortcut "CTRL + (shift +) [dot] ' paste it into an Excel cell

Often, you need the current date, Which one should automatically adjust to not (as with the Excel formula "=HEUTE()" which would be case) in a cell in the Excel table. There are the practical keyboard shortcut "CTRL + [point]". You so hold the CTRL button and then briefly press the button with the point. In addition holding down the SHIFT key (called also shift, or capitalize) to the CTRL button, the current time is entered Instead of the date. You can either press this shortcut keys after you have clicked on an Excel cell, but also in a text, you To write in a cell, such as such as "created on [date] at [time]".

Excel Tip 2: Move and select in Excel spreadsheets using the keyboard shortcut "CTRL + (shift +) [arrow keys]"

There are many ways to move the marker to an Excel spreadsheet from one cell to another. But to jump from anywhere to the end or the beginning of a column or row, if the keyboard shortcut "CTRL + [arrow keys]" use. That means, for example, if the mark is in A1, you can press "CTRL + [down arrow]" to activate the selection jumps to The end of the column. Prerequisite for this is that there are no empty cells in the column, otherwise the mark on the respective cell stops before that. If between the current position of the mark and the end or At the beginning of the worksheet is no more a cell filled with content, then the selection jumps at The end or at the beginning of the worksheet.

Also holding down the SHIFT key to CTRL this key combination causes moves not only the marker to the appropriate location in the Excel spreadsheet, but until there is marked, which is extremely handy.

Excel Tip 3: tablespace quickly using the keyboard shortcut "CTRL + SHIFT + *" mark

Often you want to mark a range of contiguous table to him, for example, to format, or to create a chart from it. To do this, use best following method. Select a single cell in the data pane, and then press the keyboard shortcut "CTRL + SHIFT + *". The asterisk on the letter block is right next to the letter "Ü".

Excel Tip 4: Multiple rows or columns to insert or remove via keyboard shortcut "CTRL + [plus sign]" or "CTRL + [minus sign]"

Suppose you want to insert five blank lines between the current rows 6 and 7. To do this select the lines 7 to 11 first, by clicking with the mouse on the 7 line head and pull down to the line head 11 (row headers are the areas on which the line numbers are available). Then press the keyboard shortcut "CTRL + [plus sign]". To delete rows, press the "CTRL + [minus sign]".

If you want to do also the marking of lines via keyboard shortcut, use more the following tip. Move the marker to any cell in the row 7 press you then press "shift + [down arrow]" until you have selected five cells with each other. Then press the keyboard shortcut "shift + [space]", thus the lines 7 to 11 are fully marked. Proceed analog when you select columns and press at the end of "CTRL + [space]".

Analog works the whole insert or delete columns.

Excel Tip 5: Move and at the same time and sort list items by dragging them with the mouse while holding down the SHIFT key

Imagine, you create a list of items in a column in the Excel spreadsheet, which are to be carried out in order from top to bottom. How can you change now this order if necessary, without complex between blank lines to insert and work with copy or cut? This is quite simple. You first click the element you want to move. Then click the bounding box and hold down the mouse (not on the prominent corner right click below!). Also holding down the SHIFT key, drag the item to the place where it to go now. When a stroke with a double-T appears in the right place, release the mouse first and then press the SHIFT key. You can move multiple cells in this way or horizontally to move elements.

Excel Tip 6: At the same time work on multiple worksheets in Excel by grouping the worksheets

Not infrequently it has created similar tables in Excel on different worksheets and would prefer at the same time perform certain actions on all these sheets. This is easily possible, if at the same time highlight the corresponding table sheets, also grouping called. If you To want select multiple sheets, which are next to each other, to do this, click the first worksheet tab of the area, then hold the SHIFT key, and then click the last sheet tab of area of. Want to single sheets "pick out", hold down the CTRL key Instead of the SHIFT key. At the same time, actions that you perform on a sheet of the area, run on all selected sheets. It is important that you release this grouping at the end, by clicking with the right mouse button on one of the selected worksheet tab, and then click "Ungroup". As an alternative, You too can click on an unmarked sheet tab.

Excel tip 7: Using the shortcut key "ALT + [Enter]" To write multiple lines in an Excel cell

Maybe you is the opportunity to create a line break in an Excel cell, where you go via a right click on the cell in the "format cells" window, and there be the option to "Newline" on the "Alignment" tab.

If you quickly want to, insert a manual line break in a certain place To write multiple lines in the cell, then the shortcut key at the point at which the line break will take place, just press "ALT + [Enter]".

Excel Tip 8: AutoSum with the shortcut key "ALT + SHIFT + [equal sign]" insert

Very much often creates total using AutoSum in Excel. You can do Of course quite right so with the corresponding sum icon on the Home tab of the Ribbon. Instantly, this however, is if you press "ALT + SHIFT + [equal sign]" use.

Caution: using the key combination "ALT + SHIFT" alone one switches the keyboard layout to other languages, what you remember for example, when the English keyboard layout, because you get a "Y", though you have pressed a "Z". If this happens accidentally, press again "ALT + SHIFT".

Excel Tip 9: Lightning-fast copying of cell contents in such cells by double-clicking the fill handle.

Most users of Excel is known, that with the fill handle, right down to the corner of the selected cell (the small square), can copy by dragging with the mouse the contents of this cell. However, many do not know that you can faster copy still A lot with this fill handle downwards.

Here is an example. In column A, you have prices entered and in column B sales volume. In the cell C2 they have calculated "A2 * B2 =" sales with the formula.

To get the right formulas available cells now in all including now just double click on the fill handle. Excel automatically copies the formula down, until at The end of the list.

Excel Tip 10: Quick more icons in the Quick Access toolbar Paste via right click on any icons in the Ribbon

If you now think: "Oh, this whole keyboard shortcuts I can't I remember but, I stay stick with the good old mouse.", then comes now another tip, you will benefit from the. In the corner of the Excel window, the Quick Access toolbar is top left. Because it is always visible, you can at any time click whose symbols, no matter Which one of the Ribbon tab you are currently. By default, however, only three symbols are located on this toolbar (save, undo and restore). To quickly add more symbols, you can each arbitrary symbols, that are located on any tab of the Ribbon, click with the right mouse button and then click "Add to quick access toolbar".