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 courses tate - How Do I Remove Outline from an Excel Worksheet?

	98.1 % recommend us
	More live stats...

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

Training information:

microsoft excel courses tate - How Do I Remove Outline from an Excel Worksheet?

Resolved · Low Priority · Version Standard

Reply Fri 23 Nov 2007, 11:30 Edited on Fri 23 Nov 2007, 11:31Trainer Sandy said...

How Do I Remove Outline from an Excel Worksheet?

How do I remove an Outline which appears on a worksheet everytime I open it?

Please help
Thank You

For upcoming training course dates see: Pricing & availability

Reply Fri 23 Nov 2007, 11:32Trainer Sandy said...

RE: How Do I Remove Outline from an Excel Worksheet?

To remove the Outline

Just click your cursor anywhere on your worksheet

Select Data menu, Group and Outline, choose Clear Outline

Your worksheet data will return to exactly as it was before you created the original outline.

We cover this topic on our Intermediate course, please check our syllabus for more details.

Excel articles

· How To Use The Subtotal Function In Excel
· Advanced Excel Training - takes you to the next level
· What's mine is yours: Sharing data in Excel
· How to check for and reduce errors in Microsoft Excel
· How To Create A Multiple Pie Chart In Excel

Excel tip:

Move data worksheet to worksheet

To move data from one worksheet to another, highlight the data.

Select and hold down the ALT key and position the mouse on the border of the selection until the mouse pointer displays four-headed arrows.

Drag the selection down to the destination worksheet tab.

When the arrow touches the tab, Excel switches to the desired worksheet. Now drag the selection to the correct position. Let go of the mouse and then the ALT key.

To copy data from one worksheet to another, select and hold down the CTRL+ALT keystroke combination and perform the steps above.

View all Excel hints and tips