Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel questions


  • Please log in to reply

#1
Pluto56

Pluto56

    Member

  • Member
  • PipPipPip
  • 160 posts
Got new puters at work. Came with Excel 2003 on them, which we had before but I'd not used very much as everything I was doing was in MS Works, databases, etc. The new machines don't have MS Works on them.

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.

In Excel:
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.

Thanks again!
  • 0

Advertisements


#2
Pluto56

Pluto56

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 160 posts
Think I've figured it out, except the saving filters for future use.

Anyone???
  • 0

#3
Octagonal

Octagonal

    Member 2k

  • Member
  • PipPipPipPipPip
  • 2,528 posts
Pluto56

The filters that you wish to save, are they based on more than just a couple of columns? There could be an easy solution to your problem.

Octagonal

Edited by Octagonal, 20 January 2006 - 06:22 AM.

  • 0

#4
Pluto56

Pluto56

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 160 posts
in most cases 2 columns. One has 4 columns.

Thanks!
  • 0

#5
Octagonal

Octagonal

    Member 2k

  • Member
  • PipPipPipPipPip
  • 2,528 posts
There are a couple of ways that you can do this.

First of all you can use AutoFilter.

This is quite easy to use and reasonably quick. When you have saved your column names (Fieldnames), go to Data menu and select Filter then Autofilter. This will create little dropdown arrows in each of the column name cells. Simply select the data that you wish to filter the column by selecting the appropriate data from each of the drop down cells. Although this won't save the filter, it is quite easy and quick to use.

Have a look at this link for an example of how to use this feature.

I'll check back later to see if this suits your needs.

Octagonal
  • 0

#6
Pluto56

Pluto56

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 160 posts
I've been using the auto filter to apply my filters.

But how do you save your filters for future use, and where, or is it just easier each time to do it manually as needed?

Thanks Octagonal.
Have to leave for work now, but I'll check back this evening.
  • 0

#7
Octagonal

Octagonal

    Member 2k

  • Member
  • PipPipPipPipPip
  • 2,528 posts
You can do them muanually as needed, they don't really take long. The other alternative is to use a macro or VBA code. They will be saved and if you really require them I can assist you in creating a couple.


Octagonal
  • 0

#8
Pluto56

Pluto56

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 160 posts
Thanks, but think I've decided to just doing them as needed.

Again, Thank you Octagonal.
Great place you've got here!
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP