Tricks for not so novices in Excel

Always as much as they tell us that they know them all, it’s everything else there’s always something that I keep secret and this person doesn’t know it, then more Excel tricks.nnNo, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no. no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no,

nt
1. In order to open a book in the beginning, when we use Excel we always work with the same template, many times we want it to be automatically loaded when opening Excel, to do so we would have to save it in a folder called MICROSOFT OFFICE OFFICE11 XLSTART PROGRAM ARCHIVES, being thus written the book will open automatically when we start the Excel program, regardless of what it is called.

nt

2. To put the same width in all columns this program gives us some very good options, so that we can solve this problem, to get two or more columns to be the same width we will do so; first we select the column that has the width that you want to apply, in another column with a click on the header, as a second step, we position ourselves with the cursor over the column and we right click on the mouse, a context menu will open, we will click on the copy option, then we will click on the header of the destination column, then we will give another right click to open the context menu again, we will choose the option pasted, then we will mark the wide option of the columns, we will press accept.

nt

3. If we want to enter fractional numbers we will do it although it may seem difficult and cumbersome because of the “/” character we use to set the dates, if we enter for example 2/5, Excel will take it as if it were a date it would look like the date (2-MAY), then to make Excel understand that it is a fractional value we must write the value as well 0 2/5, on the screen it will appear as 2/5 while internally the program will store it as 0.4.

nt

4. To be able to Auto complete faster than normal, when loading repetitive data in Excel we do it with the “Autocomplete” function being enabled, this method used is quite fast and fast, in turn this has an alternative tool so that it can be speeded up even more, since if you are loading a list of values and you have to repeat it one by one, from the cell that is activated the combination “ALT” + “Flecha Down” is used and will appear written in the next cell.

No, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no. no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no,