unhide - Developer IT

Hide and Unhide Worksheets and Workbooks in Excel 2007 & 2010

- by DigitalGeekery

Hiding worksheets can be a simple way to protect data in Excel, or just a way reduce the clutter of a some tabs. Here are a couple very easy ways to hide and unhide worksheets and workbooks in Excel 2007 / 2010. Hiding a Worksheet Select the Worksheet you’d like to hide by clicking on the tab at the bottom. By holding down the Ctrl key while clicking you can select multiple tabs at one time. On the Home tab, click on Format, which can be found in the Cells group. Under Visibility, select Hide & Unhide, then Hide Sheet. You can also simply right-click on the tab, and select Hide. Your worksheet will no longer be visible, however, the data contained in the worksheet can still be referenced on other worksheets. Unhide a Worksheet To unhide a worksheet, you just do the opposite. On the Home tab, click on Format in the Cells group and then under Visibility, select Hide & Unhide, then Unhide Sheet. Or, you can right-click on any visible tab, and select Unhide. In the Unhide pop up window, select the worksheet to unhide and click “OK.” Note: Although you can hide multiple sheets at once, you can only unhide one sheet at a time. Very Hidden Mode While hidden mode is nice, it’s not exactly ultra-secure. If you’d like to pump the security up a notch, there is also Very Hidden mode. To access Very Hidden setting, we’ll have to use the built-in Visual Basic Editor by hitting the Alt + F11 keys. Select the worksheet you wish to hide from the dropdown list under Properties or by single clicking the worksheet in the VBAProject window. Next, set the Visible property to 2 – xlSheetVeryHidden. Close out of the Visual Basic Editor when finished. When the Very Hidden attribute is set on a worksheet, Unhide Sheet is still unavailable from within the Format setting on the Home tab. To remove the Very Hidden attribute and display the worksheet again, go back into the Visual Basic Editor by hitting Alt + F11 again and setting the Visible property back to –1 – xlSheetVisible. Close out of the Editor when finished. Hiding a Workbook To hide the entire Workbook, select the View tab, and then click the Hide button. You’ll see the Workbook has disappeared. Unhide a Workbook Select the View tab and click Unhide… … and your Workbook will be visible again. Just a few simple ways to hide and unhide your Excel worksheets and workbooks. Similar Articles Productive Geek Tips How To Copy Worksheets in Excel 2007 & 2010Add Background Pictures To Excel 2007 WorksheetsMake Row Labels In Excel 2007 Freeze For Easier ReadingImport Microsoft Access Data Into ExcelMagnify Selected Cells In Excel 2007 TouchFreeze Alternative in AutoHotkey The Icy Undertow Desktop Windows Home Server – Backup to LAN The Clear & Clean Desktop Use This Bookmarklet to Easily Get Albums Use AutoHotkey to Assign a Hotkey to a Specific Window Latest Software Reviews Tinyhacker Random Tips DVDFab 6 Revo Uninstaller Pro Registry Mechanic 9 for Windows PC Tools Internet Security Suite 2010 Discover Latest Android Apps On AppBrain The Ultimate Guide For YouTube Lovers Will it Blend? iPad Edition Penolo Lets You Share Sketches On Twitter Visit Woolyss.com for Old School Games, Music and Videos Add a Custom Title in IE using Spybot or Spyware Blaster

Search Results

Search found 79 results on 4 pages for 'unhide'.

Page 1/4 | 1 2 3 4 | Next Page >

- by DigitalGeekery

- by user1305810

- by blacklaptop

- by LikeToCode

- by Mike

- by I AM L

- by RAGOpoR

- by Anne Manke

- by Ben

- by Jignesh

- by ieback

- by Brian Dant

- by xiaodai

- by Tanu Sood

- by Eric Belair

- by Rising Star

- by Srisa

- by Srisa

- by rahulkamath

- by Breanne Cooley

- by monica.kumar

- by Ike

- by itsols

- by ybbest

- by lupital

1 2 3 4 | Next Page >