📰 最近消息
Sometimes it's necessary to find out which named ranges are used in the file and what they refer to. This is especially true when you working with another's calculated files.You can get a list of all names with the "All names" command. It is in the Insert Name window. Well, the window itself can be
If you need to hide zeros in a certain range of cells, then it is not necessary to resort to conditional formatting. You can use the number format. It is enough to specify how to display positive numbers, how to display negative numbers, and not to specify anything for zero values. For example, like
In complex computational models, it is sometimes necessary to keep multiple files open at the same time. If you need some of them only for working formulas and general calculations, then you can temporarily hide them, so as not to be confused in the abundance of windows.By the way, this setting is s
Sometimes it's necessary to highlight the cells that form the result of a formula. One way is to use the "Select a group of cells" window.First we select the cell with the formula itself. Then we call this window (you can use the command on the ribbon, or you can press F5 or CTRL+G by calling the "T
And a little more about time in Excel. Time in program is the fractional part of the day. 24 hours is one day, 12 hours - 0.5 days, 1 hour - 1/24 days, etc. Well, of course, we all know that 24 hours equals a day, 60 minutes - an hour, and 60 seconds - a minute. A simple calculation makes it clear t
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
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 a
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
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
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 error