Creating Rows, Columns & Borders: Part 2

Video Transcript

"Hi, I’m Gary with Expert Village; now we can do the same thing for each column as well, we can go ahead and select the columns that we want to change the width and we will go ahead and click on format. This time click on columns and we will see that we have an option to change the width and again it asks us to fill in the width of each column. So I’m going to go ahead and just put a default of fifty and we’ll hit ok. And we’ll see our column, that was a little big, we’ll see our column has really opened up very, very wide and here is column “A” and we’ll see here is column “B” and each one is fifty. That’s a little bit too wide, so I’m going to go ahead and change it, we’ll hit columns again and make the width. Let’s say instead of fifty, we will make it fifteen and then we’ll hit ok and we see that our columns are, they were increased a little bit but not as much as we previously did and we see that we have a lot of space here to put in our numbers next to the, next to our entry. The column is wide enough that we could even put bigger numbers so that’s the way to change the width of each column. Now when the items are not selected, we see they’re, we see the grid here of cells, we see the lines that separate each cell but you should know that those lines are not going to appear when we print the document. So what we want to do in order to format our document to have it separated by lines or to show the grid, we select the area that we want to have separated by lines and then we go ahead up here and we choose where there is a little, a little button over here that looks like a four square checkerboard. That is our option for borders, and we click on the arrows next to it so that it scrolls down and we see that we have a whole bunch of options of what type of borders that we want to show. So here is the, what is selected by default is no borders, and here we can have a border, the bold line is on the bottom, so that would give us a border on the, on the bottom of the table that is selected. If we click it, we see now that we have, it’s maybe a little bit hard to see but this line over here is in bold, and if we want the whole area to be selected to be, for each cell to be separated by its own border we go ahead and click the arrow and here we have a full, full grids will be shown. We see that everything is bolded and we go ahead and click on it and now all of our lines appear on the table and we see that everything, we un-select everything, and we see that there is a little bit of darker lines around these entries. That’s going to be the grid that appears when we go ahead and select this option up here. So those are some ways of simple, simple ways of just changing the look of our worksheet. "