If you’re working on an Excel file and want to keep some data or sheets out of sight without deleting them, hiding the worksheet is a useful option. This helps organize your workbook, reduce clutter, ...

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

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 unhide row 1 and column A in an Excel sheet Your email has been sent The typical unhiding techniques don't work everywhere in Excel. Learn an easy to remember method for unhiding row 1 and ...

Sometimes hiding certain columns in an Excel spreadsheet can be helpful: Doing so can make spreadsheets easier to read or you may have other reasons to hide them. In any case, hiding columns in ...

The Developer tab unlocks powerful automation tools in Excel—macro recording, Visual Basic for Applications (VBA), XML import, and form-controls. Because most users rarely use these features, ...

Microsoft Excel 2010 provides a formula for calculating the average value from multiple worksheets in a workbook. Before you apply this formula, check that each worksheet is formatted the same way.