A few people have mentioned a desire to try alternatives to Microsoft Office. If this is something you'd like to try, I'd recommend the excellent Open Office package. It has a word processor, spreadsheet, presentation, and database component. You can download the latest version here.
If you look at the upper-right corner of your spreadsheet above the scroll bar, you'll notice a small bar:
Click and drag this bar down. You will see a gray bar move up and down when you move your mouse. Let go when it's where you want it. Now that section will not move when you scroll up and down.
Search and replace works for more than just text content. In Microsoft Word, you can search and replace how text looks, too. For example, you can make all the bolded text italicized instead. The secret knob is the More dropdown in the Search and Replace dialog box.
Microsoft Excel and Word allow you to split the screen to give you different views into the same document or spreadsheet. The first thing to look for, to see if your program offers this feature is a tiny spacer next to the scrollbar. There may be one above the vertical scrollbar.
There may be one to the right or left of the horizontal scrollbar.
If you are upgrading your PC, there's an easy way to keep all the settings you have in Microsoft Office. The How-To Geek site explains how to save and restore your MS Office 2003 settings on another computer.
This tip is from Michelle Rosenberg, for Oshkosh ILL staff. But, I thought it would apply for others as well.AutoFilter allows you to easily sort all field of your spreadsheet.Highlight the header row:From the menu choose Data, then Filter, then click AutoFilter.You will now see arrows in the right of each of the column headersClicking on the arrow gives you the ability to sort in ascending or descending order based on the information in that column.
If you wish to set up alternating row colors in Excel, first highlight the rows that you wish to apply the formatting to. In this example, I've selected all rows in the spreadsheet.
Under the Format menu, select Conditional Formatting.
