Excel Today

Usually when we need to create a column of numbers with a certain step, we enter the first two numbers and use the autocomplete token. However, when working with decimal numbers, the result may not be entirely accurate (there will be a deviation in the last significant digit). This can lead to errors in formulas and calculations. To create a series of decimal numbers with the desired precision, you can use a formula that will round the value as you go. Or use the Progression tool to create an arithmetic progression. Also very convenient. Read more about columns in the article

One often hears the question: "How to create a drop-down list for an entire row at once, and not for a separate column in a row?". Usually it is necessary to fill several columns with data at once when selecting a value from the list. Unfortunately, the drop-down list itself does not provide such an option. But the problem is easily solved by formulas. Read more about a drop-down lists in the article

If you often use sheet protection in your files, then you may have encountered such a task. You need to quickly find out in which cells of the range protection is enabled (there is a checkmark "Protected cell" on the "Protection" tab in the "Format cells" window), and in which not. Manually checking each cell is clearly not an option. But you can use conditional formatting and the CELL function, which can check if protection is enabled. Simple, fast and clear. Read more about the sheet protection in the article

A common task is counting working hours over a period of time. If we know the time of the beginning and end of the working day and the number of days, then everything is simple. Multiply the days by the duration of the working day. But if there is a date and time of the beginning of the calculation and the date and time of the end, then the task becomes more difficult. It is necessary on the day of commencement and on the day of termination to take into account only those hours that were working (and the counting can begin and end in the middle of the working day). Yes, and the weekend is also need considering. Read more about the ranges in the article

One often hears the question: "How to create a drop-down list immediately for an entire row, and not for a single column in a row?". Usually this is necessary to fill several columns at once with data when choosing a value from the list. Unfortunately, the drop-down list itself does not provide such an option. But the problem is easily solved by formulas. This option is implemented by the VLOOKUP function or a combination of INDEX + SEARCH. We select one value that serves as a key (unique in the directory) from the list, and simply pull all other data into the table from the directory for the selected key. Read more about dropdowns in article #solo_scripts