Unhide the first column or row in a worksheet
※ Download: Unhide column a in excel 2010
How to resolve this issue: The resolution of this issue is pretty obvious and that is changing the Keyboard Layout shortcut. It will teach you to show all hidden columns or just the ones you select, how to unhide first column, and more. Notes: 1 May not work in Excel 2010 on Vista or Windows 7. That works fine until you try to unhide column A, as there's only one adjacent column, column B.
If you wish to unhide all of the hidden columns in your spreadsheet, then you can. How to Unhide Columns in Excel Using a Keyboard Shortcut The steps in this section will show you how to use a combination of keys on your keyboard to unhide your hidden columns. By autofitting the hidden columns, they are automatically shown.
Unhide columns in PowerPivot 2010 - You are looking for Advanced Keyboard Settings, under Region and Language. CTRL+0 Hides the selected columns.
Last updated: August 16, 2018 Learning how to unhide columns in Excel is important for anyone that has data in their spreadsheet that they might need to hide from their audience. Hiding a column allows you to leave data in a spreadsheet, while simultaneously making it more difficult to view or accidentally edit it. Microsoft Excel is an infinitely useful program with assorted tools and functions that make it ideal for a number of different scenarios. But one problem that you might encounter is simply that your worksheet has too much data, and that important information is in cells that are off the screen. One solution to this problem is to hide columns of your worksheet that might contain less important information. Hiding is a preferable choice to deletion, because the hidden columns are still in the worksheet, allowing them to be used in formulas without disrupting the formula output cells. But the process for unhiding columns in Excel 2013 is not immediately obvious, so continue reading below to learn how to unhide columns in Excel. How to Unhide All Columns in Excel If you receive an Excel worksheet from someone else that contains hidden columns, it is not always immediately obvious. There are, however, two ways that you can find hidden columns. The first is that the columns that are displayed will not be in alphabetical order. Second, the column border for a visible column will look different when there is a hidden column on either side of it. You can see an example of both of these signals in the image below. Example of hidden columns So now that you know how to identify when columns have been hidden, you can use the steps below to unhide those columns in Excel. I am using Microsoft Excel 2013 in the steps below, but these steps will also work in other versions of Excel as well. Step 1: Open the workbook containing the columns that you want to unhide. Step 2: Click the top-left corner of the worksheet to select the entire sheet. Right-click a selected column letter, then click Unhide How to Unhide Only Some of Your Hidden Columns in Excel If you only want to unhide certain columns, then you can select the columns on either side of the hidden columns. For example, columns C, D and E are hidden in the image below. I want to unhide only those columns, so I select columns B and F instead of the entire worksheet. How to Unhide Columns in Excel Using a Keyboard Shortcut The steps in this section will show you how to use a combination of keys on your keyboard to unhide your hidden columns. Step 1: Select the columns surrounding the columns you wish to unhide. Alternatively you can click the button between row heading 1 and column heading A to select the entire spreadsheet. Select the columns surrounding the columns to unhide Step 2: Press Ctrl + Shift + 0 on your keyboard. Note that you will need to press the 0 key at the top of the keyboard, not the one on the number pad. If you have been thinking about getting additional copies of Office 2013 for home or work, you should. It has a lower up-front cost, allows multiple computer installations that can be managed, plus it gives you access to the full Office suite of programs as opposed to only Word, Excel and PowerPoint. If you are looking for a good way to simplify the process of viewing and summarizing your data, you should. They are very helpful for many different situations and can replace a lot of complicated formulas and manual mathematical operations.
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. Alternatively you can click the button between row heading 1 and column heading A to select the entire spreadsheet. Make sure the Hidden Rows and Columns option is checked. CTRL+SHIFT+ Unhides any hidden columns within the selection. When the pointer changes from the selection arrow to a double arrow — this will happen as the mouse pointer nears the Select All cell — right-click and choose Unhide. It's possible to conceal some columns by using the Hide feature or by setting the column width to zero.
