Double-clicking the narrow button above the scroll-bar on the right, or to the right of the scroll-bar along the bottom will allow you to create a split view of your worksheet, allowing you to see two portions of the same sheet at once. (Our thanks go to Neale Blackwood, who got paid for this tip.)

Microsoft MVP Ron de Bruin has created a free Google Search Add-In for Excel. Initiate searches of the Microsoft web site, your favorite Excel site, or a number of user groups all from within Excel.

You can document your worksheet by right-clicking on a cell, and then selecting Insert Comment. Add a message or instruction associated with that cell. This is a great way to share your thoughts with multiple users of the spreadsheet. Cell comments can serve as a helpful memory aid. Right-clicking on a cell that already contains a comment enables you to add, edit, or delete the comment. (Mitchell Marks got paid for submitting this tip!)

The Paste Special feature on Excel's Edit menu can save signficant time. For instance, you can convert a column of numbers with implied decimals, e.g. 1000 to whole numbers, 10.00. To do so, enter 100 in a worksheet cell, and then copy that cell to the clipboard (Edit, Copy is one way). Next, highlight the cells that you want to divide by 100, and then choose Edit, Paste Special, Divide, and then click OK. You can also use Paste Special to perform multiplication, addition, or subtraction.

Sometimes it's helpful to see two sheets within the same workbook at the same time. To do so, choose Window, and then New Window. Next, choose Window, Arrange, and then choose Horizontal. Click Windows of Active Workbook, and then click OK. If you want to see the windows side by side, choose Tiled or Vertical in the Arrange dialog box.

The Payne Consulting Group offers a free March Madness spreadsheet that you can use to track the progress of your favorite college basketball teams through the field of 64.

Working on multiple files today? Open them all at once tomorrow by creating an Excel Workspace File. Choose File, Save Workspace to group all of the files you currently have open into a workspace. You can open the group of files all at once by choosing File, Open, and then change the File Type to Workspaces to access your saved workspaces.

You can zoom in or out on a worksheet by holding down the Control key as you scroll the wheel on your mouse. Separately, the freeware program FreeWheel enables scrolling in the Visual Basic Editor if it's not already supported by your mouse driver.

You can copy a formula or text to adjacent cells by clicking on the fill handle (the notch in the right-hand corner of a worksheet cell) with your left-mouse button and dragging either down or across. (Our thanks go to Kedar Desai, who got paid for submitting this tip!) For even more options, hold down the right-mouse button while you click and drag...when you release the mouse button, a shortcut menu will appear.

The =EOMONTH function is a handy way to determine the last day of a given month. However, that function requires that you have the Analysis ToolPak installed and enabled (users often don't). Instead, use the =DATE function. For instance, =DATE(2000,1,0) will return 12/31/99. You can also use this technique in your VBA macros and functions. (Thanks to Stephen Bullen for this clever tip!)