Excel Tips

How to pivot Excel rows into columns ?

How to pivot the rows of an Excel table into columns? It’s relatively simple. You just need to select the area you want to rotate, in our example it is an Excel table with financial amounts and months. On the other hand, the special paste of the copied data is the Excel option to rotate the rows into columns. How to pivot the rows

Excel Tips

Disable the direct edit option in Excel

With Microsoft Excel, how to disable the direct edit option in Excel to edit spreadsheet cells? That is, the function of automatically modifying the content of a cell when it contains a formula? Indeed, by clicking on a cell containing a formula, this click sends you back to the first cell quoted in this formula. Indeed, this is very practical, but it can also

Excel Tips

Create a pivot table with Excel

How to create an Excel pivot table to analyse data? When analysing a lot of data, it can be difficult to analyse all the information in your spreadsheet. Especially large tables with several thousand rows. Pivot tables make spreadsheets more manageable by summarising the data and allowing it to be arranged in different ways. How do you answer the question “How much does each

Excel Tips

How to unhide an Excel spreadsheet ?

With Microsoft Excel, how to unhide an Excel spreadsheet ? I.e. make a hidden worksheet visible? A hidden Excel worksheet is handy in a shared workbook to not allow all users to change data or settings. For example, if the Excel workbook is locked with a password, then the hidden data is protected from changes. How to display a hidden Excel worksheet in a

Excel Tips

The best Excel shortcuts to manage pivot tables

Here is a selection of the best keyboard shortcuts to manage Excel pivot tables. Excel Pivot Tables, Excel Pivot table in English, or DCT for short, allow you to cross reference data in a file very efficiently. Whether the source is a flat CSV file, another Excel tab, an SQL source such as a SQL Server table or an SSAS cube. First of all,

Excel Tips

Create an Excel table and sort its columns

How to create an Excel table and sort its columns? Then filter the data? First create the required rows and columns. Fill the table with data and turn it into a table with headers. In the form of a table, it is possible to sort and filter the data easily. How to create an Excel table and sort its columns, format it and filter

Excel Tips

How to remove #VALUE! #NA! #DIV0 Excel errors?

How to remove #VALUE! #NA! #DIV0 Excel errors with any version of Excel like 2003, 2007, 2010 or Excel 2016? Common messages are for example: #VALUE!, #N/A, #DIV/0!, #REF!, #NAME?, #NULL!, #NUM! Indeed, there is a trick to solve this little problem that occurs more than often with Excel formulas. Using the IFERROR() function in Excel allows you to return a value if the

Excel Tips

Create and open a new Excel workbook

How to create and open a new Excel workbook? What is the Excel spreadsheet? Excel is a software from the Microsoft Office suite. An Excel file is also called an Excel workbook. Like a traditional physical workbook, it consists of sheets but also tables and cells. First of all, the Excel sheets are actually tabs. Tables and lists can be created. These tables and

Excel Tips

The best Excel shortcuts for selection

What are the best Excel selection shortcuts? Excel is a very powerful software tool and the most used spreadsheet program in the world by far. Nowadays everyone uses Excel in their daily work. However, many of the most effective Excel shortcuts for making selections are still little known. Here are the best Excel shortcuts in a series of articles. This selection of 16 Excel

Excel Tips

Select entire Excel column with a shortcut

How to select an entire Excel column of data, i.e. all the way down from the top the end? To select the current column down to the last cell, you can use a keyboard shortcut. This Excel shortcut works with a table and will stop at the last line of the table. But it also works with data that is not inside a table.