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

Microsoft Excel by default shows a horizontal and vertical scroll bar in an Excel workbook. It lets you move through the worksheet so that you can scroll the data on the page easily. But if you don’t ...

How to hide rows and columns and use groups in a shared Microsoft Excel workbook Your email has been sent A few years ago, Microsoft Excel improved collaboration by adding sheet view to shared ...

With an outline in place, you can click the + and – markers to display or hide parts of the worksheet data When you have a lot of data in an Excel worksheet it often becomes necessary to summarize the ...

Locking is a handy function in Excel that allows users to lock specific or all cells in a worksheet to prevent any intentional or unintentional editing of them. You can easily lock cells in a sheet by ...

Creating a macro in Microsoft Excel allows you to program automatic tasks into a spreadsheet or template that can contain multiple commands or functions for easy access and use. After these macros are ...