Is there anything I can add to the below custom format to make it centered instead of right aligned? Thanks for any help. _(* #,##0_);_(* (#,##0);_(*...

I have a lis of data on customers. I have customer SS #'s in column N. I would like to create a macro that will find out if any one SS # is in the list and...

The menu options "Insert" and "Format" in Excel are grayed out. I already made sure that the files were not shared nor that I had a password. In fact, it...

Is there a way to set a conditional print area? I have a spread sheet that has several sections and want to print based on a formula. If anyone can help...

Is there a spanish version of the Excel 2003 training?

I have a database of 5,500 surnames and associated data in excel . It is always a task to quickly jump to each entry using the "find" function - typing in the...

I need to post the actual amouny paid and have adjust. Thanks Mike

Greetings! I would very much appreciate any information on the following ASKs. Thanks in advance! ASKs -How to create a pivot table from mutiple tables...

Hi! Sorry if this question is posted twice. I tried to post before, it didn't appear in the list of question for long time , so i am posting it again. I want...

In EXCEL 2007:- Office Button / Excel Options / Proofing / AutoCorrect Options / AutoCorrect Options . . . / AutoCorrect tab / Make sure that:- (c) -...

I am using excel to do my financial consolidation whereby i need to link numbers of files and save under one folder on monthly basis. When start to do a new...

I have a spreadsheet where the users can enter data in a cell - for example G26 and the macro will copy the data to another cell - for example B19. The data...

Hi, I have a list of material code in which every material code reaped several time Now I need a list on another sheet in which every material code come...

I have an Outlook merge email that will be pulling numbers from an excel spreadsheet. The numbers are displayed in Excel with one decimal point (53.2%), but...

I am trying to "uncheck" the collate box on the print options for Excel 2007 and then save the worksheet. I would like it to work like this always. When I...

I have some data that I want to filter by months in a pivot table. I dropped the data, and it is working to my needs except that I can't pick month ranges...

Highlight the cells that you want to change then hit:- Ctrl and the ; key simultaneously. The current date will be placed into the highlighted cells....

When I open excel and load or create a sheet or workbook, I then try to send it via e-mail as an attachment (FileSend To) or by clicking the E-mail or Send...

Hi, If sheet1 has some data which is each material code has diff supplier rate now I want highest rate on sheet 2 against material code how I can do that...