Category Archives: office software

fixed : iOS Mail.app “Fetch New Data” settings page completely greyed out

Posted on by
Reply

Question :

I have troubles with my eMail on my iPhone, so I started to look for solutions in the iOS Settings.app ; I don’t know if this is relevant for the solution to my mail-problem, but I found that when I try to adjust the settings for Fetch New Data (in the Settings.app > Mail > Accounts > scroll down to bottom) is turned OFF, and when I click on it the entire Fetch New Data settings page is greyed out, so I can’t switch it back ON and have my mail checked automatically…

What is wrong ? How can I fix this ?

Answer :

Relax, there’s nothing wrong… it’s just strange that iOS isn’t telling you why the entire page is greyed out and how you can fix this…
The thing is : your iPhone is in Low Power Mode (a.k.a. Battery Saving Mode)… (if you look closely, you will see that the battery indicator top right is yellow in stead of white or green)
To fix this, do this :

  • swipe down from the battery indicator top right
  • in the window that opens, scroll down to the white tile with the battery (in yellow) and click on it
  • now the tile wil turn dark and the battery will turn white
  • if there is no battery-tile, then go to Settings.app > Battery and switch the slider at Low Power Mode to ON
  • to check, go to Settings.app > Mail > Accounts > Fetch New Data and you will see that you can now set everything as you like

    That’s it !
    enjoy πŸ˜‰
Advertisement

fixed : insert a picture into a PDF using Preview.app

Posted on by
Reply

I need to fill out a PDF-form and include a picture also. I tried to do this using Preview.app but drag&drop didn’t work and copy&paste didn’t work either…

Is there any way to do this ?

Answer :

Yes, you can add a picture into a PDF using Preview.app. To do so, do this :

  • open the PDF in Preview.app
  • then, open the picture in a separate window in Preview.app
  • then, in the window with the picture, do this :
  • – select all ; by using the [CMD]+[A] key combo
  • – copy ; by using the [CMD]+[C] key combo
  • – paste ; by using the [CMD]+[V] key combo (when still in the window with the picture in it)
  • – resize the picture to about half-size ; by dragging the edges
  • – copy ; by using the [CMD]+[C] key combo
  • then, in the window with the PDF in it, do this :
  • – paste ; by using the [CMD]+[V] key combo
  • – resize the picture to the desired size ; by dragging the edges
  • – move to the desired location on the page ; by dragging the picture
  • then, save the PDF (under a different name if you like)

That’s it !

enjoy πŸ˜‰

fixed : calculate the number of days between 2 dates

Posted on by
Reply

Question :

I want to integrate a formula in my spreadsheet (in Excel or Numbers) that calculates the number of days between 2 dates that I have in other cells on the spreadsheet.

How do I do that ?

Answer :

there are 2 formulas available to do this, choose the one that works best for you in Excel or Numbers :

formula =DUR2DAYS(enddate–startdate)+1

or

formula =DATEDIF(startdate, enddate, β€œD”)+1

NOTE : the “+1” in both these formulas is only needed if you want the number of days including both startdate and enddate !

That’s it !

enjoy πŸ˜‰

fixed : copy WhatsApp profile picture to macOS Contacts address book

Posted on by
Reply

Question :
I am using WhatsApp to communicate with some people that I have only seen a few times in real life. But as we are communicating in a WhatsApp Group it is really handy to see their profile pictures to remember who is who. But now I need to eMail them and it would be great to distinguish them by their profile pictures also… Is there any way to copy their WhatsApp profile pictures over to my macOS Contacts address book ? I’ve tried dark&drop, but that doesn’t work…

Answer :

Yes, but it’s slightly more time-consuming than drag&drop. Here’s how to :

  • make sure you have the official WhatsApp Desktop-app installed on your Mac
  • make sure the WhatsApp Desktop-app is open and you are logged in
    • note : you will need your mobile phone to log in (for the first time)
  • in the WhatsApp Desktop-app do this :
    • open an old conversation with the person who’s profile picture you need
      • you can use the Search-option to find this person if you don’t see them in your recent chats immediately
    • in the person’s profile picture that is visible in the middel of the top menu bar
    • when the Contact Info window opens, right-click on the (large) profile picture that is displayed
    • now, click on the “Copy Image” text that appears
    • then, exit WhatsApp Desktop-app and open Preview.app
    • make sure that “Preview” is listed in the macOS top menu bar, next to the Apple logo
    • goto “File” > “New From Clipboard” and click on it
      • if “New From Clipboard” is greyed out, there is nothing on your clipboard, so you should go back into WhatsApp Desktop-app and do the “Copy Image” procedure again
    • now the profile picture will be displayed as a Preview document
    • goto “File” > “Save” and click on it
      • when asked, you can just leave “name: Untitled” and “location: Desktop” and click OK
      • now a new file (icon) named “Untitled” will appear on your Desktop
    • then, exit Preview.app and open Contacts.app
    • in Contacts.app find the person you want to add the profile picture to
    • click on the person’s name to open their personal info
    • then, drag&drop the “Untitled” file from your Desktop to their profile picture area
    • frist, in white, the word “edit” will appear, when the Plus-sign appears, drop the file
      • you can do this even if you don’t click on the “Edit” button bottom right
    • you will get the option to size the profile picture, so you can zoom in if you like
    • then click OK and you’re done
    • That’s it !

