We show you how to hide and unhide rows and columns in Excel using the mouse, hotkeys, the toolbar and how you can deal with hidden rows on the top of your table. The ability to hide and unhide rows ...

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

This is the demonstration file to accompany the article, Hide everything but the working area in an Excel worksheet by Susan Harkins. From the hottest programming languages to commentary on the Linux ...

To help readers follow the instructions in this article, we used two different typefaces: Boldface type is used to identify the names of icons, agendas and URLs. Sans serif type shows the names of ...

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

When you set up a Microsoft Excel workbook to build an employee roster, calculate profit margins or track sales by region, the application creates a document with three individual worksheets. Each ...

Pro tip: Three ways to hide zero values in an Excel sheet Your email has been sent Although zero values are valid, you might need to hide them. Here are three methods for hiding zero values in an ...