There are over 1,000,000 rows and 16,000 plus columns in each Excel worksheet.

Most of the time our data fills very little of the available area and all that extra space can sometimes be a problem.

If less experienced users need to access your worksheet they can end up getting lost in the wide open spaces that sit outside the data area.

Or, you may want to restrict access to certain data outside the work area to keep it safe from accidental changes.

Whatever the reason, you can temporarily limit the number of rows and columns accessible by changing the Scroll Area property of the worksheet.

To find out how to do this read the short tutorial on how to Restrict Scrolling in an Excel Worksheet

Related Tutorials

• Freeze Panes in Excel
• Split the Excel Screen with the Split Box
• How to Lock Cells in Excel

Freeze panes lets you to lock specific rows and columns so that they will always be visible on screen no matter how far you scroll to the right or down.

Using this feature can prevent constant back and forth scrolling in order to check which column or row of data you are looking at in large worksheets.

To find out the details, read this tutorial on using Excel's Freeze Panes feature

Related Tutorials

• Divide the Excel Screen using the Split Box
• Restrict Scrolling in an Excel Worksheet
• Hide and Unhide Columns and Rows in Excel

To see more than one copy of a worksheet in Excel use the split box to divide the screen into panes.

Splitting the screen makes it easy to compare different rows or columns of data located in different parts of a worksheet.

It can also be used as an alternative to freeze panes for keeping worksheet titles or headings on screen as you scroll.

To find out all the details, read the tutorial on how to Using the Split Box in Excel.

More Worksheet Tutorials

• Restrict Scrolling in an Excel Worksheet
• Hide a Worksheet in Excel
• Hide and Unhide Columns and Rows in Excel

When you find yourself repeatedly performing the same actions or tasks in a spreadsheet, it might be time for you to create a macro.

A macro is a recording of each command and action you perform to complete a task. Then, whenever you need to carry out that task in a spreadsheet, you just run the macro instead.

Complex macros are usually created in Excel with the Macro editor. Simpler macros can, however, be created using the Excel macro recorder.

To find out how to create a macro using the macro recorder in Excel, read the step by step Excel Macro Tutorial.

Related Tutorial

• Excel 2003 Macro Tutorial