Sorry, this was meant for a Word group! "janey" wrote in message...

Hi, I looked, honest. The HELP was no help, either. Gosh, things were sure simpler with the earlier versions. Anyway, how do I go about setting the...

Each month we need the identities of employees who joined the company 3 months and one year ago. It is nonsense to go through the list manually, but I can't...

When we type a letter in the cell, the cursor should move to the word starting with that letter in the drop down list. How this can be done?

Hi On sheet 2 I have a 13 digit code in Col A, the description in Col B and the price in Col C, these will be constantly added to manually. On sheet 1 I...

Please help

Dear all: I'm a college teacher and have been using Excel to post students' various quiz/exam grades on the web. However, starting from this semester, we...

I am new at excel and would like to know how I can convert text to all upper case letters without having to retype everything.

I am currently trying to convert my cells from this format 11/9/2009 08:26:21:523 to just mm dd yyyy hh mm ss, format. if anyone knows how to do this, Your...

Is it possible to create 2 subforms using the same table and how do I link them? I need one to show fields to populate and one to show cust...

On numerous occasions we have used the preset conditional format for highlighting duplicate or unique values. However, we now have come across the need to...

What is the difference between Merge/Center and Center across selection? As far as i can tell they are the same thing.

Consider the table below. If you do a pivot table summing the qty of Product, you end up with abc, with a net of 0, and ast with a qty of 0 also. If I wanted...

Sub Macro1() ' ' Macro1 Macro ' Macro recorded 3/16/2005 by jim ' ' Range("B9").Select Selection.Cut Range("F8").Select

Hi folks, I have a multi-sheet workbook. Each page has a sell containing a total - let's call it "D2" again... :o) I want to take data from cell "D2" on each...

I tried to search for this solution on the web, but finally gave up. Here's what I want to do In a cell I have a users First and Lastname (yes both in the...

It's driving me crazy. I can't get columns to unhide after hiding them. I have to go to the "select all" and then drag the columns open. It said something in...

Hello, I'm setting up a Sales Journal in Excel. I only need 50-60 rows and the document I have open and set up has over 65,000 rows. And...of...

Hi, I've been keeping track of the songs played by my band for the last few weeks, and I want to be able to sort the list by how often the song has been...