Consider the wording of the OP's question : the word "unhide" appears a few times … the word "show" not at all. Open Address Book, and click on the group or selection of contacts you need exported. #How to unhide a column in excel mac 2008 software#So, use your MAC software to create what you need (for me, I needed an Excel file of my contacts as the service I use for email marketing requires this for uploading): 1. The user will gloss right over the word "Show" as if it isn't there, because the word "Unhide" is right there in his mind's eye, with the capital U and everything (really!), he's visually looking to match it, and "Show" will sometimes not register. Remember that Excel is made by MICROSOFT. One strong recommendation I have for Apache is to change all incidences of the word "Show" to the word "Unhide", as the latter is the word users who are trying to unhide a column for the first time almost invariably look for. click the actual letter up at the top of either column, and there will be a little pop-up menu … choose Show from there and you'll get your column M back. It depends where you are when you set your Freeze Panes. At that point you can just right-click either the L or the N column heading, i.e. There are certain situations when you can’t unhide columns on the left and/or rows at the top and it is not a sheet protection issue. In the above example, you've clicked cell L10 and dragged one step to the right to include cell N10, and you now have cells L10 and N10 selected. Then do your Format ▸ Colu mn ▸ Show.Īs to this last, a much shorter alternative to going through the menus is to simply right-click either of the two column headings above the two cells you have selected and choose Show from there instead. At this point you simply have cells L10 and N10 selected, side by side. So for example if it is column M that's hidden, you would position the cursor in any cell of column L - say, cell L10 - and click/drag one step to the right, i.e. Right-click the selected columns, and then select Unhide. Unhide columns Select the adjacent columns for the hidden columns. Note: The double line between two columns is an indicator that youve hidden a column. Method 2Shortcut Key Select the columns to the left and right of the hidden column. Right-click the selected columns, and then select Hide. Then the minus sign is displayed on the left of selected rows, or displayed at the top of the. #How to unhide a column in excel mac 2008 plus#Select the entire rows or columns you need to hide or unhide with plus or minus sign, then click Group in the Outline group under Data tab. Then press Ctrl + Shift + 9 keyboard combination to unhide all rows, or press Ctrl + Shift + 0 to show all hidden columns.To serve as an additional clarifying post : to unhide a specific column you only need to select across the column, before going to the Format menu and doing your Colu mn ▸ Show. From the hide and unhide option, select unhide columns. Please do as follows to hide or unhide rows or columns with plus or minus sign in Excel. In Excel 2003, choose Column from the Format menu, and choose Unhide. If you want to unhide all rows or columns on a sheet, make sure the whole worksheet is selected. From the Format dropdown in the Cells group, choose Hide & Unhide. Right Click selected cells > Click Unhide to unhide columns. Go to Home tab > Format > Visibility (Hide & Unhide) > Unhide selected column. Part 3: Quickly Unhide All Hidden Rows or Columns First and most important thing when you unhide columns, you need to select the columns where the hidden columns make visible. Right-click the selected column headers and pick Unhide. Hover the cursor on Hide & Unhide option. #How to unhide a column in excel mac 2008 how to#To unhide a column, select the columns before and after the hidden columns. Here is how to use it: Select the columns between which there are hidden columns. Then, right-click on the selection and click Unhide from the popup menu. Since row 3 is hidden, we want to select rows 2 to 4. To unhide a row, just select the row above and the row below the hidden row. Part 2: Unhide a Whole Row or Column in Excel 2016 But you’ll see double lines at column or row headers, which indicates a column or row is hidden.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |