Users who want to handle a spreadsheet perfectly will need to know all the secrets that the tool has to add borders and colors.
Which will make the work be done in less time and the results, to expose the information, are consistent with a professional style. In addition, this will allow generating different types of design to Excel documents.
In order for you to become an expert and make spreadsheets perfectly, you will have to read the following paragraphs. We will show you the steps you must do to modify borders and colors to cells, rows, columns and graphs.
What elements in a spreadsheet can I add borders and colors to in Excel?
One of the reasons you should use borders on a spreadsheet is because it provides a unique layout for tables and any other illustration that is used to expose the information.
This is because different colored borders can be added to cells, letters, columns, rows, and graphs . There is a large number of designs that can be chosen, which allow you to change, not only the color of the lines, but also the thickness and quantity of them.
Border styles What are all the border styles that I can add to my spreadsheet?
You must bear in mind that the styles that we will show you are taken as a reference from the selection cell you have chosen. The types of borders that you can add to a spreadsheet are as follows:
- Lower: it is one of the most used and that is why it is in the first place. It is useful when you want to set column titles, you can also use it when you want to expose the total of a column at the end of the data.
- Superior: you can also use it in the same way as the previous one, but in the reverse situation. Both edges have a fine line that provides a clean style to the pictures and information on display.
- Left: This type of border is used when you want to detail and separate horizontal concepts in a table or in the construction of forms.
- Right: corresponds to the same situation of the leading edge, but can be used in situations in which the design of the table or table ends.
- All borders: when you have a table with many columns and rows and the information that exists can make the reader dizzy, it is necessary to use this type of border. With this tool you are going to limit all the cells that exist in the selection.
- External borders: if you have information in a box and you want to highlight it only on the outside, you will have to use this design. It is the opposite style to the leading border since it does not mark the internal cells, it only makes lines at the border of the selection.
- Thick exterior: fulfills the same function as the leading edge, but the line used for this design is thick.
- Bottom double: in case you need to highlight a selection with a double line at the bottom, you have to use this type of design.
- Thick bottom: if what you need is to place a line that is much thicker than the common one to place it at the end of the selection, you will have to use this type of border.
- Upper and lower: there are tables that do not need to be demarcated on their left and right sides, so this type of border is very useful when there are cases in which you want to give an elegant style so that the user can have a good reading.
- Thick top and bottom: have the same functions as the leading edge, but in this case the bottom line is double thick.
- Double upper and lower: the same happens as in the last 2 designs with this type of border, but in this format both lines are thick.
Learn step by step how to modify the colors of your spreadsheets
Microsoft Excel displays by default the lines that exist at the intersection of the columns and rows. Therefore, the style it has is transparent, but if you want to modify this you can do it with very simple steps.
Pay attention to the following guides:
To change the colors of the letters you must follow these steps:
- Select the cells you want to change.
- Right click on the selection and choose the option “Format cells …” .
- Go to the “Source” tab .
- Look for the “Color” option .
- Click on the arrow to display the color palette. When you have chosen the one you like the most, you will have to select “Accept” .
In case you want to modify the colors of the cells, do the following:
- With the mouse choose the cell, or the set of them, that you want to modify.
- Go to the Home tab and find the “Font” group of functions .
- Select “Fill Color . “
- When you click on the drop-down menu, you will have to choose the tone that you like the most from the color palette.
In case you do not want to have a complete fill color and you need to give it a different style, you should follow these steps:
- Once you have selected the cells you want to edit, right click on them.
- Find the option “Format cells …” and click on the “Fill” tab .
- Then click on “Fill Effects …” .
- You will have to choose if you want a color or colors, so you will have to select them by displaying the arrow at the end of the “Color 1:” and “Color 2:” fields .
- Then you must choose the shading style. This means if you want to do it in a horizontal, vertical or other way.
When you have graphics and you want to change the color, you will have to do this step by step:
- Click on it. You will see that the angles turned into white dots.
- Next, right click and select the “Fill” tool , which will appear independently next to the illustration.
- Choose the one you need from the range of colors. You can also give it a gradient effect, choosing the option that bears that name.
If you prefer, you can change the fill for an image that you can choose from your computer or from the Internet. For this, you will have to choose the “Image” option , after you have clicked on “Fill” .
Steps to insert borders to your spreadsheets and make them more dynamic
The steps that we will show you below can be done with any type of edge. Let’s see what you should do:
- Choose the cell, rows or columns to which you want to add a border.
- Click on the “Home” tab .
- In the “Font” group you will have the “Border” tool represented by a box.
- Click on the arrow to open the menu.
- Choose the border style that suits you best.
In case you have a table with different types of borders and you want to add some, but if you use the default you will modify the sense of the form, you will have the option to draw the border manually.
To do this you will have to choose the “Draw borders” function and in this way you will be able to drag the mouse through the places where lines need to be incorporated. You can also draw grids quickly by simply hovering over the different sectors. You must bear in mind that this function will remain activated until you click on it again.
If for some reason you make a mistake and want to erase an edge, you will have to use the “Erase Edge” tool . As with “Draw borders”, this function will remain active until you click on it again.