MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

How To Edit Workbook in XML Level

  Asked By: Boell    Date: Dec 31    Category: MS Office    Views: 1690

Usually in Microsoft Excel 2000 and 2003,
I could edit the workbook in XML level,
so I could do these things: make some
character raised and lowered with <sup>
and <sub> tag, and insert a break line
tag <br>.

But recently i bought new notebook with Windows
Vista and Microsoft Excel bundled with. After
a while, I realized that I can not edit the
file in XML level.

So, to get a sentences with a certain break line
position, I've used to worked around with inserting
the sentence as a formula and put the CHAR(10) to make it
start in new line. e.g:

="The Quick Brown Fox" & CHAR(10) "Jumps Over The Lazy Dog"

The result displayed in the cell is:

The Quick Brown Fox
Jumps Over The Lazy dog

But I felt this methode is not convenient to do also I still
could not get a methode to raised and lowered the chararacter.

So the question is how to able edit the workbook in XML level
just like the Microsoft Excel 2000 and 2003?



4 Answers Found

Answer #1    Answered By: Fadwa Ahmed     Answered On: Dec 31

1) What is a miliser?

2) How do you edit  a workbook  in XML with Excel 2003?

If I have the answers to both these questions i might be able to decide:

1) If the question is addressed to me.

2) If I can attempt an answer.

Answer #2    Answered By: Bin Fischer     Answered On: Dec 31

The answer for number 1:
It's my style to call you all my fellow friend in mailing list.

The answer for number two:
Using Microsoft Script Editor, you can access it from
Tools-Macro-Microsoft Script Editor
or with the keyboard shortcut: Alt + Shift + F11

Answer #3    Answered By: Rudy Turner     Answered On: Dec 31

If I understand you right, what you are trying to do is formatting
subtext within a cell. There's a simpler way to format text like
superscript/subscript or add blank lines with a cell and subtext.

To format text to superscript/subscript, in the formular jus
highlight the characters you want to format then right click, then
select "Format Cells..." and choose your formatting from the dialog

To add a blank line within a cell, just place the cursor where the
blank line needed to be and hold down the "Alt" key follow by
the "Enter" key...

Answer #4    Answered By: Zivah Levi     Answered On: Dec 31

These simple solution never accross in my
complicated mind. Thank's for your advice
especially the ALT + Enter keyboard shortcut.

Didn't find what you were looking for? Find more on How To Edit Workbook in XML Level Or get search suggestion and latest updates.