Home > In Excel > Can't Unhide Rows In Excel 2013

Can't Unhide Rows In Excel 2013

Contents

Here is the FAQ for this forum. + Reply to Thread Results 1 to 8 of 8 Excel 2007 : Cannot unhide top rows Thread Tools Show Printable Version Subscribe to Appreciate the help! On the Home tab, in the Cells group, click Format. If the worksheet contains data, CTRL+A selects the current region. navigate here

I have checked to see if cells are locked or hidden, and they are not. Where do I drop off a foot passenger in Calais (P&O)? See solution in other versions of Excel: Excel 2016 Excel 2013 Excel 2011 for Mac Excel 2010 Excel 2007 Excel 2003 Before trying the following solution, you might want to make Copyright © 2003-2016 TechOnTheNet.com.

Can't Unhide Rows In Excel 2013

When the GoTo window appears, enter A1 in the Reference field and click on the OK button. Thanks Barry Share Share this post on Digg Del.icio.us Technorati Twitter Barry- Photo Restoration/Enhancement http://www.smiledogproductions.com click below for detour Reply With Quote Dec 23rd, 2010,12:11 PM #4 MrKowz Board Regular Join 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. On the Home tab, click on the Format icon Choose Hide & Unhide from the dropdown menu then select Unhide Rows.

Next right click row 66, chose unhide, and rows 1-65 will reappear. How can we improve it? Select Cells > Format > Hide & Unhide > Unhide Columns. How To Unhide Rows In Excel 2010 How to select cells, ranges, rows, or columns To select Do this A single cell Click the cell, or press the arrow keys to move to the cell.

You can also select the first cell in the range, and then press F8 to extend the selection by using the arrow keys. Hidden Rows In Excel 2010 Won't Unhide 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. All rights reserved. http://www.mrexcel.com/forum/excel-questions/517279-cant-unhide-rows-excel-2007-a.html Please try the request again.

have you checked if there are any addins/vba-macros active - linke Wokrsheet_change? How To Unhide Rows In Excel 2007 The rectangular range between the active cell and the cell that you click becomes the new selection. Do one of the following: Under Visibility, point to Hide & Unhide, and then click Unhide Rows or Unhide Columns. You can also right-click the selection of visible rows and columns that surround the hidden rows and columns, and then click Unhide.

Hidden Rows In Excel 2010 Won't Unhide

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. http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/cant-unhide-rows/285b3aba-a862-439b-986b-03398e891d2a You should be able to unhide all of the rows inbetween after that. Can't Unhide Rows In Excel 2013 When I do that, the Unhide option is not greyed out and achieves what you are trying to do. Rows Won't Unhide In Excel 2013 Neither did changing row height.

Generated Tue, 08 Nov 2016 09:15:12 GMT by s_wx1194 (squid/3.5.20) Sign in Search Microsoft Search Products Templates Support Products Templates Support Support Apps Access Excel OneDrive OneNote Outlook PowerPoint SharePoint Skype check over here NEXT: Unhide Right Columns Share this page: Advertisement Back to top Home | About Us | Contact Us | Testimonials | Donate While using this site, you agree to have read It retains spacing, so your code is easier to read, and therefore easier to debug. - Please back up your file before using any macros suggested! This is my pillow What is the temperature of the brakes after a typical landing? Excel Unhide Rows Doesn't Work

On the Home tab, in the Cells group, click Format. On the Home tab, in the Editing group, click Find & Select, and then click Go To. On the Home tab, under Editing, click Find & Select, and then click Go To. http://culturahq.com/in-excel/cannot-unhide-columns-in-excel-2013.html Teenage daughter refusing to go to school Compare elements iteratively How to decide between PCA and logistic regression?

Forum Today's Posts FAQ Calendar Community Groups Forum Actions Mark Forums Read Quick Links What's New? How To Unhide Rows In Excel 2013 Please re-enable javascript in your browser settings. Select Cells > Format > Hide & Unhide > Unhide Columns.

We use advertisements to support this website and fund the development of new content.

All rights reserved. To cancel a selection of cells, click any cell on the worksheet. We use advertisements to support this website and fund the development of new content. Excel Rows Not Showing But Not Hidden Nonadjacent rows or columns Click the column or row heading of the first row or column in your selection; then hold down CTRL while you click the column or row headings

All cells on a worksheet Click the Select All button. The first row or column of the worksheet is tricky to unhide, but it can be done. Members List Calendar Forum Rules Dashboard Commercial Services Advanced Search Forum Microsoft Office Application Help - Excel Help forum Excel General [SOLVED] Excel 2007 : Cannot unhide top rows To get http://culturahq.com/in-excel/excel-rows-not-showing-but-not-hidden.html In that window, type (or copy) the following code, adjusting for the rows you want unhidden, and the sheetname for x=1 to 15:sheets("WorkSheetName").range("A"&x).entirerow.rowheight=17:next This sets the height of all 15 rows

Get AccountingWEB in your inbox Trending any answers {{item['sft-date']}} Any Answers {{item['sft-title']}} Asked by {{item['sft-author']}} Advertisement You might also like {{item['sft-date']}} {{item['sft-section']}} {{item['sft-title']}} Trending on AccountingWEB {{item['sft-section']}} {{item['sft-title']}} Practice Excellence Practice Pressing CTRL+SHIFT+ARROW key a second time selects the entire row or column.


  • © Copyright 2017 culturahq.com. All rights reserved.