training in using your ibm laptoptraining in using e-zekiel managed websitesrequest training from dantraining in using microsoft wordtraining in using microsoft windows xptraining in using microsoft publishertraining in using microsoft powerpointtraining in using adobe photoshoptraining in using microsoft outlooktraining in using microsoft infopathtraining in using adobe indesigntraining in using microsoft exceltraining for birmingham office staff and remote access userstraining in hardware and software talk to danthanks from technology usersthoughts from dan (online journal)travel calendar for dantroubleshoot your computer problemtraining in hardware and softwaretechnologies in use by campus outreachtake me to the home page

excel

We use Microsoft Excel almost as much as we use Outlook. Coming soon are training videos on how to perform common Excel functions.

Action

Scenario

Size
[no training videos]
freeze panes

You may often create or use a worksheet, such as a budget, where you will have both rows and columns that you always want visible. When this happens, you will want to create "header" rows and columns. To do this, select the cell immediately below and to the right of the rows and columns you want as headers [i.e., selecting D6 will make horiztonal and vertical headers of rows 1-5 and columns A-C]. Then click on the Window menu and select Freeze Panes.