Thanks again. LikeLike Reply Kim says: November 11, 2016 at ^.^ Thank you, Gerry! It's possible to conceal some columns by using the Hide feature or by changing the column width to zero. I tried the followings, neither worked, even in full-screen mode Step 1: F5 (Ctrl+G) to define & select 1:15, set row height to 20 and "unhide row", they are still hiding; check over here
Pressing CTRL+SHIFT+ARROW key a second time selects the entire row or column. Unhide on its own didn't work. Nonadjacent cells or cell ranges Select the first cell or range of cells, and then hold down CTRL while you select the other cells or ranges. However, it's not an option if your worksheet contains numerous, like more than 20, hidden columns.
Still there is one trick to help you locate hidden columns in Excel. Glad it helps 😀 LikeLike Reply Chris says: April 30, 2015 at ^.^ Thank you! You should employ Document Inspector in this case. On the Home tab, in the Editing group, click Find & Select, and then click Go To.
Please can anyone suggest a solution? If the worksheet contains data, CTRL+A selects the current region. Click OK to save the changes. http://www.mrexcel.com/forum/excel-questions/76050-i-cant-unhide-rows.html Select the hidden column A to show it in Excel Click on the header for column B to select it.
If you use Excel 2010/2013, please click File > Info > Check for Issues > Inspect Document. 2. How To Unhide Rows In Excel 2013 Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Feb 24th, 2004,04:23 AM #7 Tom Urtis MrExcel MVP Join Date Feb 2002 Location San Francisco, California USA Posts And all of the hidden rows and columns in the workbook will be removed. Way to think outside the box in your problem solving.
LikeLike Reply MF says: January 17, 2015 at ^.^ Hi Lindsey, It sounds strange. http://superuser.com/questions/479579/unhide-row-doesnt-work Here’s the findings: For row height <=0.07, row are basically hidden where we can “unhide” the row as normal For row height from 0.08 to 0.67, row looks like hidden (We Can't Unhide Columns In Excel I am using Excel 2010 btw. Excel Hidden Rows Won't Unhide LikeLike Reply MF says: May 6, 2016 at ^.^ Glad you find a way out. 😀 LikeLike Reply guri says: May 2, 2016 at ^.^ another reason is cell lock.
Thank you! check my blog The first or last cell on a worksheet or in a Microsoft Office Excel table Press CTRL+HOME to select the first cell on the worksheet or in an Excel list. Or select the first row or column; then hold down SHIFT while you select the last row or column. Before you share the table with your colleagues you need to make sure no one will unhide the columns. Excel Rows Not Showing But Not Hidden
Nope, neither one. If the worksheet contains data and the active cell is above or to the right of the data, pressing CTRL+A selects the current region. Susan says June 7, 2016 at 8:47 am Stuart's tip worked for unhiding rows. this content You can also select the first cell or range of cells, and then press SHIFT+F8 to add another nonadjacent cell or range to the selection.
Neither did changing row height. Rows Won't Unhide In Excel 2013 Note: If the worksheet contains data, CTRL+A selects the current region. Thanks!
On the Go To Special dialog box, select the Visible cells only radio button and click OK. The first or last cell in a row or column Select a cell in the row or column, and then press CTRL+ARROW key (RIGHT ARROW or LEFT ARROW for rows, UP You cannot cancel the selection of a cell or range of cells in a nonadjacent selection without canceling the entire selection. Unhiding Rows In Excel Cells to the beginning of the worksheet Select the first cell, and then press CTRL+SHIFT+HOME to extend the selection of cells to the beginning of the worksheet.
Thanks (0) By Anonymous 02nd Jul 2007 17:34 Excel queryWhen you say you have highlighted the whole area or sheet, have you done this by clicking in the border above row I did test that. Top of Page See Also Video: Hide and unhide columns and rows in Excel 2010 Video: Unhide the first column and row in Excel 2010 Locate hidden cells on a worksheet http://techese.net/in-excel/unhide-rows-excel-not-working.html Does anyone know why this may be happening?
In my case, the top 150 rows had vanished! Drag your mouse pointer to the left until you see the border change its color. All cells on a worksheet Click the Select All button. Adjacent rows or columns Drag across the row or column headings.
To select the entire worksheet, you can also press CTRL+A. Select the Inspect Document option. The first or last cell on a worksheet or in a Microsoft Office Excel table Press CTRL+HOME to select the first cell on the worksheet or in an Excel list. Less You can hide a row or column by using the Hide command, but a row or column also becomes hidden when you change its row height or column width to
None of the other suggestions were working for me! If any questions left, feel free to comment on the post using the form below. On the Home tab, in the Cells group, click Format. Setting Row Height by page, or by row was not unhiding anything.
Now navigate to the Review tab and click on the Protect Sheet icon. More or fewer cells than the active selection Hold down SHIFT while you click the last cell that you want to include in the new selection. Note: If the worksheet contains data, CTRL+A selects the current region. In the Reference box, type A1, and then click OK.
On the Home tab, in the Cells group, click Format. While I was lost and had no clues, my "shaking" hand gave me the answer: It is the row height! Reply BWright says: February 17, 2016 at 1:41 pm Thanks that has always been a pain…i appreciate your explanation being concise. It's a bit strange as i tried and i can unhide multiple hidden rows by setting the row height of the entire sheet. 🤔 LikeLike Reply Helen says: October 21, 2016
Cells to the beginning of the worksheet Select the first cell, and then press CTRL+SHIFT+HOME to extend the selection of cells to the beginning of the worksheet.