Microsoft Excel | EasyTweaks.com

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

3 COMMENTS

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 […]

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 […]

How to make Office 2016 your default Microsoft Office application?

1 COMMENTS

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 […]

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 […]

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. […]

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 […]

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 […]

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. […]

How to embed a Word document in an Excel workbook?

Couple of days ago, a reader asked us the following question: I believe i have seen an Excel worksheet that has a Word document embedded in it. Could you explain how exactly that is done? Thanks for the question. It is indeed sometimes very neat to insert word documents into other Microsoft Office apps, mainly […]

How to remove password protection from an Excel 2016 workbook?

2 COMMENTS

The other day, one of my friends told me that she doesn’t remember the password that protects a spreadsheet she authored, and whether i can help. In Office 2016, we are able to set a password protection for our Excel files. In this post, we’ll learn how to reset a spreadsheet protection password. The explanation is […]

Category Archives for Microsoft Excel