Microsoft‘s is one of those programs that is not lacking in almost any PC, especially in the business environment. And if it’s not Excel, we come across some other similar spreadsheet-centric solution. Now we are going to see how to improve the visibility of the data contained in the cells of the aforementioned Excel.
As surely most of you will already know first-hand, here we are going to find a huge amount of numerical data. The program actually offers us everything we need so that we can operate with them in the best possible way. But that’s not all that is important in this show. Since we must also do our part. With this, what we want to tell you is that we can try to design and structure in the best way that data that we handle here.
This is something that becomes especially important in the case that we normally work with large spreadsheets. If we do not design them in a convenient way, your consultation, change or treatment can turn into a nightmare . And it is precisely in this that we are going to help you along these same lines. Serve as an example of design in Excel, adding a little extra space to the cell boundaries.
As you can imagine, this in such a simple principle can greatly facilitate the reading of the data in a spreadsheet. Therefore, in the event that you want to add an extra blank space between the text and the borders of the cells, here we are going to talk about how to do it.
Add space between the sides of cells
If what we need to improve the readability of a spreadsheet is to add an extra space, let’s see the possibilities we have in this regard. In the event that you are looking for a way to add a blank space between the borders of a cell and the data it contains, we will have to align the text or numbers using an indentation.
Select Excel cells to format
So if you format your cells to do this, you will have an extra space between the border of the cell and the beginning of your data. You can already imagine that this is very useful to improve the visualization of the data.
Well, to start with what we tell you, the first thing is to open the Excel spreadsheet. Then we have to select with the mouse the cells that we want to change so that their content can be better seen. Once marked, we click with the right mouse button on the cells that we have selected and we opted for the Format cells option.
This movement will give way to a new options box called Format cells from which we have the possibility to edit a multitude of elements on the sheet. We can change parameters such as the type of number of the cell, up to the style of the font. But in the case that concerns us in this case we opted for the Alignment tab.
Add indent to the sides of cells in Excel
Here we find some drop-down lists, so we open the one called Horizontal in the Text Alignment section. Thus, to obtain an extra space between the text of the cell and the left or right border of it, we click Left (indentation) or Right (indentation). In fact, we can opt for the Distributed option (Indentation) to have the same space between the text and the cell borders on both sides.
Now we only have, in the Indentation section, specify the size of the additional spacing. We just have to click on the up and down arrows or write the numerical value in the box. Once the change is ready, we click the OK button to save the changes. Say that this extra space between the text and the borders of Excel cells will be applied to the selected cell range.
Of course, we must bear in mind that this will not only be useful for the sides of the cells, but that we can also use it with the upper and lower edges, Therefore, if what we need is to add an extra space between the text and the top and bottom borders of cells, let’s see how to do it.
More space between the edges of the top and bottom cells
Actually the process is very similar to what we saw before. Therefore, the first thing we do is select your range of cells within the spreadsheet. Once we have marked them all, we click with the right mouse button on the selection and we opt for Format cells.
Again we go to the tab called Alignment, but in this specific case we focus on the drop-down list “called Vertical. Among the options that it presents, we can opt for Superior. This helps us to align the data in the cell with the upper part of it If we choose Center we make sure to add an equal space between the top and the bottom, so it may be the most interesting.
Now, depending on the option we have chosen, the data in the cell will be aligned with respect to the option chosen. If we have chosen the Center option, the text will be aligned in the center of the cell.
Anyway, if you prefer you can always combine the horizontal and vertical alignment of the text for the Excel cells and thus obtain even better results. Everything will depend on the quantity and size of their contents. In addition, this allows us to apply an additional space between the data in its cell and each of its edges, both lateral, upper and lower. It is true that it may take us a while to adapt all this that we have told you, especially if it is a large leaf. But in time we will appreciate it when the data inquiries arrive, or when we return to work in the future.