Re: How to remove the ' ^ etc. in Excel 2007?

I don't have 2007 but in earlier versions those were left, center and
right-aligned marks caused by having Transition Navigation Keys enabled in
Tools>Options>Transition.

Maybe 2007 still retains this Lotus feature?


Gord Dibben MS Excel MVP

On Sun, 18 Mar 2007 09:55:00 -0700, Laibeus Lord <Laibeus
Lord@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Hi,

How do I remove the ' ^ etc. from showing in Excel 2007? It tends to
make the online search useless because it affixes those symbols (symbols for
bold, center, etc.)

Here's a sample screenshot ->
http://farm1.static.flickr.com/154/425405578_2c281a695b_m.jpg

In the screenshot, there is ' If I remove it, the text/cell formatting
is deleted as well. If I say, bold it again or otherwise, it will come back.
I tried turning off everything in Excel 2007 settings, but for some reason
it still stays, so I'm really at a lost as to what setup it really is or
where can I find that setup.

Thank you very much!!

.

Relevant Pages

  • Re: Multi Page Header Row For Reports
    ... Gord Dibben MS Excel MVP ... You need to go into the page setup and select the 'sheet' tab. ... Under the print titles section you will see an option called 'Rows to repeat ... doesnt help me when i have to print the document for my colleagues, ...
    (microsoft.public.excel.misc)
  • Re: How to keep column headings from being sorted with data?
    ... i.e. Bold or Centered or similar. ... Save the workbook and the setting should stick. ... Gord Dibben MS Excel MVP ... Is there a setting to keep the top row from sorting with the rest? ...
    (microsoft.public.excel.newusers)
  • Re: Never Looped before
    ... .Bold = True ... MS Excel MVP ... format row 6 based on the value in row 5. ... I know that the conditional format ...
    (microsoft.public.excel.programming)
  • Re: Printing side by side?
    ... Gord Dibben MS Excel MVP ... In Page Setup, I have the Page Order as "Down then Over", but that isn't getting what I want. ... Nothing else seems to print multiple pages side by side on a single sheet. ...
    (microsoft.public.excel.printing)
  • Re: Sort by font format
    ... See Chip Pearson's "Sortbycolor" code. ... Gord Dibben MS Excel MVP ... by other font attributes (e.g., bold) for different reasons, and now wants to ...
    (microsoft.public.excel.misc)
Loading