how to make a sheet invisible?

S

sumesh56

i want to know how to make a sheet invisible. if the sheet is invisibl
how can i go to the sheet concerned? suppose i have a worbook with
sheets on it. they are named as blue,green,red and yellow. now i want t
make the red sheet invisible what should i do? then if i want to make i
visible what steps are to be taken. thanks. have a nice day
 
G

GS

i want to know how to make a sheet invisible. if the sheet is
invisible how can i go to the sheet concerned? suppose i have a
worbook with 4 sheets on it. they are named as blue,green,red and
yellow. now i want to make the red sheet invisible what should i do?
then if i want to make it visible what steps are to be taken. thanks.
have a nice day.
Click to expand...

Format>>Sheet>>Hide/Unhide (XL2003 and earlier)

Home tab/Cells section:Format>>Visibility>>Hide & Unhide (XL2007+)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make report 0
Program buttons to create a word document 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
Help with formula 0
how to get the resultsheet from the markslips 0
Need to reorganize - transpose columns to rows per article number 1
How to make the shading look uniform around a double spaced line in MS Word? 0
How to filter rows data based on background color of individual cells 3

Top