Tutorial How to Hide Columns or Rows in Microsoft Excel
Those of us who work daily using Microsoft Excel must have experienced a condition or a situation where we have to hide some things that we think are disturbing on our worksheets.
For example, maybe we have some reference worksheets which contain extra data but unfortunately they don’t need to be seen. Or another example of a situation is if we have several rows of data located at the bottom of the worksheet where we need to hide the data.
There are many different parts to a spreadsheet Excel, where each of these sections can be hidden in a different way.
Well, this time I will share about how to hide columns or rows very easily. how do? Just follow the steps on how to hide columns or rows in Microsoft Excel below.
How to Hide Columns or Rows in Microsoft Excel
The method that I share this time is using Microsoft Excel with version 2021. However, if you are using another version, you can still use this method. More or less the method must be the same as other versions of Microsoft Excel.
A. Using the Fast Way
1. First, please you column or row block that you want to hide. As in the image below.
2. Then, please you right click on column or row it, and click “Hide”. As in the image below.
3. Tadaaaaa…. the column or row you selected earlier will be hidden. As in the image below.
B. Using the Format Menu
1. First, please you column or row block that you want to hide. As in the image below.
2. Then, please go to the menu Home which is at the top. As in the image below.
3. Then, please click the menu Format. As in the image below.
4. Then, please click “Hide & Unhide”, and click “Hide Columns” to hide column and “Hide Row” to hide rows. As in the image below.
5. Tadaaaaa…. the column or row you selected earlier will be hidden. As in the image below.
Then, Can We Restore Columns or Rows That We Have Hidden?
Surely you can. We can also restore the column or row that we have hidden. How do you do it? Just follow the steps below.
A. Using the Fast Way
1. First, please click right on the column or row that you hide or click between the columns that appear. As in the image below.
2. Then, please click “Unhide” to bring it back. As in the image below.
3. Done. Your column or row will reappear. As in the image below.
B. Using the Format Menu
1. First, please click on a column or row that you hide or click between the columns that appear. As in the image below.
2. Then, please go to the menu Home which is at the top. As in the image below.
3. Then, please click the menu Format. As in the image below.
4. Then, please click “Hide & Unhide”, and click “Unhide Columns” to display the column and “Unhide Rows” to display rows. As in the image below.
5. Done. Your column or row will reappear. As in the image below.
Well, how? The method is quite easy and very simple right? Now we can hide and show back the column or row you want. So, we don’t need to be afraid or worried anymore, if our column or row doesn’t want to be seen or don’t want to be edited by anyone.
That’s how to easily hide columns or rows in Microsoft Excel that you can try. If this article can help you, please share it with your friends so they also know how to Hide Columns or Rows in Microsoft Excel easily. Hopefully this article can be useful for all of us. If there is a writing error, please forgive me. Thank you
The rain lover and coffee connoisseur who likes to sit in daydream while dreaming of his dreams that will come true.
Post a Comment for "Tutorial How to Hide Columns or Rows in Microsoft Excel"