Office for Mac Forum - Answered Threads

With cells formatted for time, I can multiply by 2, but not 3 or more. Is there a way?

Wed, 16 May 2012 18:20:50 Z

cell A1 00:04:45

Cell B1 2*cell A1 produces answer 00:09:30

Cell C1 3*cell A1 doesn't work!

How do you disable files folders for xml, and maitain proof of when a document was created?

Tue, 15 May 2012 19:31:49 Z

Greetings,

I have a new I-Mac, replacing an old Toshiba. I quite recently purchased Office for Mac, and copied my books from Word 2007 for the PC to my I-Mac.

My first question is this: Every time I save, an additional folder is created, and two files are in it. This makes my folder of hundreds of papers and folders become very messy and disorganized. If the paper is called “Test Page” then it saves “Test Page_files” and has filelist.xml and themedata.xml in it. When I delete this folder, all my information seems intact, so, for sanity purposes, how can I get rid of this disturbance?

My last question is this: In Word 2007 I am able to click on the properties of a document and it will tell me when I created it. Now, in Word 2011 for Mac, everything says it was created the first time I open it. Due to the nature of my work, I need to prove that I have been working on some of these books for years. Is there a way to maintain the integrity of my work?

I certainly thank you for any assistance you can provide.

How do I concatenate a phone number, formatted 000-000-0000 into a long string of concatenation in Mac excel 2011

Tue, 15 May 2012 19:18:00 Z

The phone numbers in the original column are custom formatted to all look like this: 555-555-5555, When I concatenate them with the other columns it removes the custom format. How can I retain the formatting of the cells in that column within the concatenation formula?

callouts won't overlay a picture in a word doc.

Tue, 15 May 2012 16:47:20 Z

I can't seem to use the callouts on top of a photo I have inserted into a word doc (Office Mac 2008).

I am updated, with snowleopard. Every time I put a callout on top of a photo the photo shoots off to the side.

Never had this problem with word 2004.

Appreciate any advice.

VLOOKUP referencing different workbook

Tue, 15 May 2012 15:38:20 Z

I am trying to use a VLOOKUP formula to bring data into my current worksheet. The object table is in a separate workbook. I keep getting an #N/A error. Will Excel for Mac not look up something in a different workbook?

Create a post to a blog in sharepoint 2010

Tue, 15 May 2012 12:26:51 Z

Is it possible to create a post to an blog which is provided by share point 2010 ? I use this feature with word 2007 for windows. But I would like to use

it also on my macbook with word for mac.

MSW 2008 12.2.7 Right side scroll bar vanished... help?

Tue, 15 May 2012 02:02:08 Z

My right hand scroll bar just vanished - MSW 2008 v 12.2.7 - I can't seem to get it back - reopen etc... any clues?

Mac Word - Notebook View

Tue, 15 May 2012 00:37:13 Z

I just switched back to a Mac after being a PC user for 15 years. Partially because my children get iPad's at school (must be nice). I teach at a University and have used the notebook view for my highly detailed syllabus. It looks amazing - and will be very easy for students to use. However, I'm wondering how I allow them to see the format (with tabs and all the gadgets) if they don't have a Mac. THere has to be a way to save or store the doc so others (non-Mac) users can use it in its VERY useful and appealing format. RIght?!?!

Imported templates into the User Templates directory are grayed out

Tue, 15 May 2012 00:09:41 Z

On another note, I have imported templates into the User Templates directory from a windows PC and they show grayed out and un-selectable. How do I access them?

Mel Underhill

[New question split from this thread by moderator]

Customizing the numeric keypad

Mon, 14 May 2012 21:25:32 Z

I am helping a friend update her current compute environment.   She is an avid Word 5.1 user (yes, still on Mac OS 9.2.2 on an old Mac G4!) and was absolutely overjoyed when I showed her some of Clive Huggan's documents that supported her view that 5.1 is a vast improvement over its successors!

I have finally convinced her of the need to upgrade her aging and failing hardware, and that part of this will involve leaving 5.1 behind.   The new environment consists of a Mac Mini running OS 10.7 (Lion) with Word 2011. I am trying to help her make the transition as painless as possible by duplicating her current environment as closely as I can. Clive's writings have been very helpful in this regard.

