I've been working on converting my old MS Works databases to Excel. At first I converted them to Access, but discovered it wasn't what I truly wanted to use. So now, I've converted them to Excel.
Here's my question, well, 3 of them, and yes I've consulted Microsoft's so called "Help" section. Really should take an adult ed Excel class I suppose.
1. How do you name a column or field and get the name to stick at the top while scrolling down?
2. How do you insert a formula into an entire column to do calculations? (I already know how for individual cells. Can't seem to make it stick in the column though)
3. When applying a filter, how can I save it for future use, is there a "place" to put it for future reference, such as there was in a MS Works Database?
Thanks in advance people. Feel free to pm me if preferred.