Just a look at increasing the height or the width or decreasing the width and height of columns and rows. What about hiding a column or hiding multiple columns or rows. I do not want people to see this data. I do not want everybody that goes into the worksheet to see that data or we really do not need that data at this point.
Do not delete it because you want to keep that around. But I will hide a column or multiple columns or rows.
If I go into the worksheet let us say I do not care about January anymore. I want to keep the data around historically we want that data, but I want to hide it Or perhaps there is more sensitive type information than I do not need users to get access to.
This is also useful when you go to print your content whatever is hidden does not print out.
I can do this a couple of different ways.
I am going to select column C. That is the column that I want to hide.
I am going to right click on header of the C column, then select Hide command.
The data still there, Column C is still there. We just essentially took the column with it smashed it.
I can just go right up in between column B and D and C, I get that double headed arrow but it is got kind of a space in between it. If I left click and drag, I can pull Column C back out and there is the data again.
That keeps them from looking at it, but they can still go on hide it. In the book, we will go into the review tab. And then there you have an option for protect sheet. We will talk some more about that.
Or other way, after hide column, If I want to unhide column. I will select multiple columns, right click on any highlight column then select Unhide column
There is so much more you can do here. If you really want to lock that down, you can protect the sheet.
I am going to give you one more little tip, on The Review tab top of your screen right, there is also some show checkmarks out there. One of them is headings. This is something small but if I uncheck that option for headings, I no longer see the ABC column and the one two three rows.
That could also potentially be used here if you are really trying to distract the users and you do not want them to gain access to it.
Again, you get the more advanced users inside of Excel, that can go right back to view turn headings back on.
Really worksheet protection is going to take it much further for us and again just watch for that later in the book.
Try this one out again, you can right click hide. You can just smash them down do the same thing with a row. if you want to show it again You can just drag that back out.
Right click hide, right click Unhide click and drag to increase or decrease the column with or row height and you can hide content.