How To Hide Or Unhide Columns In Excel For Mac
linmax wrote:
Unhide Columns in Excel using a Macro: If you want to unhide your spreadsheet columns by using a code then you can use the following macro for this task: Sub UnhideAllColumns ActiveSheet.Cells.EntireColumn.Hidden = False End Sub This small macro will unhide all the hidden columns in your active worksheet.
However i do have and want some merged cells. Was ready to learn Numbers but will go out and buy Excel. It's easier.
I am a daily user of both Numbers and Excel. Excel is a really good app too. It makes some things easier than Numbers. And Numbers makes other things easier.
However, my advice on merged cells is the same for Excel as for Numbers. Unless you're just using the spreadsheet app as a word processor or layout program, without out trying to use it to do calculations it was designed to do, don't merge cells! They're trouble, and cause problems such as the one that brought you here asking for help. Achieving the same visual effect via other means (just uncheck 'Wrap text in cell' and turn off a cell border or two) is so easy that there rarely is a need to rely on merging cells.
SG
Shutterstock
- You can easily hide and unhide columns in Excel by individually revealing hidden columns or using the „Format“ option to unhide all hidden cells.
- Hiding columns is helpful, especially when working in large documents or hiding information you won’t need until later, but don’t want to delete.
- Visit Business Insider’s homepage for more stories.
You can easily hide columns when working within an Excel spreadsheet — and just as easily unhide them.
Excel is great for sorting large amounts of data, whether it involves alphabetizing, adding, or merging cells. While organizing this data, you may find it helpful to hide columns you are no longer using, but don’t want to delete from your document.
You can hide, and later unhide, columns by right-clicking in the spreadsheet. You can also achieve this by using the drop-down menu in the home tab.
Here’s how to do both.
Check out the products mentioned in this article:
Microsoft Office (From $139.99 at Best Buy)
MacBook Pro (From $1,299.99 at Best Buy)
Lenovo IdeaPad 130 (From $299.99 at Best Buy)
How to hide columns in Excel
1. Open Microsoft Excel on your PC or Mac computer.
2. Select the column you wish to hide. Select an entire column by clicking on its corresponding letter at the top of the page.
Best mac appplication torrent site. 3. Right-click anywhere in the column.
4. Click „Hide“ from the menu.
How to unhide columns in Excel
1. Open Microsoft Excel on your PC or Mac computer.
2. Highlight the column on either side of the column you wish to unhide in your document. Select multiple columns by clicking on the letter at the top corresponding to each column and holding the shift key.
3. Right-click anywhere within a selected column.
4. Click „Unhide“ from the menu.
5. You can also manually click or drag to expand a hidden column. Hidden columns are indicated by a thicker line. Move your cursor over this line until it turns into a double bar with arrows. Double click to reveal the column or click and drag to manually expand the hidden column.
How to unhide all hidden columns in Excel
1. Open Microsoft Excel on your PC or Mac computer.
2. To unhide all hidden columns in Excel, navigate to the „Home“ tab.
3. Click „Format,“ which is located towards the right-hand side of the toolbar.
4. Navigate to the „Visibility“ section. You’ll find options to hide and unhide both rows and columns.
5. Hover over „Hide & Unhide.“
6. Select „Unhide Columns“ from the list. This will reveal all hidden columns, a feature especially helpful if you’ve hidden multiple columns throughout a large spreadsheet.