Excel for Mac: How to shut off autoformatting?

Factual Questions
1

Grr. I type a URL into a cell, hit enter, and it makes the font gigante!

Or it changes the color of a cell to that of another in the column!

This shit’s useless, how do I just turn it off?

2

Is this the same as “autocomplete”? if it is,

Tools—>Preferences—>Edit—>Uncheck “Enable AutoComplete for cell values.”

If it’s not the same as “autocomplete,” it might be something similar.

3

With Excel and Word, you generally have to change settings in several places to get the damn program to stop doing annoying crap like this. Look not only in the Preferences panel, but also the Auto-Format and Auto-Complete menus to see if there are settings there that affect URL formatting. I don’t have a copy of Excel on the machine I’m using so I can’t be more specific right now.

I use NeoOffice on my OS X-only machine because the copies of Excel and Word I have are OS 9 and seem to be somewhat unstable under Classic emulation, so I use my older computer which can still boot into OS 9 for things I simply must have the real deal for. I’m not a power user of Excel or Word, so it’s rare that I do that. NeoOffice is a bit slow, but I’m not about to spend $400 for the most recent versions of those admittedly useful torture devices unless I really, really have to. So far, I haven’t.

4

I just can’t anything in the Mac Excel menus that allows you to turn off the program’s formatting adventures. (The advice about looking in tools applies to Windows but not to Mac). Anybody know?

5

Are you sure about Tools? I haven’t been on a Mac in a while but skimming advice cites seems to imply that Tools is a menu choice, and within that you can check and uncheck “Options”.
Looks like there are also steps you can take from within your browser:

If you have Microsoft Internet Explorer (Internet Explorer: A Web browser that interprets HTML files, formats them into Web pages, and displays them to the user. You can download Internet Explorer from the Microsoft Web site at http://www.microsoft.com.) 4.0 or later, you can turn off the feature that automatically suggests a match for file names and URLs (Uniform Resource Locator (URL): An address that specifies a protocol (such as HTTP or FTP) and a location of an object, document, World Wide Web page, or other destination on the Internet or an intranet, for example: http://www.microsoft.com/.) as you type them. This affects entries in the Insert Hyperlink and Open dialog boxes in Microsoft Excel and also URLs in Internet Explorer and any other Microsoft Office programs you have.

Start Internet Explorer.
On the Tools menu, click Internet Options, and then click the Advanced tab.
Under Browsing, clear one of the following check boxes:
If you have Internet Explorer 4, clear the Use AutoComplete check box.
If you have Internet Explorer 5, clear the Use inline AutoComplete in integrated shell check box.
If you have Internet Explorer 6, clear the Use inline AutoComplete check box.

–from MS Office Online Help linked within Excel

6

C’mon, someone has Excel for Mac, someone knows this.

No offense to those who have tried to help thus far, but the menus in the Excel version are VERY different.

Thanks.

7

What OS are you using, and what version of Excel?

8

Yes, please, because googling certainly shows plenty of references to the Tools menu in Excel for Mac.

9

This is only happening with URLs, correct?

I have Excel 2004, running under OSX 10.3.5. From the menu at the top, select Format > Style. In the pop-up window, select Style name: Hyperlink, then make whatever modifications you want to the display style.

Since I’ve never dinked around with this before on my Mac, it appears that the default style for hyperlinks is something like Verdana 10, underline blue. You must have inherited your formatting from someone else’s modified file.

10

Oh, and there is indeed a Tools Menu in Excel for Mac, right next to the Format Menu, but it’s reserved for things like spell checking, auto-correct, tracking changes, auditing, macros, etc.

11

And at the bottom, does it have “Customize” and “Options”?

12

gigi, the bottom of the Tools menu in the version I have has

Customize > Customize Toolbars/Menus…
> Customize Formatting Palette…
> Customize Keyboard…

and

Wizard > Lookup…
> Conditional Sum…

The customize options here relate to what buttons you want to have appear in the toolbars, etc. They don’t offer any options for actual formatting of cells, which is handled under the Format menu

Format > AutoFormat…
> Conditional Formatting…
> Style…

13

I should mention that those menu items are in addition to the usual Cells/Row/Column/Sheet formatting functions.

14

Yep; I thought that Customize was the second-to-last choice and that Options was last but it doesn’t sound that way!

15

  1. We are all, apparently, using “Excel for Mac.”

  2. Since you understand that “the menus in the Excel version are VERY different,” why haven’t you told us which version you’re using?

  3. If you’re asking people for help with a problem, how do you expect us to help without the relevent facts?

16

Thanks, sunfish, you answered my question in quite a skillful, succint, and polite manner.