Forum home » Delegate support and help forum » Microsoft Excel Training and help » training in excel - Hiding cells

training in excel - Hiding cells

ResolvedVersion Standard

Wed 15 Aug 2007, 15:53 Delegate Fazil said...

Fazil has attended:
Excel Advanced course

Hiding cells

Hello,

I usually have to send my worksheets to other team-members and would like to know if it is possible to sent a worksheet with only the active sheets visible. I mean, when senting a table, is is possible to hide the rest of the worksheet (apart from the table)

Regards... Fazil

Thu 16 Aug 2007, 12:05 Trainer Carlos said...

RE: Hiding cells

Fazil

To Hide a worksheet in a workbook:

1. Select the worksheet to be hidden

2. In the Format menu, Select Sheet / Hide

To Unhide the sheet(s)use the same steps except you select Unhide.

A dialog box appears listing all the hidden sheets. Select those to be unhidden and click OK.

Regards

Carlos

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Conditional formatting for cells that return text , not picked up by Go to command

If you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text.

Then try this. Select the range the formula cells appear in on your sheet. Format, select Conditional Formatting menu. In the dialog box under Condition 1, select "Formula Is" from drop down. Next to it in the Formula Box, enter the formula =Istext(A1. Click Format button , choose desired formatting settings and click OK. To go ahead and apply the conditional formatting click OK to accept

View all Excel hints and tips

training in excel - Hiding cells

Hiding cells

RE: Hiding cells

Excel articles

Excel tip:

Conditional formatting for cells that return text , not picked up by Go to command