How To Show Or Hide Columns In Excel

Introduction

In this article we will learn how we can show or hide columns in excel. I hope you will like it.

Background

Today I was working in a Report that I am maintaining for myself . It actually contains my debit/credit details of a month. And I was in a need of hiding a column “Credit” from the report and generate a PDF file. And I did that. I thought of sharing you all that. I hope someone may find it is useful.

How to show or hide columns in Excel

To do so, we will create a dummy excel file as follows.

Show Hide Columns In Excel

Now it is time for action.

Click on the home tab, and go to Format menu.

Show Hide Columns In Excel

Now click on the format menu, and then click Hide&Unhide under visibility menu. Now click on hide column.

Show Hide Columns In Excel

Now if you see your excel file, you can see the selected column has been hide.

Show Hide Columns In Excel

To make it show, you just need to follow the same procedure that we just followed now. You can see an Unhide option in the same Hide&Unhide menu.

Show Hide Columns In Excel

Conclusion

That is all. I hope you liked this article. Please share me your feedback.

Kindest Regards
Sibeesh Venu

Leave a Reply

Your email address will not be published. Required fields are marked *

Serverless 360