- Shortcut to unhide a column in excel 2010 windows 10#
- Shortcut to unhide a column in excel 2010 windows#
They won't work if you use the 0 key on the numeric keypad. For example, if you hide columns D and E, you can later unhide them by selecting columns C through F (which obviously includes the hidden columns) and then pressing the shortcut.įinally, you should be aware that both of these shortcuts only work if you use the 0 key on the main keyboard. You will now be able to use Ctrl+Shift+0 to unhide the columns.Īnother thing to keep in mind is that the only way that Ctrl+Shift+0 works is if you have at least one hidden column selected before you use it. If you don't use this option, "Not Assigned" is the best choice.
Shortcut to unhide a column in excel 2010 windows#
Windows displays the Change Key Sequence dialog box.
![shortcut to unhide a column in excel 2010 shortcut to unhide a column in excel 2010](https://images.tips.net/S22/Figs/T7559F1.png)
To take away an auto define youve utilized, click on the Data tab within the Ribbon.
![shortcut to unhide a column in excel 2010 shortcut to unhide a column in excel 2010](https://support.content.office.net/en-us/media/cf70a7d2-e3ec-4492-8aae-2946612bde0f.png)
Type "Advanced Keyboard Settings" (without the quotes) in the Search box at the left of the Taskbar. Hiding sure rows or columns in Excel can make viewing advanced, detailed information easier to read.
Shortcut to unhide a column in excel 2010 windows 10#
If you are using the Windows 10 operating system, follow these steps to reassign the Ctrl+Shift+0 shortcut back to Excel: The following Microsoft Support article explains the process to go through in order to reassign this keypress back to Excel to unhide columns in earlier versions of Microsoft Windows: Probably a more likely reason the second shortcut ( Ctrl+Shift+0) doesn't work is because this keypress is being used by the Windows operating system for use in switching language keyboards. Ctrl+ (grave accent) Alternate between displaying cell values and displaying cell formulas. If the second shortcut ( Ctrl+Shift+0) doesn't work on your system, it could be because there is some add-in being loaded that stops the shortcut from working properly or, perhaps, because a custom shortcut key has been defined that uses the same keypress. Ctrl+Shift+0 (zero) Unhide any hidden columns within the selection. There was no change in the shortcuts they both still work just fine in later versions of Excel. Tom wonders if Microsoft changed one shortcut but not the other. When he upgraded to a much newer version of Excel, however, only the Ctrl+0 worked for him, not Ctrl+Shift+0. 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)Īs for Dan's answer, no idea why the official list changed after this fix the keyboard shortcut does seem to work, and the problem was related to an operating system setting, not Excel version.Tom notes that in older versions of Excel he would use Ctrl+0 to hide selected columns and Ctrl+Shift+0 to unhide those columns.On the Advanced Key Settings tab, select the Between input languages action and click Change Key Sequence.Apart from using the created array with TEXJOIN, the transforming of a 3D range in Excel to a 1D. Click the Change Keyboards button on the Keyboards and Languages tab The only actions left are to add the B I N G O column.
![shortcut to unhide a column in excel 2010 shortcut to unhide a column in excel 2010](https://www.addictivetips.com/app/uploads/2010/04/unhide.jpg)
Open Control Panel -> Change keyboards or other input methods (Under Clock, Language and Region).To summarize, the solution is (in Windows 7): That functionality probably assigns the number keys to different layouts, so Win7 is swallowing CTRL + SHIFT + 0 and trying to change my keyboard layout (I don't have any non-default layouts set) instead of passing the shortcut to Excel.Īfter following the resolution in that KB article, the issue is fixed, and unhiding columns via the keyboard in Excel 2010 works as expected. That thread eventually comes up with this Microsoft KB article, revealing that, in Vista (and apparently Win7 as well), CTRL + SHIFT is hooked by the Regional/Language settings to change keyboard layouts. Googling "Excel Ctrl Shift 0" brought me to this thread on the ExtremeVBTalk forum.