These four overlooked Excel features completely changed how I design spreadsheets.

Today’s topic may seem like an unnecessarily basic one, but I can tell you that nine out 10 shared spreadsheets I receive from team members are unusable for analysis because they can’t be sorted. I’m ...

Excel offers two methods for creating a spreadsheet on top of an image. If you want your entire sheet to display a tiled image, add it as a background and your data will automatically appear on top of ...

When you use MySQL to query a database, you have the ability to view results from that query on your screen or send them to a text file. If you insert tab characters into the output data stream, you ...

To help readers follow the instructions in this article, we use two different typefaces. Boldface type is used to identify the names of icons, agendas, URLs and application commands. Sans serif type ...

Glide turns an Excel spreadsheet into an inventory app; computed columns replace formulas, giving live stock-on-hand totals ...

Tgood37 asked the Answer Line forum how to add checkboxes to Excel spreadsheets, and how to make sure that checking a box will have an effect. If you’re setting up a worksheet only for yourself, you ...

Wow. I just got an Excel spreadsheet template from a friend and it's read-only. How the heck do you make template read-only? Is this a system call in VBA or is this as simple as just setting the title ...