OFFICE ARTICLES / MICROSOFT OFFICE, GOOGLE DOCS, AND MORE

Have you tried to type an ampersand (&) in a header or footer in Excel and seen it disappear on your printed worksheet? There’s a special trick to typing ampersands in headers and footers in Excel so you don’t lose them.

about 2 months ago - by  |  1 Reply

When designing your own forms in Microsoft Word, you may occasionally encounter problems in knowing how to create the particular sections or features that you need. With that in mind, today’s SuperUser Q&A post has some helpful solutions for a reader’s Microsoft Word woes.

about 2 months ago - by  |  1 Reply

By default, programs’ title bars in Windows 10 are white. You can change the color of the active program window, but what about the title bars on inactive windows? No worries. There’s an easy registry tweak to solve that.

about 2 months ago - by  |  1 Reply

In typesetting terms, “widows” and “orphans” are lines at the end or beginning of a paragraph that are separated from the rest of the paragraph by a page break. If you think widows and orphans in your Word document are distracting, you can enable a setting that prevents them.

about 2 months ago - by  |  1 Reply

There are two ways to protect a PDF file: an owner password and a user password. We’ll explain the purpose of each and show you how to apply them to your PDF files.

about 3 months ago - by  |  1 Reply

When working on an Excel worksheet, you may find yourself setting up different display settings at different times, such as zoom level or window position and size. The Custom Views feature allows you to set up and save different views to quickly switch among them.

about 3 months ago - by  |  1 Reply

By default, each Notepad document has the name of the document in the header and the page number in the footer when you print a text file. However, you can customize the header and footer with special commands or custom text, or leave one or both blank.

about 3 months ago - by  |  6 Replies

If you use the LibreOffice suite of programs, you’ll be happy to learn about Open365. Just as LibreOffice is the free, open source alternative to Microsoft Office, Open365 is the free counterpart to the cloud-based Office 365.

about 3 months ago - by  |  6 Replies

When you type in Word, paragraphs flow smoothly from one page to the next, and page breaks are automatically inserted when needed. However, what if you want to keep a certain paragraph together and not split the paragraphs between two pages? There’s a simple fix for this.

about 3 months ago - by  |  2 Replies

When you open a document created in an older version of Microsoft Word, Excel, or PowerPoint in a modern version of Office, you may see “Compatibility Mode” appear after the name of the document in the titlebar. This changes the way the document appears and prevents you from using some modern features.

about 3 months ago - by  |  2 Replies

You’ve just closed an Office document and accidentally clicked Don’t Save. Or maybe Word crashed or your laptop lost power before you remembered to save what you were working on. We’ve all felt that pain, but all is not necessarily lost. By default, Office applications automatically save temporary backup copies of your documents as you work and there’s a good chance you can recover them.

about 3 months ago - by  |  1 Reply

Even in these times of fast internet connections, huge hard drives, and loads of free cloud storage, file size sometimes matters. You might have a limit to the size of files you can send or receive via email, or you might be running low on thumb drive space. Whatever the reason, if you have Office documents that include images, you might be able to significantly reduce the size of those files.

about 3 months ago - by  |  3 Replies

Microsoft Office files are still very common, but if you’re more of a Google Docs, Sheets, and Slides user, you can still edit Word, Excel, and PowerPoint files in Google Drive–if you know how.

about 3 months ago - by  |  2 Replies

If you delete a lot of emails when sifting through your Outlook inbox, you might have turned on the option to automatically empty the deleted items folder when exiting Outlook. That’s handy, but you most likely have to confirm the deletion of the emails every time.

about 3 months ago - by  |  1 Reply

When you click Send on an email, it is typically sent immediately. But what if you want to send it at a later time? Outlook allows you delay the sending of a single message or all email messages.

about 3 months ago - by  |  1 Reply

The Office Upload Center is part of Microsoft Office. Install Office on your computer, and this tool will appear in your system tray. Sure, you can hide this icon, but should you? What exactly does it do, anyway?

about 3 months ago - by  |  1 Reply

Among the new features in Microsoft Office 2016 are some improvements to the user interface. For example, they added a background image to the title bar in each Office program, and an improved dark theme. Customizing the background and theme is easy, and we’ll show you how to do it.

about 4 months ago - by  |  3 Replies

To do basic arithmetic in Word, you normally have to open the Windows calculator to get your answers, then manually insert them into Word. However, there is a third-party add-in for Word that provides a popup calculator that will calculate numbers in your document, and automatically insert the answer.

about 4 months ago - by  |  6 Replies

If you have large workbooks with a lot of formulas on the worksheets, recalculating the workbooks can take a long time. By default, Excel automatically recalculates all open workbooks as you change values in the worksheets. However, you can choose to recalculate only the current worksheet manually.

about 4 months ago - by  |  1 Reply

Microsoft Office lets you encrypt your Office documents and PDF files, allowing no one to even view the file unless they have the password. Modern versions of Office use secure encryption that you can rely on–assuming you set a strong password.

about 4 months ago - by  |  3 Replies

When you delete emails, tasks, calendar items, or notes in Outlook, they are moved to the Deleted Items folder. This folder is not emptied until you do it manually–at least by default. If you want, you can have Outlook empty this folder automatically when you exit the program.

about 4 months ago - by  |  2 Replies

Say you’ve created an Excel workbook you need to distribute, but you can’t reveal the formulas you used in that workbook. We’ll show you an easy trick that allows you to copy a worksheet to another workbook and quickly remove the formulas, so only the results show.

about 4 months ago - by  |  1 Reply

Naming a range of cells in Excel provide an easy way to reference those cells in a formula. If you have a workbook with a lot of data on the worksheets, naming ranges of cells can make your formulas easier to read and less confusing.

about 4 months ago - by  |  1 Reply

Your iPhone contacts will automatically come with you to a new phone–assuming that new phone is an iPhone, you’re backing up the contacts to iCloud, and you’re using the same iCloud account on both phones. But things get a bit more complicated if you want to do anything else.

about 4 months ago - by  |  3 Replies

By default, when you create a table in Word, it is aligned with the left margin. You may want to make your tables stand out a bit by indenting them, but this cannot be done using the same formatting tools you would use to indent a paragraph.

about 4 months ago - by  |  1 Reply