Unhide Row In Excel 2016 Code Then You

If your question is resolved, mark it SOLVED using the thread tools 3.

Click on the star if you think someone helped you Regards Ford.

But now when it comes to unhide these columns, there are few complications.

In this post I will show you a few ways by which you can easily unhide your hidden 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.

Unhide Columns in Excel using the shortcut: Actually, Microsoft Excel has provided certain shortcut keys for hiding rows and columns in your spreadsheets.

These shortcut keys are in the below table: Shortcut Key Description CTRL9 Hides the selected Rows.

First select one column on the either side of the hidden column and then press the shortcut key.

Microsoft Windows Vista and Windows 7 operating systems have assigned the CTRLSHIFT keys for Regional Language settings for changing the keyboard layouts.

This functionality probably assigns numbers to different layouts.

Follow the below steps: First open the Control Panel, navigate to the Change keyboards or other input methods link.

Now a Region and Language dialog box opens, select the Keyboard and Language Tab and click on the Change Keyboard button.

Next, a new window Text Services and Input Languages opens, here select the Advance Key Settings tab and then click the Change Key Sequence button.

Under Switch Keyboard Layout, set the radio button to Not Assigned (or one of the other options, if you need this feature to be available).

This resolution is suggested in the Microsoft Knowledge Base article.

Unhide Row In Excel 2016 Code Then You

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 FalseEnd Sub This small macro will unhide all the hidden columns in your active worksheet.

If you also want this macro to unhide all the rows as well then simply add a line: ActiveSheet.Cells.EntireRow.Hidden False So, these are some of the ways to Unhide Columns in Excel.

Filed Under: How Tos Tagged With: Excel All Versions About Ankit Kaul Ankit is the founder of Excel Trick.

He is tech Geek who loves to sit in front of his square headed girlfriend (his PC) all day long.:D.

Ankit has a strong passion for learning Microsoft Excel.

Learn Excel with Us Excel VLOOKUP Tutorial Microsoft Excel IF Statement Excel Web App Viewers What is Excel VBA HLOOKUP - Excel Formula Training Session Spell Check In Excel Top 50 Excel Based Games Microsoft Excel Shortcuts And Functions Keys Excel SUMIF and SUMIFS Functions FileSystemObject in VBA Stay Connected With Us Join 5.3 K People Following Us RSS Facebook Twitter Stay Updated via Email Newsletter Recent Posts How To Freeze Rows In Excel Counting Unique Values In Excel 5 Effective Ways Use an Image as a Background in Excel Excel Function Keys and Shortcuts Named Range in Excel How to Use Excel Sparklines Adding Current Date and Time Stamp in Excel NETWORKDAYS Function In Excel Sum Cells based on Background Color Getting Familiar with VB Editor (VBE): VBA Basics 002 Excel VBA Resources Copyright 2012-2017 Excel Trick All Rights Reserved SiteMap Privacy Policy Disclaimer About.

How To Unhide Row In Excel For Mac 2016