Friday May 17, 2013
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
Wednesday May 15, 2013
Excel Freeze Panes Tutorial
© Ted French
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
Monday May 13, 2013
View Multiple Copies of a Worksheet
© Ted French
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
Friday May 10, 2013
When you find yourself repeatedly performing the same actions or tasks in a spreadsheet
, it might be time for you to create 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