Excel's Custom Views tool lets you create a snapshot of your spreadsheet, allowing you to toggle between layouts.

In this article, we will show you how to create, delete, and use a Custom List in Microsoft Excel. The Custom List feature is useful for users who have to type a specific list in every Excel ...

When you get into a car to drive it for the first time, you adjust the seat, the mirrors, and maybe even the steering wheel’s position. You want to make sure that it’s a comfortable fit before you set ...

Excel's ascending and descending sort options are powerful tools, but they won't always sort values in a familiar and meaningful way. When this is the case, you might need a custom sort. Sorting is a ...

Learn how GROUPBY passes both subset and full arrays into LAMBDA in Excel, letting you compute percent shares fast and explain results clearly.

The Automate tab is a gateway to another way of building smarter Excel sheets. It can handle the boring stuff so you can ...

Sometimes when I’m working with an Excel worksheet and I want a cell to look a certain way, I run into what appears to be a limitation in the program. It might be trying to enter product numbers with ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Vivek Yadav, an engineering manager from ...

is a senior editor and author of Notepad, who has been covering all things Microsoft, PC, and tech for over 20 years. Microsoft Excel used to only allow two types of data: text and numbers. After ...