Hi, I am used to using Excel 2007 to convert my workbooks into PDF's. However, recently, all of a sudden, everytime I PDF a workbook my Formating and graphs...

I am using excel 2007 and I am creating a macro that will count the number of account numbers in a column. The problem is that the account numbers are stored...

I am using excel 2007 and I am trying to create a macro that will convert account numbers which are stored as text to a number format. I want to get a...

Can you sort a cell by color?

Every time I use the cut and paste method for moving items, the clip board opens on the right side. Is there a way for turning this option off?

Is there a way so that the scroll bar show me up to the 100th row?

Dear All, I am looking for some help formatting cells with date entries using excel 2003. I have tried using 'formula is' and '=(A1-TODAY())300', and have...

Anybody know how to write a formula for a statement involving "if" and "or" statements such as: if (cell x=? and (cell y=? or cell z=?)) then cell Q=? or...

I am looking for a spreedsheet for TUPE for all employee's information Can anyone help?

Hi-- I have the following setup. I want to return the value based on what is entered in A6 and B6. For example, if the value 1 is entered in A6 and the...

How can I insert a shape onto a frame. Every time I click off design mode the shape disappears behind the frame!!!! How can I stop that?

Hi, Have trawled through the forum and couldn't find the answer so hopefully one of you clever people can help me :-) I have a user who is embedding a...

I am using excel 2007 and my auto filter is not working. There is no drop down box for "blanks" or any of the items except for "select all". Any ideas?

I can successfully merge Excel and Word (using *.csv as data source) . I selected Avery lavel 5163. Addresses are good. Unfortunately, when I print, only one...

Hello, I have 2 questions: - when I resize a chart, the x-axis disappears, but there is room within the object border - how do i stop this from happening? -...

I have the following data: Client January February March (and so on until December) A 1 1 1 1 1 1 1 1 B 1 1 ...

I am using Excel 2007. I can select entire row by using Shift+Spacebar. However, if I press Ctrl+Spacebar to select entire column, nothing happens. Has the...

Everytime I enter the number 1 on a spread sheet, can I make it equal a specific dollar amount? For example: 1 = $22.84 If I am thinking correctly then when...

Hi all, I am asking this for my friend. He has the following urgent problem. He put some VBA code into AUTO_OPEN (AUTO_RUN), basically it execute some other...

In my new spreadsheet I have a list of employees in 192 departments. The sheet is sorted by department, division, then employee name. I have a blank line...