In order to unhide a sheet that was in a file that originally was protected, you may have to: 2. If … Y ou can right click a sheet tab and select Hide, but it is just as easy to Unhide the sheet. It’s a bit of a conundrum. I am using excel 16. Excel 2010/2013: Right click in the empty area to the right of The Ribbon (1), select Customize the Ribbon (2), Note: Excel 2007 – click the Office Button (big round one at the top left), click the Excel Options button at the bottom and in the first section (Popular), tick Show Developer Tab in Ribbon. Select all rows above and below of your 7 rows and increase rows height from format menu. Now I need to expand the spreadsheet and use more columns. VBA to unhide/hide rows in separate sheet based on cell value. I have office 365. Last week I heard from a customer who was trying to unhide a worksheet. If I hide new columns show does work. Protect, then unprotect the workbook if none of the above worked. 6. Some time ago I created a spreadsheet and greyed out the areas that weren't needed. The hide / unhide options are not even appearing as an option when I right click on my mouse. Go to Format>Column>Hide. Click on the header of the column or row that you would like to hide and the column or row will be highlighted; On the Home tab, in the Cells group, select Format; Under Visibility, select Hide & Unhide, and then Hide Columns (or Hide Rows … Now you’ll see a list with all hidden (not very hidden) worksheets. I didn't write any macros and usings the right-click unhide method is proven futile. I learned this by accident. However, since Excel has to keep track of changes made by both users to a cell, it does not allow any user to merge cells while it is in shared mode. On the Home tab, in the Editing group, click Find & … The Excel add-in Professor Excel Tools provide a function for unhiding all hidden rows and columns on all sheets with one click. If you find that the Protect Sheet option is grayed out, it likely that you are dealing with a shared worksheet. I tried to unlock but they weren't locked and the spreadsheet isn't protected. see attachment... the original s/s may have been created in a previous version of excel or may have been a csv file, (if this point is relevant) Use a password breaker if necessary. We can apply the Unhide Sheet feature to unhide a hidden worksheet at a time in Excel. Last Updated: November 17, 2020 Close. Some time ago I created a spreadsheet and greyed out the areas that weren't needed. I’m guessing you only have 1 worksheet in the file and you were trying to hide that sheet? If you are unable to unhide certain sheets in your Excel, the following troubleshooting tips may shed some light … Follow the below steps to use this method: First of all select one column on either side of the hidden column. Right-click one of the selected row numbers. But with the arrival of COVID-19, the stakes are higher than ever. Click the ""Format"" button in the ""Cells"" section of the toolbar. – Open the zip file. It is also not an unhiding issue. Excel has a more secure setting known as “Very Hidden”. 5. You can easily extend the basic syntax that I introduce in the … Hide rows in Excel is really helpful. You will get the error that Alfred saw. Therefore, right click on any sheet name. Right-click on the chart. Thanks to all authors for creating a page that has been read 321,701 times. There is a possibility you did not hide the rows but reduced your rows' height to minimum. Click on Unhide. Here is how it’s done . "I had some rows hidden and couldn't figure out how to unhide the rows. You can use many of the methods covered above, with a little bit of extra work. In many situations, the fastest way to unhide rows in Excel is to double click them. To unhide all hidden rows in Excel, navigate to the "Home" tab.. 2. To use the function, click on “Hidden Rows and Columns” in the “Professor Excel” ribbon. Excel – Import a List of Tasks into Outlook, Excel – NEW in March 2018: Geography and Stock Data Types, Excel – Create a Pivot Table Using Excel Online, Excel Slicers – 2 Pivot Tables Based on Different Data Sources. To unhide the hidden columns, please refer to Ctrl+Shit+0 if you like using shortcut or follow the steps below: Step 1: Select columns or the whole worksheet by clicking the top left corner; Step 2: Right-click and select "Unhide" from the dialog box; Step 3: The hidden column will show up. Trouble is I've forgotten how to unhide those columns. If your excel doesn’t already have a VBA module, please insert one by clicking on the Insert menu in the VBA window. The “Select All” button is located at … How to unhide specific rows in Excel The password is optional Protect Workbook (which is not full proof) option will give you an additional layer of security that no one is able to unhide your sheet unless they unprotect the workbook (and know your password). #5 select the column … How to unhide all rows in Excel. Select the columns on both sides of the hidden column. You can also click any cell in the document and then press. Appreciate any assistance. – Expand the “xl” folder … When the GoTo window appears, enter A1 in the Reference field and click on the OK button. After free installing Kutools for Excel, please do as below: Select a range you want to display only, and click Kutools > Show & Hide > Set Scroll Area. Unhide All Rows: Select "All" on your Excel spreadsheet. The easy solution if you want to see or unhide the rows or columns is to remove the Freeze Panes. You can unhide row and row both with the same method Let’s get this with an example. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f0\/Unhide-Rows-in-Excel-Step-1-Version-10.jpg\/v4-460px-Unhide-Rows-in-Excel-Step-1-Version-10.jpg","bigUrl":"\/images\/thumb\/f\/f0\/Unhide-Rows-in-Excel-Step-1-Version-10.jpg\/aid3351758-v4-728px-Unhide-Rows-in-Excel-Step-1-Version-10.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"