Last Update: October 2019. Applicable to Excel 2019 and below. Windows and macOS A reader was asking about whether we know of a formula to highlight or shade 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 … Read more
Last updated: November 2021 Applicable to the following Office versions: 2019, 2016, 2013, 365; on Windows 7, 8 and Windows 10. Here’s a question we received from one of our readers: “I’ve just installed a new version of Office 365 in my system but it’s clearly not defined as the default program for viewing and … Read more
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 … Read more
Applicable to: Word and Excel 2019, 2016, 2013, 365. Microsoft and Apple Office versions. Latest update: October 2019 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 … Read more
Here’s a question from Nanda: “I need to copy list of names available in spreadsheet into a simple text document to then import it into a legacy information system we use at work. But when I copy the Excel columns to the clipboard and then paste in Notepad, it all goes wrong. Can you help … Read more
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 … Read more
Chances are that you might want to validate and standardize user input in Excel using drop down menus. In today’s tutorial we’ll take you through the process of creating the drop down, validating user input as well as showing an error message if a invalid data is entered. Read further for the entire step by … Read more
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 to clearly determine the status of those documents we wanted to use … Read more
Applies to: Excel 2019, 2016, 2013; Office 365; Windows 10, 7 and macOS. Dorothy wanted to learn how to insert objects into her Excel spreadsheets: I believe i have seen a Microsoft Excel worksheet that had a Word document embedded in it. Can you explain how can i insert Word files into Excel and in … Read more
Updated: October 2019 Applicable: Microsoft Excel 2019/365/2016; Windows and macOS operating systems. Here’s a question we got: Dear Team – some time ago i have created a quite sophisticated Excel spreadsheet for my manager which i password protected for increased security. The thing is that it seems that i have forgotten the password which i … Read more