- HOW TO UNHIDE A COLUMN IN EXCEL MANUALLY HOW TO
- HOW TO UNHIDE A COLUMN IN EXCEL MANUALLY MANUAL
- HOW TO UNHIDE A COLUMN IN EXCEL MANUALLY CODE
Method 2: Keyboard Shortcut for Hiding Columns in Between You’ll see a little extra line at the top, in between B and D, and you can simply click that little line, and drag your mouse to the right, and column C (or whatever your hidden column is) will appear out of hiding. If you’re a mouse user, some people might give you a hard time and encourage you to learn keyboard shortcuts for everything, but sometimes it’s easier to just use the mouse – no judgments!Īll you have to do is to look at the top of your worksheet, where the column you want to unhide would be located if it weren’t hidden.įor example, if you want to unhide column C, then look at the line in between B and D, at the top where the column labels are: Method 1: Unhiding Columns in Between Using Your Mouse This is useful when you have a handful of hidden columns, but you don’t want to unhide every single one of them.
HOW TO UNHIDE A COLUMN IN EXCEL MANUALLY HOW TO
Now that we’ve shown how to unhide every single column, let’s look at how to unhide columns in between your selected columns.
HOW TO UNHIDE A COLUMN IN EXCEL MANUALLY CODE
VBA involves running lines of code inside of a visual basic editor, and here’s the code you’ll need to execute in order to unhide your columns:ĮndSub Unhiding Columns That Are In Between Other Columns VBA stands for visual basic for applications, and it’s meant for power users, so if you’re more of a casual Excel user, you may want to skip this – mind you – it’s also an easy way to dip your toes in the water, so it can also be a great way to explore and learn more.īut if you’re just looking to unhide your columns here and there, so you can get on with your work, this won’t be the most practical way unless you don’t mind rolling up your sleeves and setting this up. In some cases, it may be advantageous to use VBA for this. That’s Alt, then H, then O, then U, then L. It’s Control, then A, then A again, you need to press A twice. Press the control key on your keyboard, then press A A.
Begin by selecting any cell in your worksheet area.Here’s the keyboard shortcut for unhiding columns:
HOW TO UNHIDE A COLUMN IN EXCEL MANUALLY MANUAL
Sometimes, a keyboard shortcut will work for someone, and it won’t work for somebody else, or it might work for you on some days, and not other days – we’ve all experienced finicky shortcuts, but it’s still worth a try – odds are it’ll get the job done, and if not, you can do it the manual way mentioned above. There’s also a handy keyboard shortcut that will unhide all of the columns for you. In a couple of clicks, every single hidden column on your entire worksheet will now be visible. It’s that easy, there’s a feature to unhide columns built right into the first layer of menus when you right-click. Use your mouse to right-click within the worksheet.Select every cell in your worksheet by clicking on the small triangle located to the top left of the sheet.It’s a three-step process to unhide every column in Excel at once: This is the easiest way to unhide every cell all at once, and chances are this will do the trick for you, but if not, there are some other ways to accomplish this featured below. This is good if you’re taking over a sheet that somebody else made and you want to get a better picture of what’s going on, especially for a more complex Excel spreadsheet. If you don’t want to go on a scavenger hunt to track all of them down, here are a few ways to unhide every column at the same time. Sometimes, your spreadsheet will have numerous hidden columns that you’ve got to deal with. Some of the methods that you would use to unhide columns will also work to unhide rows. We’ll start with columns, and then we’ll tackle rows, and finally cells. We’ll also go over some different methods that you can try since there’s usually more than one way to do something, and knowing the alternatives can help you fly through your sheets with more ease. So let’s look at how to unhide cells in Excel, how to unhide rows in Excel, and how to unhide columns in Excel. If you know how to unhide cells, and you know there are hidden cells there, then you’re all set – but you wouldn’t be here! They can be an absolute nightmare, especially when somebody else created the sheet and you’re stuck trying to wrangle it, or you might not even know that the hidden cells exist in the first place. Are hidden columns, rows, or cells driving you crazy in Excel?