Under the “ Cells” group, locate the “ Format” button and press the small arrow to open its menu. If you are comfortable using the ribbon for performing tasks rather than using contextual menu (right click) then this is how you may unhide the hidden columns. Third way: Using the Home menu in the ribbon You may also unhide the hidden column by double clicking the double line or drag the line towards right. If you look closer at the column lines after hiding a column, you will notice those are double lines and look a little thick than normal columns. Second way: Unhide by double line example Right click on either C or E column and press the “Unhide” option in the menu: In our example, we have C and E adjacent columns to the hidden D column. To unhide the single column D by using right click, follow this: I have hidden the column D for the demo as shown in the graphic below: The first way to unhide the hidden column is using the right click option.įor the example, I assume that you have already hidden a column. Unhide a hidden column by right click example Fourth Way – Using shortcut key to unhide all columns
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |