Working with the tables, users pay priority to entered data, sometimes forgetting the appearance of the document. This is a clear omission, because a beautifully decorated table is necessary not only for better aesthetic perception, but also to understand and catch some nuances in the document. Next, we will analyze some visualization tools for pouring cells, and how to use them.
Filling cells in Excel: basic ways
Filling the cells with color, depending on the internal content, facilitates the process of working and recognizing the necessary information. This technique is especially relevant when working with large tables that contain many data in need of sorting. From this it follows that the color of the color helps to structure the finished document on important components.
Making the documents of minor sizes, you can use the manual method of staining cells. If you need to structure a table that occupies the entire sheet or even more, it is more convenient to use special tools. Even if there are courageous users who want to perform all the work manually, the likelihood is that an error will be allowed in the document. Especially to facilitate such tasks in Excel, the cells are poured with color. How to do this, consider further.
Method number 1: ordinary fill with colorTo perform this task, we will need a tool to change the format of cells. To do this, follow the instructions provided:
- To begin with, determine the cell in which the color will be filling and activate it by pressing the LKM. Perhaps it will be several cells at once.
- In the "Home" toolbar, find the font block. Further actions can be performed by one of the proposed methods:
- To fill in the color of the cell, use the "Fill color" tool, presented in the form of a bucket that performs the fill. By clicking on the icon with a triangle, open a dialog box where you select the desired color.
- If you failed to choose the color of the desired tone shade, then use the "Other Colors" feature. In the window that opens, select one of the color selection methods: according to the presented cellular scheme or in the spectrum. The second option makes it possible to choose a more accurate tone.
- The "Fill color" button saves the last choice. Therefore, if you plan to use the fill with one color in several places, after activating the desired cell, you can click on the button without opening additional windows.
To make the execution of the Excel table did not look like that boring and monophonic, it is possible to diversify the fill by adding patterns into it. Consider the process of performing the task:
- Select one or more cells in which you need to place the color pattern.
- In the Home tab, search for the "Font" block and click on the "cell format" button, located in the lower right corner and represented as a diagonal arrow indicating an angle.
- In the window that opens, go to the "Fill" tab, where in the group "Background color" we select the necessary tone of the fill.
- Next, do one of the following:
- In order to fill in two colors using the pattern, go to the "pattern" field and select the necessary colors. After that, go to the "Pattern" field and determine the design style.
- To use special effects, you need to follow the link "Fulfing Methods" and select the necessary parameters. If the selected parameters are arranged, press the "OK" button.
This method can be used if the cell is selected before the color was made and no other actions were performed. Procedure for performing actions: Select the cells that need to be adjusted, and press the "Ctrl + Y" keys.
If the fill was made, and after that, at least one action was performed, then this method will not work, since the proposed key combination is based on the fulfillment of the latest actions, being a kind of clipboard.
Method number 4 Creating a macroThis method requires a special program of the macrorecorer in which, owning certain skills, you can create macros to perform various actions. In the picture you can see an example code for the created macro.
eightRemoval of cell fill
If you need to remove the previously performed cell filling, then use the instructions below:
- Select cells flooded with color or color pattern that need adjustment.
- On the Home tab, go to the "Font" block. Click on the arrow icon and open the dialog box. Go to the value "no fill" and activate it by pressing the LKM.
Conclusion
There are several ways to fill the cell color. Each of them has its advantages and disadvantages. In some situations, it is acceptable to use the first, faster way to fill, in others it is necessary to pay special attention to the design, then the addition to the patterns is useful.
Message The hot-key fill in Excel appeared first to information technology.