UN Adopts New Global Rules To Reduce Chemicals Harm

About How To

I have a spreadsheet I created with my old computer that had Excel on it. There were a couple columns that I didn't need to see at the time so I hid them to make it easier to see everything. I'm now using the Excel web app, those columns are still hidden and being able to see them would be useful now. Any way to hideshow in the web app?

If you want to unhide all hidden columns on an Excel spreadsheet, click on the quotSelect Allquot button, which is the blank rectangle to the left of column quotAquot and above row quot1.quot You can then proceed with the remaining steps in this article to unhide those columns.

As you double-click, Excel shall unhide the last column of the hidden columns group. For example, if B, C, and D columns are hidden, column D shall show up first, then column C, and finally column B. Also, when you use this method, Excel shall autofit the column according to the lengthiest text or number of the column. Unhide Columns by Dragging

4. Use a VBA Macro to Unhide Columns. Alternatively, you can use a VBA macro code to unhide all the hidden columns at once. Here's the sample VBA code you can use and how to apply it.

Unhide columns. Select the adjacent columns for the hidden columns. Right-click the selected columns, and then select Unhide. Or double-click the double line between the two columns where hidden columns exist. Need more help? You can always ask an expert in the Excel Tech Community or get support in Communities. See Also

The other unhide Excel column shortcut available to unhide columns is Ctrl Shift 0. However, it works for a non-numeric keyboard. 3. Context Menu. Here are the steps to apply the Unhide function from the context menu. Step 1 Select the column headers of the visible columns on either side of the hidden columns.

How to Unhide All Columns in Excel Using the Format Tool. You can Unhide all columns in Excel using the format tab. Follow the below steps to unhide all columns in Excel Step 1 Open the Excel File with Hidden Columns. Open the excel file with hidden column. Here in the given excel sheet, A is the hidden column. Open the Excel File

How to unhide a column in Excel web version

These steps will also work in other desktop Web browsers like Microsoft Edge and Firefox. Now that you know how to hide and unhide columns in Excel Online, you can use these steps to easily control the way that data is displayed inside of your spreadsheet. How to Hide a Column in Excel - Alternate Method

Select the column headings to the left and right of the hidden columns. To unhide all columns, click the box to the left of the A and above the 1 on the worksheet or press Ctrl A twice if necessary. Right-click and select Unhide from the drop-down menu. To unhide a column or columns using a keyboard shortcut