To unhide column A, right-click the column B header or label and pick Unhide Columns. To unhide row 1, right-click the row 2 header or label and pick Unhide Rows.

How to hide and unhide columns and rows in an Excel worksheet. Restrict access to only the data you want to be seen or printed.

On the Home tab, in the Cells group, click Format > Visibility > Hide & Unhide > Hide Sheet. To unhide worksheets, follow the same steps, but select Unhide. You'll be presented with a dialog …

When you want to reveal cells that may reside in hidden rows or columns, it can be difficult to locate them. The approach is to first select all visible cells in the worksheet, which also will …

Suppose you have a worksheet that contains confidential information, such as employee salaries, that you do not want a co-worker who stops by your desk to see. Or perhaps you multiply the …

When you create an Excel table, a table Header Row is automatically added as the first row of the table, but you have to option to turn it off or on.

If you can't see the worksheet tabs at the bottom of your Excel workbook, browse the table below to find the potential cause and solution. Note: The images in this article are from Excel 2016. …

Right-click any column header, and then click Unhide Fields on the shortcut menu. In the Unhide Columns dialog box, select the check box next to each column that you want to show, and …

If you scroll down your worksheet but always see the same top rows, they're locked in place (frozen). Use the Unfreeze Panes command to unlock those rows.

If some cells, rows, or columns on a worksheet do not appear, you have the option of copying all cells—or only the visible cells.