We have gathered 25 tips to use in Ukraine WhatsApp Number List  Excel, keyboard shortcuts specific to the management of pivot tables. Discover our selection of 25 tips to take advantage of the many features of Excel. Photo credits: monticellllo / Adobe Stock. Microsoft Excel is arguably the most complex software in the Microsoft Office suite. It is quite easy to learn to create tables. But there are tips to take advantage of the many, many features of the software. They are based on Microsoft Excel 2010. Slight variations may appear, especially for versions prior to 2007. If you use other tips on a daily basis, you can share them! Likewise, do not hesitate to comment on the article if you have difficulty performing a particular action in Excel,

we will try to respond quickly. If you want to go further, you can also train yourself to become an Excel expert . Keyboard shortcuts in Microsoft Excel Like many software, some very useful shortcuts allow you to be more productive in Excel. In addition to the traditional Ctrl + S to save a document or Ctrl + C to copy an element, these 10 Excel-specific shortcuts allow you to go faster. Recalculate data: F9 Insert today’s date: CTRL +; (semicolon) Insert the time: CTRL +: (colon) Go to a cell or table: F5 Select an entire active column: CTRL + Space Select an entire active line: SHIFT + Space Select the whole Excel sheet: CTRL + A Make a special paste in Excel (to paste only the data etc.):

Select An Entire Table Or Go To The End Of Excel


CTRL + ALT + V Insert an automatic sum: ALT + = Hide (and especially re-display) the features ribbon: CTRL + F1 Excel functions In Excel, the functions are very numerous. They allow you to perform calculations, search for data, or obtain information. To insert a function, all you have to do is click on the Fx icon under the ribbon. All cells that contain a function begin with the = character. If you are familiar with certain functions, you can access them directly by entering = then the name of the function within a cell. To better understand the potential of Excel functions, we advise you to consult our list of Excel functions to know . Name a table in Excel In some cases, it can be useful to name an array.


Select the range to name (example: from cell B2 to cell E7). Then click on the field on the left, under the ribbon, then enter the name of your choice. In this example, our array is named Data . Once named, you can use the data in your table very easily: to know the sum of the data present in our table, a simple = SUM (Data) is enough. You can access the Name Manager through the Formulas tab on the ribbon. Copy paste Excel functions Very often, the functions of an array follow and resemble each other. For this reason, Excel uses certain rules when you copy paste a function to maintain the logic of your calculations. In the example below, the SUM column is the sum of the values ​​in the row.

Customize The Printing Of An Excel Table

It suffices to copy the function D2 and paste it in D3 to obtain the sum of the data of the third row. Create a logical sequence using click drag Instead of copying and pasting the formulas, you can duplicate them by clicking and dragging. All you have to do is select the source cell (s), then place your cursor at the bottom right of the cell. A small cross will appear, allowing you to easily copy paste the formula (or a series of formulas) to the side or down. Some values, such as cell ranges, will be replaced automatically to maintain the logic of your functions. You can also create a logical sequence using this trick, but you must select several cells. Example: if two adjacent cells contain two consecutive dates (October 16 and October 17 for example),

you can select them, click on the small cross at the bottom right of the cell and drag your cursor over several cells to display October 18, October 19, October 20 and so on. This also works for series of numbers. Freeze row, column or cell in Excel function In certain cases, one wishes to “freeze” a row, a column or a cell in a series of functions. To always divide a calculation by the same cell for example, regardless of the location of the formula. To do this, when entering your formula, just press the F4 key when the cell in question is mentioned. For example, enter = SUM (D4 , then press F4. The start of your function will change to = SUM ($ D $ 4. The dollar sign indicates that the next element

Leave a Reply

Your email address will not be published.