Microsoft Excel | EasyTweaks.com

How to open an Excel 97/2003 .xls file in Excel 2016, 2019 and 365?

3 COMMENTS

Last updated: August 2018 Applicable to: Office 365, 2019, 2016, 2013, 2007. Windows 7 and 10 operating systems. 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, […]

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 or 2019 or 365 your default Microsoft Office application?

2 COMMENTS

Last updated: September 2018 Applicable to the following Office versions: 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 […]

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 easily create checklists in Excel sheets and Word documents?

1 COMMENTS

Applicable to: Word and Excel 2019, 2016, 2013, 365. Microsoft and Apple Office versions. Latest update: September 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 […]

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 watermarks in Office 2016 / 2019 Excel spreadsheets and PowerPoint presentations?

Last updated: September 2018 Applicability: Office 2019, 2016,2013,2010; Windows and MAC OSX Few weeks ago we received a note from a reader: Every quarter, our team creates handouts for management meetings. The process of developing the handouts is pretty elaborated and requires to collaborate in development a series of workbooks, presentations and documents. In order […]

Category Archives for Microsoft Excel