Best Offer for Books in Amazon

Showing posts with label show or hide sheets in excel workbook. Show all posts
Showing posts with label show or hide sheets in excel workbook. Show all posts

Tuesday 9 May 2017

How to Hide or Show Worksheets in Excel

Show or Hide Worksheets 

It is very easy. You can hide any sheet in your excel work book. when ever you want you can make sheet visible. follow the below steps to make hide sheets or show sheets in excel workbook

step 1:

















in the above screen shot, We have 3 sheets by default in excel workbook, to Hide sheet 1 , right click on sheet click to 'Hide' option.

Step 2:
















Once you click hide button, you are able to see only 2 sheets in your workbook,

Steps for Unhide Sheet

1.right click and Click 'Unhide' 
2.Select Your Sheet 1
3.Click to 'OK'




How to Protect sheet in Ms-Excel

STEPS:  1. OPEN Ms-Excel 2. Go to Review-> Protect Sheet -> Protect sheet  3. enter Password -> Re-enter Password-> save.