We’re a team of problem solvers, world travelers, idea guys, and doers, working to make using Excel on a Mac a better experience. That’s enough about us - whether you are new to Excel for Mac or an experienced user, you probably want to spend less time manipulating data and more time thinking. The will help you do that. If you are a PC user hesitant about switching to Mac because you don’t want to give up your customized menus and shortcuts, well, the just might be the myth-buster you need. Excel for Mac is just as capable as it is for the PC.
This is the most easy way to unhide columns in excel. Follow the below steps to use this method: First of all select one column on either sides of the hidden column. Now, with all these columns selected right-click on the column header. This will open a popup menu, select the ‘unhide’ option and the hidden columns will be visible. As Excel does not support you with one option to unhide all the hidden workbooks in bulk, you can try the Unhide All Windows utility of Kutools for Excel. With this utility, you can show all hidden windows at the same time quickly.
![Unhide Column In Excel For Mac Unhide Column In Excel For Mac](/uploads/1/2/5/6/125611834/140488134.gif)
And with the Excel Skin, you’ll relearn your old shortcuts in no time. The Excel Skin makes it easy to be as proficient and efficient in Excel for Mac as on any other platform. Powerful shortcuts are presented intuitively on an elegant silicone keyboard skin.
Shortcut and modifier keys are printed by color and heat fused onto our high quality silicone to ensure durability. The Excel Skin a small product that will make a big difference in your life. Hiding Rows: Two weeks ago we discussed how to hide and unhide columns. In this short blog post I will teach you how to do the same with your rows. Step 1: Select the row you wish to hide by clicking on the 2 in this example. Step 2: Using the Excel Skin as a guide, press the following keys: (⌃9) Just like the “Hide Column” shortcut, the “Hide Rows” shortcut uses just one modifier key: “Control” and the “9” key.
Unhiding Rows: Step 1: Again, just like the process of unhiding columns, we must select the rows on either side of the row that we hid. Step 2: Using your Excel Skin as a guide, press the following keys: (⌃⇧9) Your hidden row should now appear. By simply adding the “Shift” modifier key we change the yellow “Hide Rows” shortcut to the light blue “Unhide Rows” Shortcut. To read more about the uses of hiding rows and columns check out our previous post here: P.S. We know hiding your data on Excel is fun but remember to unhide it when handing in those quarterly reports to your boss!
![Hide unhide column in excel 2010 Hide unhide column in excel 2010](/uploads/1/2/5/6/125611834/637057608.gif)
He might not like blank spreadsheets as much as we do. (Unless you are a secret spy).