Teach Yourself Excel Lesson Course Outline - Course Outline

How can I create a list of items in a cell? And how can I tell Excel where to
wrep-around? So want something a cell that looks like this

1. Introduction
2. Body of Text
3. Conclusion

I'll want to repeat that in a number of cells. I know that I have to change
the cell height? But how do I get it wrap so it looks the way I want it?
Thanks.

Hey,

I have a problem, the file i use at work my boss has created from older files so he does not have to create from scratch. The problem is that he has created these files from older files that were created from older files that were created from older files and that goes back probably to the start of excel. For whatever reason, i cannot use the group/outline features in his workbooks and i am wondering if there is a fix to this issue. Other features like the precent and decimal button also do not work. any help is appreciated.

Thanks,

-Dude

Hello,

I want to make a copy of an entire sheet inclusive several groups. In Excel 2003 you can simply select the entire sheet and then use an ordinary copy/paste into a new sheet. The new sheet gets the same grouping as the original sheet. But this doesn't work in Excel 2007. The grouping is missing in the new sheet.

Do anyone know how to do this in 2007 ? I will be very happy for a solution since i have struggeled many days now...

Regards
Jan Erik
Norway

Is there a way to import the outline levels into Excel?

My challenge is that I am attempting to import MS Project information into Excel. I export the Outline Level (1, 2, 3, etc) with my other fields from Project. I know how to use the Outline Level to add spaces and create the right visual tiering effect in Excel (=REPT(" ",(H2-1))&B2) , but want to use this information to create an Outline List (Level 1, Level 2, Level 3, etc) in Excel.

Thanks.

1. Select cells to group (see cells A2:A4 in the screenshot).
2. Select Data -> Group (in Outline Group).
Or
Press Alt+Shift+Right Arrow and click OK.
3. Repeat the above steps and add group & outline to more sections.
4. To clear groups & outlines, select the same rows or columns, and Select Data -> Ungroup (in Outline Group).

Hey All,

so I am sending some text from excel to a word document. I would like to create an Outline list for this information with two levels:
1) a.
I know how to create a regular list, but I have no idea how to tell word to execute the second list level! This is the code I have right now:

Code:

Sub CreateNewWordDoc()

Dim wrdApp As Object
Dim wrdDoc As Object
Dim textvar As String

    Set wrdApp = CreateObject("Word.Application.11")
    wrdApp.Visible = True
    Set wrdDoc = wrdApp.Documents.Add

With wrdApp.Selection
    .Range.ListFormat.ApplyListTemplate ListTemplate:=wrdApp.ListGalleries(wdOutlineNumberGallery).ListTemplates(1), ContinuePreviousList:=False, ApplyTo:= _
        wdListApplyToWholeList, DefaultListBehavior:=wdWord10ListBehavior

    .TypeText Text:="First line with level one"
    .TypeParagraph

    .Range.ListFormat.RemoveNumbers NumberType:=wdNumberParagraph

I'd like to invert the outline controls in the Outline pane of MS Excel. I'd like to use it like a tree control where the '+' sign is next to the parent and selecting it expands it's children. I did this years ago but can't figure out how to do it now in Office 2007. any suggestions?

- todd

I have a document with group and outline applied in Excel 2007. The plus symbols show along the lefthand side. However, the 1-2-3 do not show on the left so you can see all Level 2s, for instance. I checked the Advanced Option and verified that the check box is checked to Show outline symbols if an outline is applied.

Any other ideas as to how I can get that 1-2-3 to show?

Thanks for your help!

Marie

Hi Guys,

I have a MS Project document that i am trying to re-create in Excel using the outline function but not having any luck as the auto outline function doesnt seem to work............

anby suggestions?

I'm having trouble with some Excel functionality. I have a spreadsheet that
is heavily dependent on the Outlining functions, and being able to 'roll up'
data. It has many rows that are merged, and contains many functions, and I
want to protect the sheet. Unfortunately, if you protect the sheet, the roll
up capabilities of the Outline function are no longer available. You're
essentially stuck with whatever view was visible when you protected the
sheet. Help!