Drag to select the column or row header buttons on either side of the hidden column or row. Click the Home tab. Click the Format button. Point to Hide & Unhide, and then click Unhide Columns or Unhide Rows.