Category Archives for Excel

How to find and mass replace text and numbers in Word andExcel 2016?

If you have used Microsoft Word or Excel at school or work, you might have realized that it’s a bit challenging to mass find and replace certain text or numbers automatically. This is exactly, what we’ll show you in today’s quick tip. Word: Open Microsoft Word document. Enter the data in word document . To […]

Continue reading

How to automatically highlight alternate rows or columns in Excel 2016?

A reader was asking about whether we know of a method or formula to highlight every other row and column in Excel. Today, we’ll learn how to apply different color schemes to alternate rows or columns in Excel. There are several ways to alternate row colors, but today, we will focus on two main ways […]

Continue reading

How to make Office 2016 your default Microsoft Office application?

Here’s a question from Diggle: “I’ve installed a new version of Office 365 in my system, but after the installation all my document opening formats are shown as an unknown program. Can you help me to set it up as the default for the Microsoft Office files?” Yes thank you for the question. In this […]

Continue reading

Automatically format cells, dates, columns and rows in Excel 2016?

Here’s a question from Krithi: “I know that Excel has some cool capabilities for setting automatic formats (such as colors/fonts sizes / height / styles) of individual columns, rows, cells specially when it relates to dates and times. Can you provide more information about auto-formatting in Excel spreadsheets” Great question. In this post we will […]

Continue reading

How to easily create checklists in Excel sheets and Word documents?

Sometimes you would like to create forms using in Office in order to easily capture user feedback. In today’s tutorial, we’ll teach you pretty much everything you need to know in order to create and format check box lists either as part of your Excel spreadsheets or Word documents. Once done you might want to […]

Continue reading

How to open an Excel 97/2003 .xls file in Excel 2016?

Here’s a question from Skyler: “My xls files were created in the previous version of Excel. But now when I open the document in Excel 2016 it say its corrupted. Is there anyway to retrieve it?” Thanks for your question and Yes there is a way to retrieve the document. We will discuss about it […]

Continue reading

How to open, view and compare two Excel worksheets side by side?

A pretty helpful function when working with spreadsheets is the ability to compare them side by side.In today’s tutorial  we’ll show you how to view and compare two or more worksheets in the same or different workbooks side by side. View two worksheets in same workbook: Open your excel spreadsheet which consists of two workbooks. […]

Continue reading

How to add picture captions in Office 2016 applications?

Here’s a question from a reader: I thought to include title and information to pictures i am adding to a document. Could you propose simple way to define photo captions in Word? Thanks for your question. Follow this tutorial for the detailed overview. Word: Open Microsoft Word. To add image click Insert tab and then […]

Continue reading

How to customize your bullet points color in Office 2016?

Here’s a question from Diane: I am creating a bulleted list in Word. By default, all bullets are colored black. is there are way to switch the bullets to a different color, say red?   Sure Diane. Please read on this tutorial which is applicable for all Office 2016 applications. Set color bullet point: In […]

Continue reading

How to add an Excel table into a Word 2016 document?

Here’s a question from David: I have a nice spreadsheet that i would like to insert to a Word document. Any ideas? Thanks David. Here you go: Embed a static snapshot of your spreadsheet in Word: Note: This option will allow you to embed a screenshot of your spreadsheet, which you won’t be able to […]

Continue reading