Tag Archives: Excel 16

fixed : XLOOKUP function not available in latest version of MS Excel

Posted on by
Reply

Question :
I am running the latest version of MS Excel, but even though it should include the XLOOKUP function, it is not appearing when I want to use it in a formula.

What can I do to fix this ?


Answer :
The problem is that even though you have the latest version of MS Excel installed, the active license you have is one for MS Excel 2019 or earlier…
So, make sure you have a license for a newer version of MS Office for Mac, then do this :
– in Excel, click on “Excel” in the top menu bar
– from the pulldown menu, select “About Microsoft Excel”
– in the “About Excel” window that opens, at “License:” you will see “Office … 2019” (or something alike)
– now, go to the Microsoft website and download the License Removal Tool for Mac
– when downloaded, run the .pkg file and follow the online instructions
– when done, move the downloaded .pkg file to the trash
– then, open any MS Office app (e.g. Excel, Word, PowerPoint or Outlook)
– when prompted, typ your MS Office for Mac license code (for Office 365 or 2021 or newer)
– when done, restart your Mac to activate the license code
– then open Excel after startup and check : XLOOKUP will now be available under “Formulas” > “Lookup & Reference”

That’s it !
enjoy πŸ˜‰

Note :
Microsoft’s website has further details that you can find here : “How to remove Office license files on a Mac”

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