Microsoft Excel allows you to split the Excel window into separate panes on the same worksheet. This allows you to work on different areas of a spreadsheet without having to scroll between them or ...

If I asked you which Excel tab you use most, there's a good chance the View tab wouldn't even cross your mind. The Insert, Formulas, and Data tabs usually get all the attention, and for good reason.

In this month’s column, find out how to change text strings to sentence case in Excel. The Navigation Pane in Excel is a useful tool that allows users to easily move around and manage large workbooks.

The new Analysis ToolPak is designed for complex statistical and engineering work. However, it’s not turned on by default so you need to activate it yourself when you want to use it. Go to the main ...

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.