Tag Info

New answers tagged

1

You mention in the comments that you are open to other solutions outside of Excel. That being the case, I found Apple Numbers to do well with using a PDF form as a background image. This requires no outside software to modify the original PDF. Embedding the PDF To begin with, select the PDF you wish to use. If it is a multi-page document, I find it ...


0

A bit more Googling turned up an answer: https://support.office.com/en-my/article/My-top-margin-is-missing-993773e9-4be6-44ae-b9ab-7e0a5d2b8298 "point to the top or bottom of a page until the pointer becomes a double-pointed arrow, and then double click."


0

ImageMagick Consider using ImageMagick's composite tool to combine the Excel PDF and your background image: Use the composite program to overlap one image over another. See Command Line Processing for advice on how to structure your composite command or see below for example usages of the command. Example Usage We list a few examples of the ...


0

Seems like a one way sync. Its not the first time iv heard of this issue popping up. You can try to solutions by the users above. But what I did was sync with a 3rd party Plug-in. Iv been using EVO Collaborator for several different syncing needs so I was using this for iPhone standard as well. And it has no problems whatsoever. So I suggest you try out ...


0

Some of it depends on what type of account @outlook.com accounts are but I am quite sure that it would be IMAP. As such, if you delete your messages, it will delete them from your live email account to, which obviously could come with unintended consequences. To avoid that, I would recommend first confirming that messages are only set to download when you ...


1

Believe it or not, the TAB character on a Mac has the same ASCII code -- 9, so =char(9) should just work.


0

The same as on any Mac OS since the dawn of time... Cmd ⌘ W will close the window. It's well worth learning the basics - though this list is pretty heavy & you may never remember them all... Mac keyboard shortcuts


1

I addition to @cmason's correct answer, you may find it advantageous to review Apple Support's "Mac Basics - Tour the Mac Interface." More specifically regarding full screen apps, you will find further reading here: OS X Yosemite: Take apps full screen. Excerpt: Return to standard view: Move the pointer to the top-left corner of the screen, then ...


3

Word is in Full Screen mode. Simply hover your mouse at the top of the window, and the Menu bar will drop down. On the right hand side is a blue double-headed arrow. Click it, and the screen will return to a window. (you can save the document by simply using the menu when it drops down from your mouse hover, if you wish to remain in full screen mode...oh ...


1

Two options for the unsophisticated that worked for me: Under Word > Preferences > AutoCorrect > Replace as You Type unselect "'Straight question marks'" with 'smart quotation marks'". Unfortunately, this leaves you with straight quotation marks and apostrophes. Use Calibri as your font while writing, then convert everything to your font of choice when you ...


2

Numbers Disclaimer: Free on new Macs Apple Numbers also opens and saves to CSV. Just had to add to the list. Numbers: Save as CSV after editing: Note that you can choose text encoding as well when exporting if needed for other systems.


1

Open Refine When interacting with large and messy text csv and other structured text files, I now typically go to Google Refine (now called Open Refine). I've used it for TSV/CSV, JSON, and XML documents. In my experience it crashes rarely, and is pretty good for mangling data (you can apply transformations with scripting languages). Its approach is more ...


0

If it's not affecting locally created documents, could it have to do with Compatibility mode? Try re-saving the doc in the latest native .docx format and re-opening.


3

You were not able to get Excel to do this for you? The only thing I was not able to do was to get the Horizontal labels centered underneath the columns, but you could likely do it by hand if you hid the column labels then manually typed them into the axis label instead. This is how I got to the picture above. Highlight A1 to N3 and then select Stacked ...


0

~/Library is an usually invisible folder in your user folder. You may access the folder by entering "~/Library" after choosing Go -> Got to Folder… in the menubar while Finder is the front app. Alternatively you may open your user folder and change the view options by choosing View -> Show View Options… and enable "Show Library Folder". Now navigate to ...


0

Skype for Business has not yet made it in full to the Mac. Microsoft are instead still offering the older Lync software... Set up Skype for Business (Lync) for Mac 2011 for Office 365 If your organization is using Skype for Business (Lync) for Mac 2011, you can use it with your Office 365work or school account. To use Skype for Business (Lync) ...


0

I don't have an answer for this problem. But I am having problems with Word 2011 and keyboard shortcuts. I am trying to simply create a shortcut for the function "GotoHeader". I set it to F4. But when I depress F4 Word does nothing at all. Is there a trick to getting the program to recognize these shortcuts?


1

The problem is not with the track changes and comments but how Word tries to display them: in a Balloon... Luckily there is a simple solution: Word -> Preferences -> Track Changes -> "Use balloons to display changes" remove the tickmark from here. You can still see the changes inside text by checking the colors and use Review tab -> ...


0

Outlook Mail Settings Go to Preferences... ⌘+, in Outlook Select Reading under Email The Security settings allow you change "Automatically download pictures from the Internet:" In all messages In messages from my contacts Never The default is never, that is why the 'banner' appears. Change it to one of the other options based on your preferred usage. ...


2

From Microsoft's Known Issues with PowerPoint 2011: Some characters cannot be used in file and folder names in PowerPoint for Mac 2011 IMPORTANT This issue is fixed in Office for Mac 2011 Service Pack 1. Click Downloads to download Service Pack 1 or the latest update. Characters, including <"> and |, are allowed in file names in ...


0

I know this is a bit obvious but you could try Google Sheets. It's scriptable in server-side JavaScript so if it doesn't do charts like that (and I don't think it does) then you might be able to hack in a solution.


1

It is very possible that your company is running an Exchange Server that is not compatible with Outlook for Mac 2016. Check with your company's help desk to find out if this is indeed the issue and if so how you can reinstall Outlook 2011.


0

If your version is activated and all you are still experiencing that, I can suggest you to take a look at the credentials that you have for the account, the server info(under "Advanced...") and the ports. All could be found by selecting the Outlook, then from the menu you can choose Outlook > Preferences > Accounts > choose the desired account Also make ...


2

I think I've got an answer. Googling around I've found references to "grayed out" problems and mentions of the file's creator attribute. So a quick Google for "osx file creator mark" pointed me to SetFileand its sibling GetFileInfo. Running a quick GetFileInfo on the files I get: Mac:samples jjarava$ for i in 201507*.TXT; do getfileinfo "$i"; echo .; ...


0

Well as your screenshot shows, they are "almost", but not completely the same; the original file is ASCII text, with CRLF line terminators whereas the copies and fragments you created are ASCII text. Some background info: if you think of an ancient typewriter, to things happen, when the writer starts a new line: the paper is "forwarded" one line (="line ...


0

I found a solution; it's not "pretty", but it works. Unfortunately, it is a bit hard to describe, so I'll make an example file with explanations available, instead. In short, it uses a "helper cell" the locate and mark duplicates Excel's use a formula to determine which cells to format Conditional Formatting option to then color the original cells


3

Office 2016 for Mac has a stable release available for Office 365 subscribers. It'll be available as a standalone purchase at some unspecified date in September. Until then, it looks like Microsoft has taken their beta down. What you could do is wait as long as you can bear to live without Office and then sign up for a free trial of Office 365, and then ...


2

EDIT (Complete revision): Based on your data, the only way to accomplish this without redesigning the table is to create separate charts for each Segment shown. As each segment has 4 pieces of data, this is the only way to do this. (There may be someone out there who is a charting expert that could do much better, I'm sure) First, as you have done is to ...



Top 50 recent answers are included