Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - Hidding Worksheet

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

microsoft excel training - Hidding Worksheet

Resolved · Low Priority · Version Standard

Reply Tue 11 Dec 2007, 20:02Delegate Junaid said...

Junaid has attended:
Excel Advanced course

Hidding Worksheet

Is it possible to hide a complete worksheet,eg say from sheet 1, sheet 2, & sheet 3. You can hide sheet 2,

Regards,

Junaid Qureshi

For upcoming training course dates see: Pricing & availability

Reply Fri 14 Dec 2007, 13:27Trainer Pete said...

RE: Hidding Worksheet

Hi Junaid, Thank you for your post, In answer to your question; Click on the sheet tab for the sheet you wish to hide then On the Format menu, point to Sheet, and click Hide. I Hope that helps, best regards Pete

Excel articles

· Why do we even need XML anyway?
· So Why Are There So Many File Types In Excel 2007?
· How To Learn From Your Excel Mistakes
· Why Excel Training (Sometimes) Doesn't Work and What You Can Do About It
· Data Validation In Excel: Not As Daunting As It Sounds

Excel tip:

Create own ribbon tab - Excel 2010

a. In Excel click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the New Tab button (below the list of tabs on the right hand side of the dialog box)
e. Select the New Tab (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
f. Select the New Group (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
g. Add commands to your tab and group by locating them on the list on the right hand side (remembering that you can change the list using the drop down box at the top of the list of commands) and clicking the Add button between the two panes to add them to your tab and group
h. You can rearrange the commands in your group, the groups on any tab or the tabs, using the up and down arrow buttons beside the list of tabs.
i. Click OK to apply your changes

View all Excel hints and tips