There are many ways to use computers in addition to using the internet, one of these is Office, which allows you to do jobs within the PC. This program has a tool called Excel. This allows us to perform operations and create spreadsheets, but did you know that you can mark a specific color in the cell when you click it?
There are some of the best and most useful keyboard shortcuts to use in Excel, to make the ongoing process somewhat easier.
Maybe many already know this tool and never looked for a tutorial because it seemed silly, but it is not at all like that, Excel is one of the best Microsoft tools that allows you to perform complex operations in a matter of seconds. That is why it is important to know a little more about it.
What is Excel?
Excel is basically a computer program, which works like software allowing you to perform financial and accounting tasks. The idea for this was born in 1989, with the presentation of its product and its subsequent name change to Microsoft Excel (because there was already another company working on Excel).
It is said that this program is very complete, because it allows the customization of the sheets, by programming its own functions that adapt to the user as they see fit and you can also add things such as marking a specific color in the cell by clicking it, taking customization to another level.
With certain mistakes and errors, Microsoft has been changing this program for the better, with updates that eliminate annoying errors of the past and open the door to operations with more complexity.
Such is the case, in addition to the one currently being studied, of creating a monthly calendar generator in Microsoft Excel, mentioning a somewhat related example.
Mark specific color in cell on click
The first thing and not to be confused, to fill a cell with color the Intersect method is not necessary, this is a different method. The first thing is very simple to fill in, you have to select the text to highlight (the boxes), then we go to “START”, and we click ” Fill Color ” (a shortcut is simply to give it Alt + H, H)
Here we choose the color we want and that’s it, like taking a sweet from a baby. Also, there is an option that allows you to use created or custom colors, we click on ” More colors ” and select.
If, on the other hand, we want to place a color in all our spreadsheet at once, we click on the button ” Select all ” (which is the gray corner at the beginning of the sheet), this will hide division lines, but the sheet will become more legible.
Intersect method
First of all, you must know that this method, if it has a little more complexity due to its code language, however, you do not need to be a programming professional to use it either. This method is part, along with marking a specific color in the cell when you click it, of the Excel customization, being as accessible as creating a professional invoice with Excel from scratch.
It consists of returning the cells in common, between two, three or more specified ranges, in their range parameters (this basically represents the intersection of two or more ranges).
This does not work alone, it usually goes hand in hand with any other VBA function such as Worksheet change, which is an event that is fired when we change the content of a cell on a sheet, and executes the catch within it.
Together with the Intersect, we can get it to only fire when we change a specific cell. In other words, it will indicate the code to execute, and that only the content of the specified cell is changed. Which is very useful for setting up a spreadsheet.
As an example the code is placed like this: Interset Range (“A1: B10”), Range (“A1: E1”), Returns Range (“A1: B1”). And done with this you already know two tricks or functions to customize and start creating code in your spreadsheet, marking a specific color in the cell when you click it and the Intersect method.
However, you must study a little more deeply, but with this previous guide, there will be no problem when introducing yourself to the wonderful Excel.