Tag Archive: Tips and tricks

Articles sur le thème : Tips and tricks

Fill Series

The fill handle is very useful to copy formulas as you know but also, you can fill series of number or date. Look at the following tutorials to see what you can do. Fill series of numbers When you have to create a list of number, it is not necessary to create a formula or to …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/fill-series/

Draw your borders with the mouse

Don’t waste your time to draw the border line of your table in Excel. The draw borders tool will help you to save a lot of time like in this example. Draw borders tool In Excel, you can easily draw the border or the grid of your data just with your mouse. But first you …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/draw-your-borders-with-the-mouse/

Pivot Table – Generate multi-worksheets

Pivot Table is a great tool to split a file into multiple worksheets Presentation of the tutorial If you are reading this article it’s because you have a huge table and your have to split the contain in many worksheets. Methodology To make this work, we must create a pivot table. To see the method, …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/generate-multi-worksheets/

Change the Themes

You can customize Excel 2007 or 2010 by modifying the basic colors as well as adding your own menus. Custom themes By default, colors and fonts are loaded into the Home menu / Police.     Ditto for the effects applied to the forms Now you can change themes by going to the Page Layout …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/change-the-themes/

Shorcuts – Function Key

At the beginning of the computer technology, the Function keys were really useful. Nowadays, these keys become less useful but some of them are still really important if you work daily with Excel. Discover all the shortcuts with the Function Key Function keys alone Help Toogle to the Edit mode Paste name formula (if you …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/shortcuts-function-key/

Shortcuts – Control Key

Discover all the shortcuts with the Control Key Shortcut with letter + Select all cells around the active cell (non-empty) Select all cells of your worksheet (if the active cell is empty) When you fill a formula, Ctrl + A display the formula’s Dialog box. + Toogle Bold + Copy + Fill Down Duplicate an …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/shortcuts-control-key/

Shortcuts – Alt Key

Discover all the shortcuts with the Alt Key Shortcut with symbol + Insert the function SUM in your active cell + Display in a combobox the value in the same column + + Group the data (row or column) + + Ungroup the data (row or column) Function keys + Insert a new chart + …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/shortcuts-alt-key/

Remove Duplicates

The tool Remove Duplicates Since Excel 2007 In these versions, the tool Remove duplicates is in the tab Data.     To extraction without duplicates, you have to follow this 2 steps Select the column where want to remove the duplicates Click on the tool Remove Duplicates In the next dialog box, indicate if the …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/remove-duplicates/

Move and Copy worksheets quickly

In Excel, there is a lot of tips and tricks to move or copy a worksheets. Here is some examples Move sheets in a workbook To move a worksheet inside a workbook, you just have to Select the worksheet you want to move by a click Hold and drag your mouse Release the button of the …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/move-and-copy-worksheets-quickly/