I get the error "no more new fonts may be applied in this workbook" when changing font (not adding a Graph). Any idea how to fix it. Thanks, Dan

hi community when i closed the excel workbook with a personal macro recorded, why my excel did not prompt another alert to ask whether i wish to save the...

what is the use of table command in data an Scenerio command in tool menu -- Sajjad

I have everyone's start date in a column. I'd like to create another column with their start date in text so that I can then use it in a mail merge for their...

Hi This is a simplified example of what I am trying to do I want to display the result for the max and min and also the year and month. In this case the min...

Hi everyone I am trying to count that if the name in T21 is anywhere in column D and the corresponding cell in column A is between the 01/01/2010 and the...

When I try to save a workbook after doing some work on it - it comes up with message "Document Not Saved".

I'm trying to set up a macro that can be used from multiple workbooks with the same columns but different worksheet names. The number of rows will also...

I have data in LAST, FIRST and used this formula... =TRIM(MID(A2,FIND(",",A2)+1,99))&" "&LEFT(A2,FIND(",",A2)-1) Is there a way to change it from all caps to...

I'm trying to create a "database" for our team so that we can then create a mail merge for our certificates for anniversaries with the company. I found a...

If I have 2 separate worksheets with individual cell values and want the total to show the sum of obth cells, how do I do it? Nelson

Hello I have a file with sheets that have the same header. Each tab has specific page setup formatting that I need to keep intact. I tried highlighting all...

Hi, I am just exploring more with Excel. I am going to paste the table in and explain what I am trying to acheive. A B 1...

I have a spreadsheet with 4 columns, each with a list of names. The names are mostly the same, from 4 different resources, but some are mispelled. I would...

Is there any way to make this format work with Wrap Text turned on? Whenever the text is wide enough to need to be wrapped, I always get...

Dear experts, I have a range which can be autofiltered by users and it's in alternate row shading (conditional formatting, =mod(row(),2)). However, when...

Suddenly the columns in my Excell worksheet are numbered, not lettered. My old worksheets are fine. However, when I open the program to a fresh spreadsheet...

Hi all, I need to move or copy filter Reapply button from toolbar to my worksheet. Is it possible? Thanks, Arty

Is it possible to disable the Send to function in Excel 2003 & 2007? Is it possible to prevent a workbook from being attached to an email - using Excel...

The formula =MID(C7,5,2) & LEFT(C7,2) & MID(C7,3,2) gets me to YYMMDD. I can't figure out how to get the year in full (YYYY).