Let’s face it—Excel is one of those tools we all rely on, but it doesn’t always feel like it’s working with us. Maybe you’ve wrestled with disappearing leading zeros in your data, or spent way too ...

Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

A scroll bar is an important element in Microsoft Excel. Excel sheets have two types of scrolling, vertical scrolling and horizontal scrolling. For vertical scrolling, you can use either your mouse ...

If Excel is not highlighting cells in the formula, read this post to know how to fix the issue. The default behavior of Excel is to highlight the cells that are part of a formula when a user ...

How to Control Data Conversions in Excel for Windows and Mac Your email has been sent After years of struggling with Microsoft Excel's internal conversion feature, users can now disable Excel's ...

Most Microsoft apps use the same font by default. However, if you want to always use a different font in one or all of your ...

The guide provides insight into how to use the hidden “FILES” function in Excel, a legacy macro function that lists all files in a specified folder. MyOnlineTrainingHub takes you through how to enable ...

Restoring the drag-and-drop menu in your Excel Pivot Table is typically a quick fix. By using either right-click options or ribbon commands, you can easily access the field list again. If all else ...

Years after introducing Excel's automatic conversion features, Microsoft rolls out an update to prevent it from changing gene symbols to dates. Scientists give every gene a name and alphanumeric code ...

Microsoft Excel has been the industry standard spreadsheet software for decades, since outdoing the once venerable Lotus 1-2-3, the first killer app for PCs in the 1980s. And Excel's dominance has yet ...