Unhide the first column or row in a worksheet If the first row (row 1) or column (column A) is not displayed in the worksheet, it is a little tricky to unhide it because there is no easy way to select that row or column. You can select the entire worksheet, and then unhide rows or columns ( Home tab, Cells group, Format button, Hide & Unhide command), but that displays all hidden rows and columns in your worksheet, which you may not want to do.
- To select the first hidden row or column on the worksheet, do one of the following:
- In the Name Box next to the formula bar, type A1, and then press ENTER.
- On the Home tab, in the Editing group, click Find & Select, and then click Go To, In the Reference box, type A1, and then click OK,
- On the Home tab, in the Cells group, click Format,
- Do one of the following:
- Under Visibility, click Hide & Unhide, and then click Unhide Rows or Unhide Columns,
- Under Cell Size, click Row Height or Column Width, and then in the Row Height or Column Width box, type the value that you want to use for the row height or column width. Tip: The default height for rows is 15, and the default width for columns is 8.43,
If you don’t see the first column (column A) or row (row 1) in your worksheet, it might be hidden. Here’s how to unhide it. In this picture column A and row 1 are hidden. To unhide column A, right-click the column B header or label and pick Unhide Columns, To unhide row 1, right-click the row 2 header or label and pick Unhide Rows, Tip: If you don’t see Unhide Columns or Unhide Rows, make sure you’re right-clicking inside the column or row label. : Unhide the first column or row in a worksheet
- 1 How do I unhide hidden columns?
- 1.1 How do you quickly hide and unhide columns in Excel?
- 1.2 Why does Ctrl Shift 0 not work?
- 1.3 How do I unhide rows in Excel without double clicking?
Why won’t my columns unhide in Excel?
Using the Format Option in the Ribbon – Under the home tab in the ribbon, there are options to hide and unhide columns in Excel. Here is how to use it:
- Select the columns between which there are hidden columns.
- Click the Home tab.
- In the Cells group, click on Format.
- Hover the cursor on Hide & Unhide option.
- Click on ‘Unhide Columns’
Another way of accessing this option is by selecting the columns and right clicking using the mouse. In the menu that appears, select the unhide option.
Unhide columns –
- Select the adjacent columns for the hidden columns.
- Right-click the selected columns, and then select Unhide,
Or double-click the double line between the two columns where hidden columns exist.
How do I unhide a column shortcut in Excel?
Press the shortcut ‘Ctrl+Shift+9’ to unhide all rows. Press all keys together. Select the entire worksheet again. Press the shortcut ‘ Alt H O U L ‘ to unhide all columns.
How do you quickly hide and unhide columns in Excel?
How to hide a column in Excel using the ribbon – As its name suggests, this option is tucked away deep in the menus, so you need to know where to look for it 🙂 To hide unwanted columns by clicking a ribbon button, the steps are:
- Select the column or any cell within the column(s) you want to hide.
- On the Home tab, in the Cells group, click Format > Hide & Unhide > Hide Columns,
Done! The information that you don’t want to view or print is hidden.
Why can’t I see all columns in Excel?
Can’t See Columns in Excel Over the course of a long night, you prepared your spreadsheet. However, when you looked at it the next morning, you find that you cannot see several columns. Do not worry – Excel did not spontaneously erase data from your spreadsheet.
Why does Ctrl Shift 0 not work?
Ctrl+Shift+0 not accepted as key command (due to Windows and Office programs) Cubase 12.0.50 on Windows 10. I wanted to assign a key command to a macro and chose Ctrl+Shift+0. However, the dialogue box didn’t recognize the key combo. Alt+Shift+0, Ctrl+0, Ctrl+Shift+9, etc. and other combinations seem to be recognized. Just not Ctrl+Shift+0. Can anyone confirm or provide a reason? Thanks! EDIT: I did try combinations of the left and right side Ctrl and Shift keys too. No change.2 Likes I’m on Nuendo and Win 11, but it works for me Weirdness. I was able to reproduce in Cubase, so I tried to figure out what was going on- checked a bunch of things, to no avail, and figured I’d come back to it later and try to solve. In the mean time I restarted my machine, I saw ‘s reply, and tried again – now the shortcut works.1 Like Interesting. Restarted computer. No change for me though. Does it work in other applications? Is there any keyboard layout switch software in use? 1 Like OK. It’s a Windows thing. Go to Language Settings > Keyboard > Input language hot keys > Advanced Key Settings. Change the key sequence for “Between input languages” to Not Assigned. Apparently this was a problem in Excel, which is where I found posts with the solution. Just posting to say that there might also be another cause. I had checked that Windows setting (and other MS Office related ones, and there was no assignment. There are some very low-level, difficult to reconfigure keyboard shortcuts for the MS Office products, including this shortcut:, (yes, just those modifier keys). My point is that MS is binding keystrokes in a way that’s meant to be opaque to the user, so it’s difficult or impossible to change.3 Likes steve:, (yes, just those modifier keys). Am I the only one who finds it extremely funny that a combination of keys clustered together (so probably best to hit with a flat palm or fist) launches Linkedin? “THAT DOES IT! I QUIT!” WHACKS KEYBOARD Browser: >Please edit your Linkedin profile.2 Likes Actually, those four keys, held down with none other, launches MS Office, and if that is not installed, opens their website. Yes, very annoying for anyone who does lots of keystroke customization. Then, append various keys to launch the individual programs I took me a while to find a fix, and in the meantime I did workarounds to hide the effect, including an ahk timer that closes the window that opens within 100 milliseconds, and, I actually made a hosts entry to redirect the url to localhost. The fix was to run this command (as admin) from a,reg file or cmd prompt. REG ADD HKCU\Software\Classes\ms-officeapp\Shell\Open\Command /t REG_SZ /d rundll32 1 Like If only they would ask first. My biggest gripe with Windows key management is NumLock not allowing shift to work. It stills gives me pause why recall marker X doesn’t work. (Shift+NumPad 1-9) And then after a few seconds I remember: “aaah, it’s because Num Lock is on.) This is why I use ahk – to “fix” 1 Like : Ctrl+Shift+0 not accepted as key command (due to Windows and Office programs)
How do I unhide in Excel without right clicking?
Unhide Rows Using a Keyboard Shortcut – To unhide one or more rows, highlight at least one cell in the rows on either side of the hidden row(s) with the mouse pointer. For example, you want to unhide rows 2, 4, and 6.
- To unhide all rows, click and drag with the mouse to highlight rows 1 to 7.
- Press and hold down the Ctrl and the Shift keys on the keyboard.
- Press and release the number 9 key without releasing the Ctrl and Shift keys. The hidden row(s) will become visible.
How do I unhide rows in Excel without double clicking?
You can select a set of rows between any range by clicking on the row you want to start with and press Ctrl as you click on the last row in your range. From there, you can right click on your selection and click on the function called Unhide.
Can you unhide all sheets in Excel at once?
The ability to Unhide multiple worksheets at once has been a popular request on UserVoice, and we’re excited to let you know that this feature is now available for Microsoft 365 Subscribers on Current Channel. To get it, you can update to version 16.0.13525 or greater on Windows, and it’s also available in Excel for the Web. To unhide more than one sheet, follow these easy steps in any workbook that contains hidden worksheets:
Right-click the Sheet tab at the bottom, and select Unhide. In the Unhide dialog box, – Press the Ctrl key (CMD on Mac) and click the sheets you want to show, or – Press the Shift + Up/Down Arrow keys to select multiple (or all) worksheets, and then press OK,
If you have additional suggestions, please use the feedback button on the Help tab of the ribbon to let us know.