Hi, is there a way to enter lower case text into a cell, say A1, and upon exiting that cell the text automatically reverts to upper case? If this is not...

I cannot figure out how to access the HELP INDEX of subjects

Is there a limit to how many worksheets can be inserted into one workbook? If so how many? Thanks, Janice

I have a workbook called invoice, in it I have two tabs called invoice 1 and invoice 2. I have another tab called flat glass calc. My problen is this jezzz I...

I have a worksheet with 3 rows of columns headings. The first row is standard columns headings. The second row is a merged cell text line. The third row is...

Dear all, Hope you can help me with the following. I need to create a range (Dynamic range). As all of you are awa Insert-Name-Define... However, the name...

I have data of non-numerical in nature that I want to sort get totals. How do I do this and report the results?

Is there a way I can probihit someone from changing the name of Author that created a Worksheet? Thanks for help. Turnerpla

Happy new year to all! I recorded this macro some time ago, the cell A5 is selected at the end of the macro, ready for the user to insert today's date. How do...

How do I set up Add-Ins for iSeries Access Data Transfer in Excel 2007

Some EXCEL files display a prompt when closing the file that asks if you want to save changes even when the file was merely opened and viewed, no cells...

I had my resume on the desktop in a scanned folder )zip file) I right clicked and chose import to microsoft excel. When I opened the file it was in...

Hi! How to find repeated data and then merge and centre. My data is from A to M.Range from A1 to M4500 Any Function Or Macro. Thanks Hardeep

Wish to create a spreadsheet that will track the potential lost sales of accessories if Widgets sales goal is not met. Example: Goal is 30 % accessories. Sold...

I need to know how the initial setup for outlook.

Jeg har et regneark med alle mine kunder og noen opplysninger (8 kolonner.) Jeg har laget et nytt ark ( i samme bok) hvorpå jeg bearbeider disse...

HELP! I have a multiple sheet workbook each with an identical table that needs to be sorted on a specific column at the end of the month. When I attempt the...

I have more than 10000 student records in Excel worksheet 1. One of the columns represent the student names. But there is a list of keywords that is forbidden...

I'm new to excel, I have all the information set up on excel with name, address, date of birth, etc. what I need is the formula to calculate age in excel. I...

Frank, That formula work great, but when you are tagging duplicates where the range has formulas in them, then the formula ends up getting tagged as a...