Microsoft Excel lets you format tables, adding borders and colors, and lets you format the text in them, editing font, size and style. A spreadsheet may contain a number of tabl ...

Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.

Q: To make an Excel table fit better on a page when I print it, I frequently have to transpose it—that is, move all the data from, say, rows 1, 2 and 3 and put them into columns A, B and C. To do that ...