The window is hidden.
Press Alt + W + U. The Unhide dialog box appears.
Confirm the workbook to be unhide.
Press Enter. The window has been unhide.
The object is hidden on the sheet.
Press Ctrl + 6.
The object is now redisplayed.
Select the cells in which you want the column data to be reflected.
Press Alt + ↓ (Down Arrow key) to list the column data.
Press ↓ (Down arrow key) several times to select the data you wish to reflect.
Press Enter. The selected cell now reflects the column data.
Please send us your comments on this article.