![how to unhide a column in excel in windows how to unhide a column in excel in windows](https://www.jquery-az.com/wp-content/uploads/2019/07/52.6-Excel-unhide-row-home.png)
Both of these settings can often make it appear that a row or column is hidden when it is simply off screen. You may want to consider unfreezing the panes in your worksheet, or removing a split screen. If you are still unable to see the first column of the worksheet, then it may not actually be hidden. Need more help You can always ask an expert in the Excel Tech Community or get support in the Answers community. Or double-click the double line between the two columns where hidden columns exist. Step 6: Click the Hide & Unhide option, then click Unhide Columns.Ĭolumn “A” should now be visible in your spreadsheet. Right-click the selected columns, and then select Unhide. Step 5: Click the Format button in the Cells section of the Office ribbon. Step 4: Click the Home tab at the top of the window. Step 3: Type “A1” into this field, then press the Enter key on your keyboard. Step 2: Click inside the Name field at the top-left of the spreadsheet. Step 1: Open your spreadsheet in Excel 2010. If you wish to unhide all of the hidden columns in your spreadsheet, then you can follow the steps here. Typically, when a user wants to merge cells, they are trying to place longer headers in one cell (such as January Actual Sales). Merging and combining data are two different things. You can also access merge commands by right-clicking or using keyboard shortcuts.
![how to unhide a column in excel in windows how to unhide a column in excel in windows](https://cdn4syt-solveyourtech.netdna-ssl.com/wp-content/uploads/2012/06/hide-columns-in-excel-2010-2.jpg)
If there are other hidden columns, they will remain hidden. In Excel, you can merge cells using the Ribbon or the Format Cells dialog box.
![how to unhide a column in excel in windows how to unhide a column in excel in windows](https://www.addintools.com/documents/excel/where-is-unhide-command/excel-unhide-command-menus-445-487.png)
The procedure below will only unhide column “A”. The steps in this article will assume that you have hidden the first column in your Excel spreadsheet. An alternative would be to simply unhide all of the columns that are hidden in the spreadsheet, but this can be problematic if there are other columns that you wish to remain hidden.įortunately it is possible to unhide only the first column in your spreadsheet by following the procedure outlined below. The typical method for unhiding a column will not apply when the column that is hidden is the leftmost one in the worksheet. Unhiding the first column, or column “A” in an Excel spreadsheet presents a unique challenge.