- #How to unhide a column in excel mac how to#
- #How to unhide a column in excel mac for mac#
When the pointer changes from the selection arrow to a double arrow - this will happen as the mouse pointer nears the Select All cell - right-click and choose Unhide. Hover the mouse over column B’s header cell and move left.You can also manually click or drag to expand a hidden column. Right-click anywhere within a selected column. Highlight the column on either side of the column you wish to unhide in your document.
#How to unhide a column in excel mac how to#
Now, choose Column from the Format menu, and the choose Unhide. How do I unhide one column in Excel How to unhide columns in Excel Open Microsoft Excel on your PC or Mac computer. Doing so will selecteverything to the left, including column A. Release the mouse with the pointer over the Select All cell (the blank gray cell that intersects the header and row cells). Don’t click any borders, just drag the selection mouse pointer (the fat arrow pointing down).
Click column B’s header cell and drag the mouse pointer to the left. Don’t panic, column A isn’t gone forever, and there’s more than one way to unhide it: Selecting just column B won’t select column A. That works fine until you try to unhide column A, as there’s only one adjacent column, column B. After selecting the hidden column and its adjacent columns, choose Column from the Format menu and then select Unhide. Learn several ways to show all hidden columns in Excel or the ones you select, unhide column A or use a special macro to display hidden columns automatically. You’re really selecting three columns: the hidden column and both columns on either side of it. Select the columns that are adjacent to the hidden column. Unhiding a column takes a bit of specialized knowledge, but it isn’t difficult. To hide a column, select it, choose Column from the Format menu, and then select Hide. The column or row should now be unhidden. In the Cells area, select Format > Hide & Unhide > Unhide Columns or Unhide Rows as desired. SEE: Download: Build your Excel skills with these 10 power tips (TechRepublic) How do I unhide multiple rows in Excel 2016 Select the columns or rows that are before and after the one you would like to unhide. Hiding a column tucks data out of sight without interfering with its function. Even you won’t want to see all of it all the time. Confidentiality aside, sometimes endless data is just a nuisance. 
Not everything in your worksheet needs to be privy to everyone. Fortunately, there are two simple tricks for unhiding it.
#How to unhide a column in excel mac for mac#
The secret to unhiding column A in an Excel worksheetĪfter you hide column A, it might seem like it's gone forever. Learn how you can easily hide and unhide rows and columns in Microsoft Excel for Mac or Windows.Hiding the Columns or Rows in Excel is essentially just sett.
0 kommentar(er)
