First off let's take a look at how we can hide and unhide rows and columns and also how we can find
which rows or columns have been hidden. Hiding is easy.
All you have to do is highlight the row you want to hide, right mouse click, and select hide.
You can do the same for columns. Just highlight the column or just drag your mouse to highlight many
columns, right mouse click and hide.
Now let's say you received this worksheet and you quickly want to see is there any rows or columns that
have been hidden.
You can't easily see that if you look closely you'll notice that you see that double border here.
That's an indication but you can't visually quickly see that something is hidden.
If you're just looking in this area. If you highlight all the cells by clicking on this side box up here
you still don't notice anything has been hidden.
Here's how you can notice. Go somewhere within your dataset.
If you're looking for hidden rows or columns in that data set, highlight it.
So we already learned the shortcut key control+a then go to Home > Find and Select > Go to Special.
Now the shortcut key you can get there is control+G.
Once you're here, select visible cells only and then click on OK.
Now you see some bright lines going through your data set.
This is a visual indication that something was hidden here.
To unhide, you can select only that area or select all the columns or all the rows, right mouse click and unhide.
Repeat that for the rows.
Let's highlight this area, right mouse click, unhide. If you want to do that for your entire workbook
you can as well. Let's just hide something here.
You don't need to make any previous selections first. Just go back to Go to Special. Press control+G
alt+s, Y to select visible cells only. Press enter and you see that visual indication right here.
Now let's take a look at inserting values in between other values.
So if I wanted to move voltage and I wanted to move it between Halotot and Flowrrr.
One way to do this is through right mouse click and cut it or do control+X, go here, right mouse click and
select Insert cut cells.
There is another way you can do this.
I'm going to press control+z to go back. The other way is to highlight your row and then drag this down.
But what happens if I let go here
It wants to replace this data set.
That's not something I want to do.
I want to drop it between these two data sets.
So when you're dragging this hold down the shift key. This highlights the border in between
and this way just let go of your mouse and it drops it in between those two lines.
Okay so drag, hold down shift,
Let go of the mouse, and then let go of the shift key. Let's quickly talk about adjusting columns
and rows.
So if for some reason your columns are too small to show the numbers you're going to get this pound
sign.
This doesn't mean there is an error in there.
It only means it's too small to show the number inside.
So just make it auto fit by double clicking on the border here.
Now you can also set specific cell widths. If you highlight the columns you want to set.
Just right mouse click and go to the column width. Here you can type in the exact
width that you want and then click on OK.
If you like a specific width and you want it applied to other columns you can copy the entire column
and here's the thing, so I'm copying the entire "I" column, I'm going to go to "K", right mouse click and go
to paste special. Don't select paste because that's going to paste the values and everything in there.
Go to paste special and select column widths.
So notice when I press Okay the "K" column becomes as wide as the "I" column, so you can do the same thing
for rows as well.
You can highlight many rows or hold down control and highlight different rows, right mouse click, go to
row height and set a specific row height. Let's go with 15 here and that's going to adjust them slightly.
Here's a bonus tip for you. Instead of hiding rows and columns
you can also group them.
The advantage of grouping over hiding is that you can visually see that something was hidden.
Let me show you.
Let's just highlight these two columns.
Go to the data tab.
That's where the grouping option is. On the right
here you see these outline options.
Just click on group. You automatically get this line here with the minus icon.
When you click the minus icon it's going to collapse those columns.
But if someone takes a quick look at this worksheet they notice something is hidden because they're
going to see this icon up here.
You can apply grouping to different columns as well. Just highlight them and click on group.
Notice that we also get this one and two here.
These are the levels of grouping that you have. Because you can also add a grouping within another grouping.
To collapse and open all groupings in your columns,
You can click on the 1 and 2 or you can individually open the groups that you need.
You can do the same thing for rows, so let's just highlight these and group the rows and we get the same
icons in here. To ungroup,
you can either ungroup specific sections.
So let's say I want to ungroup this,
just highlight it and click on ungroup. To ungroup all columns,
Highlight your cells by clicking on the icon up here and then click on ungroup.
You get the choice of ungrouping your rows and columns so let's ungroup all rows again and let's go back
and ungroup all columns as well. So that's how you can manipulate data in rows and columns. In the next
lecture.
Let's take a look at the different options we have when we use paste special.