If there are many blank rows in your Excel sheet, you can delete them and tidy up the document using the "Find and Select" ...

Microsoft Office brings support for Visual Basic for Applications (VBA) macros back to the Mac. But if you haven’t used VBA before, you might be wondering what you can actually use it for and how ...

Microsoft Excel's UNIQUE function does exactly as its name suggests—it extracts unique values from an array. In other words, ...

To insert an in-cell picture saved on your device, from Microsoft's gallery, or imported through the web images search, first ...

Excel documents come in the form of spreadsheets, also known as worksheets, made up of a collection of cells on a single sheet of data. The 2003 version of MS Excel gives you options for rotating – ...

Locking is a handy function in Excel that allows users to lock specific or all cells in a worksheet to prevent any intentional or unintentional editing of them. You can easily lock cells in a sheet by ...

You can freeze columns in Excel with a few clicks, and then unfreeze them when you no longer need to view them statically.

Excel files can be complicated worksheets with pages of data, calculations and cross-referenced information. With all that information, it's no wonder you might feel panicked when one of your ...

There are pros and cons to simple pastes, pasting a worksheet image, embedding the worksheet, or linking to it in your Word doc. Dennis O'Reilly began writing about workplace technology as an editor ...