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

Excel spreadsheets are designed to help you organize and present your data. All columns automatically have a header label, starting with the letters A-Z and then moving on to AA, AB and so on. You can ...

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

Please note: This item is from our archives and was published in 2000. It is provided for historical reference. The content may be out of date and links may no longer function. The July Technology Q&A ...

What’s the difference between a table and a range of columns and rows on an Excel spreadsheet? How do I create and populate tables? And, once a table is created, how do we custom filter, format, and ...

How to sort a single column in Excel without disrupting the rest of the spreadsheet Your email has been sent We tend to view spreadsheet data as a whole, and that’s as it should be. Seldom does a ...