Think again. Your cache administrator is webmaster. See solution in other versions of Excel: Excel 2016 Excel 2013 Excel 2011 for Mac Excel 2010 Excel 2007 Excel 2003 Question: How do I unhide row #1 in a sheet Pressing CTRL+A a second time selects the entire worksheet. useful reference
Select the Home tab from the toolbar at the top of the screen. Teenage daughter refusing to go to school Compare elements iteratively How to decide between PCA and logistic regression? Try hiding rows 1-3 (even if they were hidden) and then try unhiding them again. 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
If an image is rotated losslessly, why does the file size change? I didn't even think of that! How difficult is it to practically detect a forgery in a cryptosystem?
Hide one or more rows or columns Display one or more hidden rows or columns Display all hidden rows and columns at once Unhide the first row or column of the If rows 1-53 somehow got really small, they appear hidden, but they're not. You can display either again by using the Unhide command. How To Unhide Rows In Excel 2010 Copyright © 2003-2016 TechOnTheNet.com.
Insolvency Insolvency investigation? Hidden Rows In Excel 2010 Won't Unhide 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! So, unhide the rows as you describe and then hover over the row symbols on the side (in between the two rows where your rows are hidden) and then click and 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.
Pressing CTRL+SHIFT+ARROW key a second time selects the entire row or column. How To Unhide Rows In Excel 2007 All rights reserved. Isn't the right-click, un-hide working in Excel 2007? This can cause all sort of problems.
All rights reserved. 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 Can't Unhide Rows In Excel 2013 In the Editing group, click on the Find button and select "Go To" from the popup menu. Rows Won't Unhide In Excel 2013 Make sure you are doing a CTRL A.
Hot topics Sub-categories European Union Start up in practice Practice excellence Making tax digital European Union VAT EU Refund European Union Accountants face more complex data protection European Union 9am Lowdown: see here Forum Board FAQ Forum Rules Guidelines for Forum Use FAQ Forum Actions Mark Forums Read Quick Links Today's Posts Search New Posts Zero Reply Posts Subscribed Threads MrExcel Consulting Advanced Search A large range of cells Click the first cell in the range, and then hold down SHIFT while you click the last cell in the range. By David160 03rd Jul 2007 17:52 Here is how I do itLeft click and hold on row 66 (ie on the number 66 itself) then move the mouse pointer up, so Excel Unhide Rows Doesn't Work
Press CTRL+END to select the last cell on the worksheet or in an Excel list that contains data or formatting. Or select the first row or column; then hold down SHIFT while you select the last row or column. All cells on a worksheet Click the Select All button. this page Please can anyone suggest a solution?
share|improve this answer answered Feb 23 '12 at 20:58 Helper add a comment| up vote 0 down vote I know it's an old question, but there is a way to get How To Unhide Rows In Excel 2013 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. Column heading You can also select cells in a row or column by selecting the first cell and then pressing CTRL+SHIFT+ARROW key (RIGHT ARROW or LEFT ARROW for rows, UP ARROW
Click the Sort & Filter button on the Home tab of the ribbon and then click 'clear'. Cells to the last used cell on the worksheet (lower-right corner) Select the first cell, and then press CTRL+SHIFT+END to extend the selection of cells to the last used cell on Top of Page Display one or more hidden rows or columns Do one of the following: To display hidden rows, select the row above and below the rows that you want http://trado.org/in-excel/cannot-unhide-cells-in-excel-2010.php I need access to these rows, but when I highlight the whole area or sheet, the HIDE/UNHIDE options do not appear and therefore I cannot unhide my hidden rows.
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 NEXT: Insert Column Share this page: Advertisement Back to top Home | About Us | Contact Us | Testimonials | Donate While using this site, you agree to have read and 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 My cat sat down on my laptop, now the right side of my keyboard types the wrong characters Underbrace under nested square roots Why are angular frequencies used when studying crystal
I have to go the the space between the ... Please try the request again. Try Windows unfreeze panes.Richard Thanks (0) By scalloway 13th Jul 2007 19:59 F5Use the F5 to go to a cell in the hidden area (eg A1) then Format, Row, Unhide Thanks Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc.
Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the If there are ten hidden rows, I have to do this procedure for each one. All rights reserved. Now you should be able to see column A in your Excel spreadsheet.
There's probably a visual basic script to do this that you could code up as well. Under Cell Size, click Row Height or Column Width, and then type the value that you want in the Row Height or Column Width box. 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. 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.
Answer: Select the Home tab from the toolbar at the top of the screen. Community Sub-categories Blogs Industry updates Water cooler The Met Office mentioned the "S" word today A few things to consider when choosing a... Where do I drop off a foot passenger in Calais (P&O)? How can we improve it?
share|improve this answer answered Sep 20 at 12:27 user3658961 1 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up