More and more people are activating dark mode on their devices, especially on apps like Excel that display a lot of white elements. If your eyes are sensitive to light, you spend a lot of time in Excel, or you're working at night, switching to dark mode can help reduce your visual discomfort.
Microsoft Excel's Data Validation tool lets you add a drop-down list to a cell based on existing data in a column. However, how this works depends on whether the source data is part of a formatted Excel table. Let's take a look at some examples.
Microsoft Excel has hundreds of tools and functions, meaning it's quite easy to overlook some of the most useful ones. In this guide, I'll share four lesser-known, hidden tricks that could transform how you use the popular spreadsheet software.
The MOD function in Microsoft Excel lets you work out whether one number is divisible by another. If it's not, it tells you what's left over. For example, if you divide 3 by 2, the MOD function will return 1. In this guide, I'll show you how you can use it to solve real-world problems.
While Microsoft Excel's comments and notes tools both let you annotate a cell, they serve different purposes, work in diverse ways, and vary in how they look on a printed Excel worksheet. In this guide, I'll show you how to use them before summarizing their similarities and differences.
Despite having worked in Microsoft Excel for decades, I'm always learning new ways to speed up my workflow. Specifically, I've stumbled upon some keyboard shortcuts over the past couple of years that I now use every day, and I wish I'd known about them sooner!
Microsoft Excel's CHOOSECOLS and CHOOSEROWS functions are a game-changer if you want to quickly extract specific columns or rows from your data without nesting several functions in your formula. What's more, they're dynamic functions, meaning they adapt to changes in your dataset.
Google's AI function brings Gemini-powered language models right into your spreadsheet cells without any add-ons. With it, you can generate fresh text, summarize blocks of data, categorize entries, or even guess sentiments—all by typing a simple formula.
By default, Microsoft Excel's cells are named by their column-row references, like A1 or B2. However, you can assign a more specific name to a cell or range of cells to improve navigation, make formulas clearer, and save time in the long run.
登录