Category Archives: office software

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 πŸ˜‰

fixed : put printing & scanning shortcuts in the Dock

Posted on by
1

Question :

Whenever I need to scan (or sometimes even to print) anything, I need to go into System Preferences, then Printers & Scanners, then click Open Scanner…

Isn’t there a one-click solution to do this ?

Answer :

Yes there is.

Back in the days of MacOSX there used to be an option for this called “Desktop Printer” : that would put a shortcut-link of your printer on the Desktop. And you could do the same for your scanner.

——————– UPDATE ———————–

With the introduction of macOS 14 Sonoma the solution outlined in this post is no longer possible – if you are running macOS 14 Sonoma, go here for the current solutions :

fixed : create a Desktop Printer (one-click printer access) in macOS 14 Sonoma

fixed : create a Desktop Scanner (one-click scanner access) in macOS 14 Sonoma

——– if you are using macOS 13 Ventura or previous you can also use the solution below —–

Nowadays, for some reason, this option is gone, and no easy alternative is given by macOS… so you will have to create some thing yourself… the easiest way is to put both your Printer’s and your Scanner’s icon in the Dock. To do so, do this :

  • go to Apple menu (Apple-icon top-left in the top menu bar)
  • when the pulldown menu appears, select “System Preferences”
  • in the window that opens, click “Printers & Scanners”
    • if there is no such option, click on the raster-icon (top-center) first and it will appear
  • in the window that opens, click on your scanner (in the list on the left)
    • if your scanner is not yet in the list, add it first by clicking the Plus-icon at the bottom and following the on-screen instructions
  • now your scanner opens in the main part of the screen (on the right)
  • click the “Open scanner” button
  • now, the Scanner-window will open, and the scanner’s icon will appear in the Dock
  • CTRL-click (right mouse button) on the Scanner’s icon in the Dock
  • from the popup-menu, select “Options”, then “Keep in Dock”
  • now, the scanner’s icon will be moved to the left and it will stay in the Dock even after you close the scanner software
  • so, next time you want to scan anything, just click on the scanner’s icon in the Dock to open the scanner software

    That’s it !

Note : creating a direct link icon in the Dock for your printer can be done in the same way

enjoy πŸ˜‰