enjoy πŸ˜‰

fixed : Two-sided printing in MS Word for Mac

Posted on by
Reply

Question :

I usually work in Apple’s Pages.app to do my text editing, but now someone sent me a school document that was made in MS Word. It opens just fine in Word for Mac, but when I want to print, I can’t find the “Two-sided printing” option…

How can I do Two-sided printing in Word for Mac ?

Answer :

As always, the solution is simple, you just have to know where to look and what to look for…

…anyway, here’s how-to do this in Word 16 (2021) :

Note : in older versions it is similar, but sometimes slightly different (just one of those things to know is that “Two-sided printing” is called “Duplex printing” on Windows and therefore also in older versions of MS Office for Mac…)

  • open the document in Word for Mac
  • press the [CMD] + [P] key combo on your keyboard to open the Print window ( or goto Word > File > Print )
  • click on “Copies & Pages” and choose “Layout” from the pulldown menu
  • in the Layout settings view, see that “Two-Sided” is listed, with the option to choose “Long Edge Binding” (for portrait mode documents) and “Short Edge Binding” (for landscape mode documents)
  • > note that if “Two-Sided” is not listed here, your printer doesn’t have the option to print two-sided automatically, and you will have to do the two-sided printing manually [see below]

That’s it !

If your printer can’t do two-sided printing automatically, you can do this to get two-sided printing manually :

  • open the document in Word for Mac
  • press the [CMD] + [P] key combo on your keyboard to open the Print window ( or goto Word > File > Print )
  • click on “Copies & Pages” and choose “Microsoft Word” from the pulldown menu
  • in the Microsoft Word settings view, set “Print:” to “Even pages only”
  • then go back to “Copies & Pages” and at “Pages:” set both “From:” and “To:” to 1 and click the Print button
  • when your print is ready, draw a huge arrow on the back of the printed page pointing upward like the text on the front side
  • then put the page in the printer’s feeder drawer and make sure the arrow you have drawn on it is on the upside and pointing into the printer drawer and close the printer drawer
  • then click on “Copies & Pages” and choose “Microsoft Word” from the pulldown menu
  • in the Microsoft Word settings view, set “Print:” to “Even pages only”
  • then go back to “Copies & Pages” and at “Pages:” set both “From:” and “To:” to 1 and click the Print button
  • now look at the printed page that comes out and figure out how to put the pages in after having them printed on one side (make sure you have this correct before proceeding ; if you can’t get your head around this, just redo the above steps and print a new testpage)
  • now, get ready to print the entire document :
  • press the [CMD] + [P] key combo on your keyboard to open the Print window ( or goto Word > File > Print )
  • click on “Copies & Pages” and choose “Microsoft Word” from the pulldown menu
  • in the Microsoft Word settings view, set “Print:” to “Even pages only”
  • then go back to “Copies & Pages” and at “Pages:” select “All”
  • then wait for all even pages to print
  • when done, flip over the bulk of printed paper the way you figured out to be right (using your test page as a reference) and put it back in the printing drawer
  • make sure that not only the orientation is correct, but that the first page is on top and the last page is at the bottom also
  • click on “Copies & Pages” and choose “Microsoft Word” from the pulldown menu
  • in the Microsoft Word settings view, set “Print:” to “Odd pages only”
  • then go back to “Copies & Pages” and at “Pages:” select “All”
  • then wait for all odd pages to print
  • …now check if your document is printed correctly on both sides !
  • if not… you have gotten your page flipping incorrect… too bad… you’ll have to redo from start…

That’s it !

enjoy πŸ˜‰

fixed : rotate page orientation in MS Excel ( portrait / landscape )

Posted on by
Reply

Question :

I have to print (part of) an Excel sheet that has few lines and al lot of columns (so it’s not that height, but rather broad), so I want to print on a landscape-ed paper.

In regular macOS apps (like Preview, Keynote, etc.) I would do this by pressing [CMD]+[P] on my keyboard, so the printing window opens and I can switch the “Preview/Keynote/etc.”-dial to “Page Attributes”, so I can set the Paper Size (e.g. A4 or US Letter) and the Orientation (Portrait or Landscape).

If I do this in MS Excel, I get a similar printing window, but if I click the “Excel”-dial, the list of options doesn’t have “Page Attributes” listed… and I non of the other available options seems to have a setting to change the page orientation either…

Note : Yes, I know that Apple’s counterpart Numbers.app has a different type of printing window with the Page Orientation option listed near the top-right, but that’s to different from what I’m seeing in Excel that I see no way to lear in Numbers.app what I want to do in Excel…

What am I doing wrong ?

Answer :

Yes, Excel is different from the regular macOS-apps regarding setting the page orientation (and it’s even more different from it’s competitor Numbers.app), but the option is hidden in plain sight !

To change the page orientation in Excel, press the [ALT]+[P] key-combo, and then the print window opens, just leave the Excel-dial as-is and look a little below it… there you will see the options “Print”, “Margins” and “Orientation”… That’s it !

Note : there is another option to set the page orientation in Excel : goto the top menu-bar, click on “File” (top-left) and from the pull-down menu select “Page Setup” (just above “Print”) and when the “Page Setup” window opens, make sure the “Page”-tab is selected and at “Orientation” you will see radio buttons for “Portraid” and “Landscape”… That’s it !

enjoy πŸ˜‰