Hidden columns or rows can be displayed using the mouse or with the Format menu commands.
With the Mouse
The mouse may be used to display hidden columns or rows. To display a column, first click on the vertical dividing line at the right of the hidden column and then drag the vertical dividing line to the new position. If several adjacent columns are hidden, only the far right column is displayed after dragging the dividing line. If the cursor is to the left of the vertical dividing line when the line is selected, then the selected vertical dividing line will be for the visible column to the left and not for the hidden column.
To display a hidden row, first click on the horizontal dividing line below the hidden row and then drag the horizontal dividing line to the new position. If several adjacent rows are hidden, only the bottom row is displayed after dragging the dividing line. If the cursor is above the horizontal dividing line when the line is selected, then the horizontal dividing line is for the visible row above the hidden rows, and not for the hidden rows.
Example
If columns B, C, and D are hidden and columns A and E are visible, then one vertical dividing line appears between columns A and E. Select that vertical dividing line with the cursor slightly to the right of the dividing line. This selects the line for column D. (If the cursor is to the left of the dividing line, then the dividing line for column A is selected.) Drag the vertical dividing line to the right to unhide column D. Repeat for columns C and B.
With the Format Menu
Hidden columns and rows can also be displayed with the Data | Format | Column Width and Data | Format | Row Height commands. To display hidden rows or columns, select the columns or rows on both sides of the hidden columns or rows, select Data | Format | Column Width or Data | Format | Row Height, and then set the width or height to a number greater than zero.