There is one major hurdle I have been unable to overcome. She has made very heavy use of keyboard customization, and has most every function key as well as all the keys on the numeric keypad bound to her favorite commands. These keystrokes have been wired into her neurons over the course of two decades of use. In trying to duplicate these customizations, I find that I can't bind a single key on the numeric keypad to a command. If I combine it with the Control or the Command key modifiers, it accepts it just fine, and it shows up in the customization window as, for example, "Control+numpad5". But I can't get it to accept the lone keypad key, i.e. "numpad5".

I know that Mac OS has, over time, "appropriated" several function keys and other keystrokes for higher level functions.   But loss of the lone numeric keypad keys is a real show stopper for my friend.   Does anybody know of a way to solve this problem?

Many thanks in advance. This is a wonderful site!

Clive Dawson
Austin, Texas

Problem with font when using forms toolbar

Mon, 14 May 2012 21:08:29 Z

I am using the forms toolbar to add text form fields, however, the field defaults to a font I do not want to use. I've tried manually changing the font in the field by selecting it, but it does not work properly or consistently. Is there a way to change the font to default to the font I am using in the word document?

Thank you.

Data is there - But I can't see it

Mon, 14 May 2012 19:38:06 Z

I can't "see" any data in my cells in an Excel spreadsheet. The data is there (confirmed in the dialogue(?) box in the tool bar area) and if I send the file to a different computer they have no problem opening it up and seeing it. Same thing goes for several Word documents. I have the most recent Office and Mac operating systems. Do I have my settings messed up?

i need to justify one paragraph but button doesn't work.

Sun, 13 May 2012 21:39:19 Z

I was able to do this prior to 11. Is there a way to force a justification for only one paragraph in a document. This is a requirement in APA 6. Why when I highlight a graph won't it justify. Even when I cut and paste with the button highlighted, it won't work. I'm using Lion 10.7.4

I need help fast. My paper is due.

Documents are opening up by themselves and multiples are shooting acros the screen

Sun, 13 May 2012 20:46:07 Z

I think the problem may lie in the fact that most are scanned and don't like being added to or copied? Sometimes I can add a comment to one document and save it but then it will appear as a completely blank document with just the comment visible.The same document keeps popping up on screen multiple times,even though I haven't clicked on it. All this shinanegans is slowing me down.The same happens with PowerPoint when I'm about to close my laptop down,it will pop up and I can't exit the program for a while,Excel has also popped up unexpectedly.

Trying to add an existing Customer Dictionary

Sun, 13 May 2012 19:28:37 Z

Trying to add a customer dictionary to word 2011 for Mac. When I go to the screen in spelling and grammer that lets me add new dictionaries, the dictionary is greyed out. I can click add just fine, and can add new dictionaries to where-ever I want, but for some reason the actual file with .dic extension is greyed out and when I double click on it like the documentation that I can find online says to do, the window does not select the file and go away as one would expect, it just sits there and does nothing. The open button on this file selection window is also greyed out. The custom dictionary in question worked fine for Word 2008 for Mac, and all editions of word for the PC since time in memorial. Just wondering if anyone knows why my extensive library of custom words that I have painfully created over the years suddenly does not work....

Any help would be greatly appreciated.

Outlook 2011 IMAP account causes Error 1025 "Invalid Mailbox Name"

Sun, 13 May 2012 19:14:12 Z

Split From: "new update 14.2.2 deletes the IMAP accounts"

To be honest I didn't check the other ones, before I read your reply I have defined the IMAP account again and it is working fine. But I have one problem and I couldn't solve it and I am searching the whole web and I did many suggested solutions but until now I have this problem

I get in Outlook 2011 for Mac the error message 1025 "Invalid Mailbox Name" for the IMAP account only. The rest are fine....Please can you tell me at least any answer that will make me even stop searching about a solution....if there is no solution then please let me know

selection de lignes sur word pour Mac

Sun, 13 May 2012 19:03:16 Z

bonjour,

je ne sais pas pas quels '' raccourcis clavier'' utilisés pour sélectionner des lignes ( qui ne se suivent pas )

merci beaucoup de vos conseils avisés

bien à vous

Sylvie

Sorting and Separating info

Sun, 13 May 2012 17:09:54 Z

I want to create a macro so that I can create a report on employee progress. The macro works fine as it gives me what I need to a certain point. It sorts and deletes info I dont need....so far so good!

Now, what i want to do is separate the employees by inserting a blank row between each employee without having to scroll and inserting manually. The following is an example of what I have:

A1 Ann

