Now it is the turn of the Excel sheet, which belongs to the Microsoft Office suite and we can only say that it is a real marvel.
Of course, when you know how to use its different functions and macros. Since we know that there is still a great lack of knowledge about this program, we will show you how to put negative values or numbers in red in Excel quickly and easily.
When we carry out administrative or accounting work, there will necessarily be a time when we will have to enter negative values on our spreadsheet. That it may be necessary to indicate them not only with the negative sign (-) but also with some other format that quickly indicates that we are in the presence of negative numbers.
Well, we will achieve it by putting these values in red and we will teach you, as it is a very simple and quick procedure to do. In addition to recording the date and time of changing data or cell records in Excel. So, keep reading so that you know the steps for make negative values or red numbers in Excel quickly and easily.
How to put negative values or numbers in red in Excel quick and easy
Excel offers us many different ways to be able to highlight these negative numbers, they can be in black with negative sign, in red with negative sign and it is possible that they can add parentheses. So to be able to put negative values or numbers in red in Excel in modo easy and fast. We will show you how to do it manually first.
First let's go to our spreadsheet and we will select a cell or a range of cells, once done and they will be highlighted. We will right-click and in the context menu that appears, we will choose the Format Cells option. This action will allow your window to appear with different tabs.
Read How to buy airline tickets without a credit card
Now we will choose the Number tab, on the left side we will see different categories but we will choose the Number category. Now on the right hand side it will show you the options for representing negative numbers. You can choose one of the three options it offers you, negative number in bold , negative number in red or red number.
For our particular case we can choose the options, number in red without negative sign or number in red with negative sign. This is already something that will depend on you and how you interpret the data. Finally, we just have to click on the OK option, henceforth all negative data in this or these cells will take this format.
How to make negative values or numbers red in custom Excel
Now, if we want to have absolute control over the format that the data should have in our spreadsheet and then customize it to our liking, we need to do the following. We will position ourselves on a cell, then we will right click and in the context menu we will choose the option Cell format.
Now in the cell format window, we will choose the Number tab and now on the left side in the Category section, we will choose Custom. Now we will focus our attention on the right side and here we will see the different formats to choose from. You can choose a few and you will check if it fulfills what you want.
Remember that when you make a choice, you have to click OK, this way the choice will be applied. You can see how simple and easy it can be to give your number cells a personal format. And how easy it was to learn to put negative values or numbers in red in Excel quickly and easily.
Read How to animate a character to simulate walking in PowerPoint (example)