Even though you change the default browser via Settings → Default Apps, Outlook (Microsoft 365) app may always open hyperlinks in Edge. This happens no matter how many different ways you tried to change the default browser.Read more
Office
How to Custom Install/Uninstall Individual Office 2016/2019/365 Apps
The traditional MSI (Microsoft Installer) based installation allowed you to install or uninstall individual office products (e.g., Word, Excel, or PowerPoint). But the Office click-to-run (CTR) installations don’t allow installation choices. Click-to-Run is the technology used to install Microsoft 365, and most versions of Office 2013 and newer.Read more
How to Batch Convert Excel Sheets into PDF Files
Microsoft Excel Spreadsheets are commonly used to store financial data and prepare invoices. Often, you may need to convert the .xls or .xlsx files to .pdf format especially if you’re sending out invoices to your clients.
Microsoft Excel has a built-in option using which you can save your workbook, active sheet, or selected cells to a PDF file. This can be accomplished using the Save as… dropdown box.
By clicking on the More options… link, you can configure the page range, and the item to export (entire workbook, active sheet, etc) to PDF.
Another option would be to use the Microsoft Print to PDF driver in Windows 10 to output the .xls or .xlsx file to a .pdf document. For this, you’d use the Print option (instead of Save as) to print the document to PDF.
Pre-Windows 10 systems don’t have the Microsoft Print to PDF driver. As an alternative. you can use the free CutePDF Writer or Foxit PDF Printer (part of Foxit PDF Reader software.)
Bulk conversion of Excel sheets to PDF
However, if you have hundreds of invoices (in .xls or .xlsx format) that you need to batch/bulk convert the files into PDF, the above options are not ideal and take a long time.
- There are plenty of online portals that can bulk convert Excel sheets to PDF documents quickly without charging any fee. However, if your Excel sheets are confidential and you don’t want any intermediary portal or service to access them, then you may use the Excel to PDF offline conversion methods discussed in this article.
Fortunately, Microsoft Word and Microsoft Excel lets you automate the above task using scripting. This article tells you how to batch convert multiple Excel sheets into PDF files quickly.Read more
How to Install Office Picture Manager in Windows 10
Microsoft Office Picture Manager is a graphics viewer and editor introduced in Microsoft Office 2003 and included up to Office 2010. Many people prefer the good old Microsoft Office Picture Manager, perhaps for it’s UI or UX, and want to install it on Windows 10.
However, Microsoft has discontinued the Picture Manager with the release of Office 2013. The equivalent functionality is now provided in the Windows 10’s Photos app, which has the image crop, resize, red-eye removal, video trimming, and other features. Alternatively, you can also enable the classic Windows Photo Viewer using the registry, or install the Windows Live Photo Gallery (which is now unsupported by Microsoft).
If you desperately need the Office Picture Viewer, the good news is that you can still install it on Windows 10. The SharePoint Designer 2010 installer includes the Office Picture Manager as an optional component that can be installed as a standalone application.
This article tells you how to install Office Picture Manager on Windows 10 and earlier, regardless of the version of Office — e.g., Office 2013, Office 2016, Office 365 — installed on the computer. Office Picture Manager is super-fast (like the Windows Photo Viewer) especially if you’re going to use it as an image previewer.Read more
How to Change the Office 365/2016 Default Save Folder
Office programs save your files to OneDrive by default since the February 2019 Office 365 update. Microsoft suggests that the users store files in OneDrive to protect against device loss or damage and to provide anywhere access to files.
Quoting Microsoft:
Today we are announcing a new capability that makes it easier for you to create and save your Word, Excel, or PowerPoint document directly to the cloud. When you go to save an Office 365 document using Ctrl+S (Windows), Cmd+S (macOS), or the Save button, the new dialog box will default to OneDrive or SharePoint Online. And if you forget to save a new document before exiting, you will also see this updated save experience.
In case you want to change the default save location in Word, Excel, PowerPoint, etc., there are multiple ways to do it. Instructions below apply to Office 2016 standard installation as well as Office 365.Read more
Stop Excel from Converting Text to Number or Date format when Opening a CSV file
A comma-separated values (CSV) file is a delimited text file that uses a comma to separate values. Each line in a .csv file is a data record consisting of one or more fields, with each field separated by a comma. A .csv file can be imported to and exported from programs that store data in tables, such as Microsoft Office Excel, LibreOffice, or OpenOffice. When you open a .csv file in a spreadsheet, the spreadsheet uses the comma as the field separator (delimiter).Read more