Nope, neither one. Reply Post a comment Click here to cancel reply. This option examines your file for hidden properties and personal details. Use a special VBA macro to unhide all columns automatically You'll find the macro below really helpful if you often get Excel worksheets with hidden columns and don't want to waste navigate here
Try this. CHECKLIST Tips for first-year auditors For a new auditor, the first busy season can be an exciting time and a fantastic opportunity for professional growth. This window also lets you delete hidden data if you don't trust them. Share it with others Like this thread? https://support.office.com/en-us/article/Unhide-the-first-column-or-row-in-a-worksheet-d6b47608-80ee-4021-9b51-6a1f57269ec9
On the Go To Special dialog box, select the Visible cells only radio button and click OK. A helpful macro will save your time on displaying hidden columns every so often. Posts 367 Re: I can't unhide rows?
Go to the Home tab in Excel. Here’s where you’ve got to engage the not-so-intuitive trick to unhide just rows 1 and 2: Click on F5 to engage the Go To menu. Please try the request again. Excel Hidden Rows Won't Unhide Required fields are marked *Comment Name * Email * Recent Posts Google Pixel: Enable or Disable Autocorrect Google Pixel: Enable Wi-Fi Hotspot Google Pixel: How to Enable USB Debugging Google Pixel:
Generated Tue, 08 Nov 2016 09:13:55 GMT by s_wx1196 (squid/3.5.20) Toggle search Toggle navigation Subscribe Advertise AICPA.org AICPA Store English Spanish TAX All articles Business tax Employee benefits Estates and trusts Excel Unhide Rows Doesn't Work Select the hidden column A to show it in Excel Click on the header for column B to select it. Try Format|Row|Height instead of Unhide. 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
Register To Reply 02-04-2016,03:25 PM #6 jostan View Profile View Forum Posts Registered User Join Date 02-04-2016 Location usa MS-Off Ver 2007 Posts 1 Re: Can't Unhide rows? Cannot Unhide Rows In Excel 2007 All rights reserved. Is there something that's supposed to come before or after the macro? try by adjusting row height, rather than un-hide Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Feb 23rd, 2004,03:50 PM #5 Barry Katcher Board Regular Join Date
Tax The technology revolution or evolution? option from the menu list. Excel Rows Not Showing But Not Hidden One option is to highlight the entire sheet by right-clicking on the box above 1 and to the left of A. How To Unhide Rows In Excel 2010 Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Page 1 of 2 12 Last Jump to page: Results 1 to 10 of 19 I can't unhide rows?This is a discussion on I can't unhide rows? check over here Sign in Search Microsoft Search Products Templates Support Products Templates Support Support Apps Access Excel OneDrive OneNote Outlook PowerPoint SharePoint Skype for Business Word Install Subscription Training Admin Unhide the first Thanks (0) By rc.falconer 13th Jul 2007 12:29 Try thisDid you freeze panes after you hid the rows? Sorry, my internet connection keeps going kaploooie.... How To Unhide Row 1 In Excel
However, it's not possible to copy all formulas, only their results. The workbook and worksheet are unprotected. And while it works, the Unhide command will unhide the entire sheet. his comment is here CONNECT JofA on Twitter JofA on Facebook JofA on Google+ AICPA on LinkedIn HOME News Magazine Issue Library Video Topics Site Map SUBSCRIBE Print Magazine News Alerts CPE Direct CPA Letter
Open your workbook and navigate to the Home tab. Can't Unhide Row 1 In Excel Navigate to the location in your table where the columns are hidden. Click OK to save the changes.
Make sure the checkboxes Select locked cells and Select unlocked cells are ticked. Now go to the Format menu, click on Row and Unhide, and rows 1 and 2 will appear. option from the menu. How To Unhide Multiple Rows In Excel From now on, anyone who tries to unhide the columns in your Excel table will get the Unhide option disabled.
When I do that, the Unhide option is not greyed out and achieves what you are trying to do. Remember Me? Excel: featured articles Сompare 2 columns in Excel for matches and differences Merge Excel rows without losing data Creating a drop down list: static, dynamic, from another workbook Merge 2 columns weblink Resourceful.
Now just right-click above your table and pick the Unhide option from the menu. How can we improve it? If any questions left, feel free to comment on the post using the form below.