Search : in
By :

How to hide excel sheets in the workbook

Last answer on Aug 10, 2009 3:28:49 am BST Suri, on Jan 29, 2009 9:54:17 am GMT 
 Report this message to moderators

Hello,

If Excel workbook is having 5 sheets then If I want hide 3 sheets with the help of cell value ,i.e YES & No,No means sheet should hide.
format >sheet >hide option will hide a perticular & even for multiple sheets also but i want to hide with the help of cell value? I.e Suppose Work book is having 5 sheets A,B,C,D,E.
A sheet is having all sheet name in first column & 2nd column is having combo box with Yes/NO Option for all sheet name.
Now If I select YES then the selected sheet should appear & If I select NO then selected sheet should hide.
So pls suggest me how I need to impiment?

Configuration: Windows XP
Internet Explorer 6.0

Best answers for « How to hide excel sheets in the workbook » in :
Create an Attendance Report with Excel sheet Show Create an Attendance Report with Excel sheet Issue Solution Issue In the case you want to create an attendance report with Excel , here below you will find a nice example: Consider that your report will have the following...
Compare 2 excel sheet and combine uniq data Show
Comparing two excel sheets Show
How to compare 2 excel sheet and combine uniq data? ShowHow to compare 2 excel sheet and combine uniq data? Issue Solution Note Issue I have 2 excel sheets , A and B. There are redundant data in both sheets as well as uniq. All i want is to combine both with no redundant records. (A+B...
How to freeze a row in an excel sheet ShowHow to freeze a row in an excel sheet To freeze a line in an excel sheet, for example line 1: Select line 2. Go to menu Window and select Freeze panes.
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
CSS - Style sheets ShowFont properties Property Value Description font-family Specific font (Arial, Times, Verdana) Familly (serif, sans-serif, fantasy, monospace, cursive) Defines one or more font names or font families. If multiple fonts are defined,...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Ask your question Reply

1

annajones1188, on Jan 29, 2009 10:38:28 am GMT

Well what you have clearly done is to hide the columns and what you must do is the hide the sheets. You should select this option at the bottom of your screen where it is either written sheet 1/ sheet 2 (or has been renamed by any other) and use the right-click and select the Hide option and when done, click on the Unhide option by going through the same procedures

   
Reply to annajones1188

2

Suri75, on Jan 30, 2009 5:27:15 am GMT

Hi Annajones1188

My question is...?

If Excel workbook is having 5 sheets A,B,C,D,E then If I want hide B,C,D 3 sheets with the help of cell value ,
Created tru data validation as list items i.e YES/NO in SheetA

Pls follow the details SheetA is having all Sheet Name in firast column & 2nd column is having combo option "YES","NO"

Sheets Name Option
SheetB "YES"/"NO"
SheetC "YES"/"NO"
SheetD "YES"/"NO"
SheetE "YES"/"NO"

Now In sheetA, If I select ''YES" for SheetB then the selected sheetB should appear & If I select "NO" then selected sheet should hide.

So How many sheets I want to keep on my work book I will keep it & how many sheets I want to hide, I will those sheets by changing "NO"

Kindly suggest me how I need to impiment?

   
Reply to Suri75

3

 arunaiarun, on Aug 10, 2009 3:28:49 am BST

Hi,

did you got the answer. I am also looking for the same solution.

   
Reply to arunaiarun
Ask your question Reply
They need your help