Right click on any of the cell of column B or D and press Hideoption as shown in the first example. This is how columns B and D look after we selected: If you want to hide more columns then keep pressed the Ctrl key and select those columns. Press the Ctrl key in the keyboard and select the column “D”. Select the B column by clicking on the letter “B”. Suppose we want to hide the columns B and D. However, if you want to hide two or more columns that are not adjacent by a single click, follow this. Hiding multiple columns by single click exampleīy following the above method, you may hide as many columns as you want one by one. You can see, the D column is disappeared. For our demo, I selected the D column and clicked on the Hide option in the menu, after right clicking on a cell and see the result: Now, right-click on any cell of that column and click on the “ Hide” option in the menu: It should select the whole column as shown below: Select the column that you want to hide by clicking on the letter: A, B, C etc. Similarly, to unhide the hidden row or column, you need to press the Unhide menu item after right-clicking on the adjacent row or column I will show you how with screenshots in the section below.įor hiding one column in Excel, follow these steps. Hiding the rows or columns in Excel is just the matter of right clicking on the column letter or row number and pressing the Hide option in the menu.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
February 2023
Categories |