Tag Archive: Tips and tricks

Articles sur le thème : Tips and tricks

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/

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/

Remove Duplicates

The tool "Remove Duplicates" It is very easy in Excel to extract all unique values from a list of data using the tool Remove Duplicates. This tool exists in any version of Excel. Since the Excel 2007 version, the menu is directly accessible from the ribbon. But for versions prior to Excel 2003, the tool is …

Continue reading »

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

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

Discover all the shortcuts with the Function Key Function keys alone Help Toogle to the Edit mode Paste name formula (if you have defined Name in your worksheet) Toogle the reference of a cell (block/un-block) Goto Go to the next pane. Spell Check Extend Selection (EXT appears in the status bar). In Extend Mode, when …

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/