How do I unhide a column in Excel that is greyed out?

How do I unhide a column in Excel that is greyed out?

Replies (4) 

1. CTRL+A to select entire worksheet.
2. Right click on any row number and take unhide.
3. Right click on any column number and take unhide.

Why can’t I hide columns in Excel?

Click File > Options > Advanced. , and then click Excel Options. On the Advanced tab, scroll to Display options for this workbook settings. Under For objects, show, select All instead of Nothing (hide objects).

How do I unhide a greyed out cell in Excel?

If you go to Format>Sheet>Hide and the UnHide is greyed out this means there are no Worksheets hidden within the Workbook. If there are sheets hidden the Hide will not be greyed out and selecting it will display the Unhide dialog box.

How do I hide a column in a query?

To preserve the hidden columns after refresh, you should select one of the cells in the table, then in the Design contextual tab, click Properties, and in the External Data Properties window, check Adjust column width, and click OK. Now hide the columns, and save your workbook.

Why is switch row column greyed out?

PowerPoint has chosen to group the data by category instead of by year. The way to fix this is to switch the rows and the columns. The problem is that the Switch Row/Column button on the Chart Tools Design tab is grayed out. Apparently, you have to edit and select the data to switch the rows and columns.

Why is unhide greyed out?

If the Unhide command is grayed out both on the ribbon and in right-click menu, that means there is not a single hidden sheet in your workbook 🙂 This is how you unhide sheets in Excel.

What is the shortcut for hiding columns in Excel?

There are several dedicated keyboard shortcuts to hide and unhide rows and columns.

1. Ctrl+9 to Hide Rows.
2. Ctrl+0 (zero) to Hide Columns.
3. Ctrl+Shift+( to Unhide Rows.
4. Ctrl+Shift+) to Unhide Columns – If this doesn’t work for you try Alt,O,C,U (old Excel 2003 shortcut that still works).

How do I unhide all rows and columns in Excel?

How to unhide all rows in Excel

1. To unhide all hidden rows in Excel, navigate to the “Home” tab.
2. Click “Format,” which is located towards the right hand side of the toolbar.
3. Navigate to the “Visibility” section.
4. Hover over “Hide & Unhide.”
5. Select “Unhide Rows” from the list.

How do I GREY out a section in Excel?

Select the cells in column A you want to grey out, click Home > Conditional Formatting > New Rule. 3. Click OK > OK to close the dialogs. And the cells have been greyed out based on another column values.

How do you hide or unhide a query?

Hide and unhide objects and groups

1. Right-click the menu bar at the top of the Navigation Pane, and then click Navigation Options.
2. In the Navigation Options dialog box, clear the Show Hidden Objects check box, and then click OK.

How can you hide a column in MS Access?

Hide columns

1. Click the heading for the column that you want to hide. To select adjacent columns, hold down SHIFT and click additional column headers. Note: You cannot select nonadjacent columns.
2. Right-click the column header, and then click Hide Fields on the shortcut menu.

Is there a way to hide columns in Excel?

You need to unmerge the cells to hide the column or hide all the columns which the merged cell (s) span. You can test this by adding a new column to the end, then selecting all the other columns and the Hide Columns option will be enabled.

Is the hide and unhide column Disabled in outlook?

Now, with right-click to column heading hide and unhide are in grey color and can not be used. Tried as well Format/Column but there column is also in grey color and disabled for use. Please advise. Many thanks!

Why is the hide and unhide button not working in Excel?

If you forgot your password, you can reset your password . With all of my Excel worksheets, I can not use hide/unhide of columns. That function worked properly until today. Now, with right-click to column heading hide and unhide are in grey color and can not be used.