When I learned how to use tables in Microsoft Excel, it totally transformed how I work with data. Even if you think you already know everything there is to know about Excel tables, hopefully, you'll ...

If you're working on a long scrolling spreadsheet, use "Freeze panes" to get your column headings to stick around when you scroll down through rows of data. First, place your cursor in column A row 2.

When reading across a wide list of data, such as an account ledger or product description list, it is easy to confuse the rows. This is especially true when scrolling across the screen. To minimize ...