Category Archives for Microsoft Excel

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

Last updated: April 2018 Applicable to: Office 2016, 2013, 2007. Windows and MAC OS X. Here’s a question from our reader, Skyler: “I work as an analyst and have a significant number of old xls files were created in the previous version of Excel. Now that i have upgraded to version 2016, Excel won’t open […]

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?

Last updated: April 2018 Applicable to: Office 2019,2016,2013, 365; Windows 7, Windows 10 and partly to MAC OSX Here’s a question we received from one of our readers: “I’ve installed a new version of Office 365 in my system, but after the installation all my Office documents are showing up as unknown file types. Can […]

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?

Applicable to: Excel 2019, 2016, 2013, 365. Microsoft and Apple Office versions. Latest update: May 2018 Chances are that from time to time you might want create forms using in Office in order to easily capture user feedback or document a standard operating process. In today’s tutorial, we’ll teach you pretty much everything you need […]

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 combine two or more cells or columns in Excel 2016?

Here’s a question from Nanda: “I need to copy list of names available in spreadsheet to a text document. But when I copy and paste it, all goes wrong. Can you help to have first and last name in the same column?” Sure. Read on for the details. To merge columns using concatenation function: Open […]

Continue reading

How to remove duplicated entries from an Excel 2016 list?

If you use Excel to analyze large data sets, you might have encountered the need to find and remove duplicate rows from your data. In today’s post, we’ll provide a simple tutorial to help you find those duplicates and scrub them from your data. Although Excel 2016 is used to outline the steps below, they […]

Continue reading

How to add a drop-down menu for data validation in Excel 2016?

Capturing user input using drop down menus in your Excel spreadsheet can be leveraged as a very powerful data validation technique. In today’s tutorial we’ll take you through the process of creating the drop down menu, validating user input and showing an error message if a invalid data is entered. Read further for the procedure. […]

Continue reading

How to embed a Word document into an Excel workbook?

Last update: May 2018 Applies to: Office 2019, 2016, 2013; Office 365; Windows 10, 7; Mac OSX Here is a question we got the other day from one of our readers: I believe i have seen a Microsoft Excel 2016 worksheet that had a Word doc embedded in it. Could you explain how exactly that […]

Continue reading
1 2 3