A2 Ann

A3 Ann

A4 Ann

A5 Charlie

A6 Charlie

A7 Charlie

A8 Charlie

Imagine that info starting in cell A1 to A8. Cells B1 to B8 have other info that I want to keep

What I want to do is insert a row between A4 and A5 which would look like this:

A1 Ann

A2 Ann

A3 Ann

A4 Ann

A6 Charlie

A7 Charlie

A8 Charlie

A9 Charlie

Please note that there are about 30 employees and I need to insert a row between each employee name. Also note that the numbers change every day because the report I receive shows the employees calls per day (which is never the same and if one or more of the employees are absent, their name will not even show on the report. Any help on how to do this would be greatly appreciated as it would save me a bunch of trouble every day

Thanks in advance to all

Bug with Mac Word 2011: Text Disappear when holding shift with direction button and more

Sun, 13 May 2012 13:07:16 Z

I am using Mac 2011 Word specifically. When I hold shift and move my cursor with direction button, the text disappears as if been deleted. If I highlight a certain text with my mouse and press any of the following keys: caps lock, control, option, fn, command, the text disappear too as if been deleted. This happen only on Office mac and not in any other application.

My mac keeps switching between screens!!! automatically:/

Sun, 13 May 2012 12:02:04 Z

Im working on a school paper in which i am using several word document, the problem is that i often have one document i screen 1, one in screen 2 and one in screen 3, and then my mac will after its own choice keep jumping from screen one to screen two whenever i am not doing anything with the document. which is pretty annoying when I'm trying to read through my paper.

Does anyone have a clue to why this happens, is it some options i can change?

How to Sub Total one column of data for every change in another column

Sun, 13 May 2012 07:04:33 Z

How do you get a Sub Total for every change in a column of data. There used to be a Data Group and Outline Window that would make this easy, and it seems to have disappeared in Excel 2011. You would select a column, say AMOUNT, and then select sub total for each change in column CATEGORY. That whole window is gone now. How do I do this now...?

Where can I find: Insert as Link and the IF...Then...Else Command

Sun, 13 May 2012 04:34:13 Z

I thought when I bought Office for Mac 2011 I was buying the Mac version of Office 2010. But I cannot find functions and commands I know are useable on the latter. Am I just not finding them on my Mac?

For instance where can I find the Insert as Link? As far as I can see I can inset another document into a current document but I cannot link to the one being inserted so that any changes made to the first will show up in the inserted material in the second.

Where can I find the IF..Then...Else Command? I believe this is available on Office 2010 on the Mailings ribbon, but cannot find any equivalent command on my Mac version which does not have either the Mailings ribbon or Mail Merge Wizard.

I hope someone can help.

No purchase history / product key?

Sun, 13 May 2012 03:25:48 Z

I just spent $279 purchasing Office for Mac 2011 from the Microsoft store, I have downloaded the programs and the money has come out of my account.

When I check my 'purchase history' in the Microsoft store to find the product key, however, there is nothing there! (and I am logged in to the account that I made the purchase with..)

Where can i get the product key from?

Thank you

Creating a spiral in PowerPoint

Sun, 13 May 2012 03:13:04 Z

I want o create a spiral diagram in a PowerpOint slide. How might I do this?

Outlook 2011 iCloud sync work around?

Sat, 12 May 2012 22:59:50 Z

I was told by an Apple person that while Outlook for Mac does not currently sync with iCloud (this is pathetic but well documented) you can use Apple Sync Services to sync Outlook with native Mac apps (Mail, Address Book, iCal) and this will sync with iCloud. Is he right? Is this a legit solution? (1) will it work (2) will it not duplicate data or break other stuff?

Missing Drawing Tool

Sat, 12 May 2012 21:13:50 Z

OSX 10.6.8 Word 2011 14.2.2 Print Layout view

Word used to have a real drawing tool. It could be used for drawing AND it could be used to annotate imported images. For technical docs it is critical to be able to draw on an image.

Now the drawing tool is gone. Why?

Yes, there is now a Shapes tool, that can be used for crude diagrams. But, these shapes can NOT be overlaid over an image. There seems to be no concept of layering with the graphic at level zero.

Is there anyway to get Word to draw OVER an image?

Arial Narrow font problem

Sat, 12 May 2012 20:26:20 Z

After installing the recent service pak for Office 2011, the Arial Narrow regular font does not display correctly for Czech language (Central European character set). Bold and italic are fine. What can I do to fix this problem? It is urgent for my resume and I don't want to have to reformat the entire document in another font. Thanks.

I downloaded the 30 day Outlook for Mac okay but when I open program can't actually get to a page to do anything

Sat, 12 May 2012 19:08:49 Z

I got confirmation that uploaded fine, but when I go into Excel to do anything I just have the welcome to Excel. All the options under "file" etc are greyed out

duplicate entries

Sat, 12 May 2012 18:22:04 Z

I would like to prevent duplicate entries in a column of values. Is there a way to do this

Can not open files with Office for Mac 2011

Sat, 12 May 2012 16:07:50 Z

Shortly I am using a MacBook Pro and installed Microsoft Office for Mac 2011. When I try to open an file from my NAS (Synology) I get an error. The file is not opening.

Erik Akkerman

I need Move all email account from out look mac (.olm ) to outlook windows 2010 (.pst) .

Sat, 12 May 2012 13:20:26 Z

Outlook mac to Outlook win.

Dear Office team

Please I need Move all email account from out look mac (.olm ) to outlook windows 2010 (.pst) .

Please i need your Support ASAP .

Note :

all our email POP3 .

Font goes all weird and these boxes come up instead of actual letters

Sat, 12 May 2012 11:30:59 Z

Letters all stuck together!!

So, people have been messing around with my computer and I come to use Word the next day and I can't type anything!
Like, of course I can type, but the font goes all weird and these boxes come up instead of actual letters and sometimes they get all stuck together...
Like this.
and this.
Now, I don't know if it's cause I'm typing in a different language and I need to change some settings, or these people have done something and have messed up Word.

Please help T^T I need this for work!! >_<

PS. sorry I forgot to put up the pictures
http://img440.imageshack.us/img440/1377/screenshot20120512at626.png
http://img84.imageshack.us/img84/1377/screenshot20120512at626.png

How do I turn off write protection, word - mac

Sat, 12 May 2012 08:56:27 Z

I have write protected a Mac Word document that I now want to delete, but cannot because I have write protection on. How do I turn off write protection in Word for Mac?

Excel - Formula over multiple different cells and sheets

Sat, 12 May 2012 00:44:01 Z

Hello All,

I have been searching and still could not find a solution.

I have 3 sheets: the first is a master with names, telephone numbers, ID's, and date of appointments (there are three appointment spots), the second contains subsets of some on sheet one, and the third has subsets different from sheet two, but the same as sheet one.

I would like to auto-populate (copy) the dates to different sheets within the workbook; however, they are at different locations. Is there any way to do this?

I would like to do this for all participants, but if I just copy and paste the formula wouldn't that just copy the data from the original formula I created? Thanks!

Is there any way to duplicate a footer from one tab to another?

Fri, 11 May 2012 23:28:52 Z

I am on a Mac using Excel 2011. I have a spreadsheet that was set up a while ago that has 7 tabs, all of them with information in them already. Is there any way to duplicate the footer from one tab to the next without having to retype everything for each?

send to address on #10 envelope not properly centered

Fri, 11 May 2012 22:50:53 Z

in print preview, the send address is in the right location but when printing, the send address on the actual envelope is not centered

it is too close to the top of the envelope.

all of the settings are correct for #10 envelope

- this happened after I installed the latest update

MS Word in my Office 2004 for Mac important feature

Fri, 11 May 2012 20:22:21 Z

Does this version of Word not contain the OVERWRITE feature for making corrections? If it does, how do I activate it? Many thanks.

Can you add a signature line to Word documents?

Fri, 11 May 2012 19:56:26 Z

I would like to add my signature to a document template in Word.

Office Mac 2008 includes upgrade to 2011

Fri, 11 May 2012 19:34:59 Z

Where do I get the download to upgrade from 2008 to 2011 without purchasing the installer. When I purchased 2008 it came with a sticker on the box stating "So complete, it comes with an upgrade to Office 2011"

Migrated Office 2004 Home/Student to a new Mac running Lion, need to get Office 2011 but how to transfer data since Lion won't recognize Office 2004

Fri, 11 May 2012 16:13:09 Z

The old computer is basically dead. Backed-up material was transferred to new computer running Lion, but Office 2004 won't open. How do I upgrade to Office 2011 and get it to recognize the data from Office 2004, when Office 2004 isn't recognized by Lion?