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

Can't Unhide Rows In Excel 2013

Contents

Full Bio Contact See all of Susan's content Google+ × Full Bio Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Is there any way to hide the checkboxes as well? See if the panes are split or the scroll area is limited. Author Bio Allen Wyatt With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. this content

Same principle as stated by Dennis. Jo has tried unhiding them to no avail, even copying the columns and pasting them into empty columns inserted at columns C and D. Selecting just column B won't select column A. Originally Posted by Tom Urtis Check if you have Freeze Panes enabled, and unfreeze it.

Can't Unhide Rows In Excel 2013

Delivered Daily Subscribe Best of the Week Our editors highlight the TechRepublic articles, galleries, and videos that you absolutely cannot miss to stay current on the latest IT news, innovations, and current community blog chat Super User Meta Super User your communities Sign up or log in to customize your list. How do I hide a column in excel but dnt gv access to anyone else, meaning if u open my file I dnt want the person to click unhide and read Share Share this post on Digg Del.icio.us Technorati Twitter Tom Urtis Microsoft MVP - Excel Reply With Quote Oct 9th, 2013,02:46 AM #9 DaveU New Member Join Date Aug 2011 Location

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 Steven Dale20 Jul 2016, 09:59 I would recommend you provide the actual instructions for doing this instead of the fake instructions provided above.I would love to sit in on a designers Can Mirror Image still work while being grappled? Excel Hidden Columns Won't Unhide On the Home tab, in the Editing group, click Find & Select, and then click Go To.

Make sure the Hidden Rows and Columns option is checked. How To Unhide Column A In Excel 2016 Activate the worksheet where this is happening. why do they give the same output? Enter your e-mail address and click "Subscribe." (Your e-mail address is not shared with anyone, ever.) Want to see what the newsletter looks like?

Please post back with what you are seeing exactly, and what you have tried, and we can take it from there. Can't See Column A In Excel Unsold Atari videogames dumped in a desert? Privacy Policy | Cookies | Ad Choice | Terms of Use | Mobile User Agreement A ZDNet site | Visit other CBS Interactive sites: Select SiteCBS CaresCBS FilmsCBS RadioCBS.comCBS InteractiveCBSNews.comCBSSports.comChowhoundClickerCNETCollege NetworkGameSpotLast.fmMaxPrepsMetacritic.comMoneywatchmySimonRadio.comSearch.comShopper.comShowtimeTech Cell A1 is now selected, even though you cannot see it on the screen.

How To Unhide Column A In Excel 2016

Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4. Thanks! Can't Unhide Rows In Excel 2013 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. How To Unhide Rows In Excel 2010 Fields that can be ordered in more than one way Word for fake religious people more hot questions question feed about us tour help blog chat data legal privacy policy work

Answer: Select the Home tab from the toolbar at the top of the screen. news Select Cells > Format > Hide & Unhide > Unhide Columns. Subscribe Get tips like this every week in ExcelTips, a free productivity newsletter. Thanks a lot! How To Unhide Column A In Excel 2007

Worked for me :) Our Company Sharon Parq Associates, Inc. Sign in Search Microsoft Search Products Templates Support Products Templates Support Support Apps Access Excel OneDrive OneNote Outlook PowerPoint SharePoint Skype for Business Visio Word Install Subscription Training Admin Unhide the Note. have a peek at these guys Being swallowed whole--what actually kills you?

Now navigate to the Review tab and click on the Protect Sheet icon. Excel Column A Missing Denise19 Jan 2016, 04:04 Thank you for this tip - it worked with first option. Press the Inspect button and the tool will start looking for hidden rows and columns.

Click on OK.

Share it with others Like this thread? Selecting the columns and modifying the width to something larger should fix this problem. What is a real-world metaphor for irrational numbers? How To Unhide Multiple Rows In Excel Nice work!

Try autofitting all columns or setting the column width for all columns to 10 if freeze panes is not the answer. Databases SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL SQLite MS Office Excel Access Word Web Development HTML CSS Color Picker Languages C Language More ASCII Table Linux UNIX Java Column A had disappeared and I couldn't get it back until I did this. check my blog Although you cannot see it, cell A1 is now selected.

Reply archie says: May 29, 2015 at 11:17 pm it is in excel 2013 Reply Maria Azbel (Ablebits.com Team) says: December 17, 2015 at 2:05 pm Hello, Archie, I'm really sorry, TY Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Oct 9th, 2013,12:20 AM #7 DaveU New Member Join Date Aug 2011 Location Waldeck, Sk, Canada Posts 18 About Tips.Net Contact Us Advertise with Us Our Privacy Policy Our Sites Tips.Net Beauty and Style Cars Cleaning Cooking DriveTips (Google Drive) ExcelTips (Excel 97–2003) ExcelTips (Excel 2007–2016) Gardening Health Now that I'm at work using Excel 2003, the last visible column in each sheet has no border lines for each cell, which for whatever reason Excel won't allow me to

AB12 Oct 2016, 17:19 This was a LIFE SAVER. Even you won't want to see all of it all the time. Subscribe Get tips like this every week in ExcelTips, a free productivity newsletter. I'll try that when I get to work tonight, thanks.

Please re-enable javascript in your browser settings. share|improve this answer answered Jun 25 '10 at 13:34 James O'Sullivan 1011 Nope, it doesn't work either. However, as soon as Jo deleted the now-redundant columns A and B, the information disappeared again. This one is driving me insane!

till A1 (invisible), select entire row (Ctrl+Shift+→), hold on Shift key, press ↓, till all 15 rows selected, set height and unhide row, still doesn't work! However, it's not possible to copy all formulas, only their results. Mapping ValueQ over a list of symbols gives answer different from direct evaluation Crossword Clue for ERECS The female equivalent of "don't break my balls" Where is the Abbey of the Now just drag the mouse pointer to the right to expand the hidden column A.

Now you should be able to see column A in your Excel spreadsheet. Joan06 May 2016, 12:18 Wow. The Go To dialog box. To hide a column, select it, choose Column from the Format menu, and then select Hide.