Microsoft Excel 2010 can convert a worksheet to a data table to help you quickly analyze your related data in formatted rows and columns. When you need to expand the table layout, apply the Home tab ...

Your Excel 2013 spreadsheets can benefit from page headers and fixed column titles, also called description rows. They allow readers to follow your pages and understand content easier, because the ...

Placing spreadsheet data into a table quickly formats it and makes it easy to work with and analyze. Here’s how to use this basic yet powerful Excel tool. Tables are one of the fundamental tools in ...

In Microsoft Excel, there are row and column headings on your spreadsheet by default. The column header is the grey color alphabetical columns above the spreadsheet, and it identifies each column, ...

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 ...

The Freeze feature in Excel allows you to scroll down through hundreds of rows and still see the original headers or field names in row 1, or scroll over hundreds of columns and still see the data ...

Here’s a super-quick and easy tip for those who are relatively new to Numbers for the Mac, or the web-based iCloud Numbers beta version of the software. If you want to keep the names of your ...

Word tables are great tools for listing and comparing values. I use them a lot because they’re so easy to create and manipulate. In addition, I’m always learning new tricks to use with them. For ...