I am trying to help my daughter do a crossword puzzel project for school. At the bottom of the puzzel, we were trying to put the clues. How do we show all...

I have a list of e-mail addresses on a spreadsheet. They automatically convert to hyperlinks. I don't want these as links- simply a list of addresses. How do...

This was more cumbersome than I realized (at least with Excel 2003). I found this code on another forum and it works like a charm: Here's the link to the...

I need a formula for the following condition: If text equals (word) then enter 1, if text equal (word 2) then enter 0 This is the formula I tried to used but...

how to apply Warning massage so that a wrning massage should pop-up while comparing two mismatched values

Dear, I am looking for a formula which counts only the numerical values within a cell ignoring the special characters, text and anything else and gives the...

Can data validation be set up to accept a 0( (zero) or any whole number between 25,000 and 10,000,000? Or does this have to be controlled with VBA? This...

I have a column of random dates ranging from 1-1-2007 to 1-1-2017 in the format of ddmmmyy. I am trying to create two more columns of data, one containing...

I need to ensure each cell has 8 characters throughout a column .

I have some date strings I need to convert to date format. For example im trying to convert strings like "200910" to Oct-2009. I tried using something like...

Need to merge A1 with B1. Critical to retain the format of each cell. A1 has text that is Left Justified. B1 has text that is Right Justified. Need the...

In the past I was able down load a number from a data file (credit card transaction numbers for internal audit part of my job) I would have to change the...

I have spreadsheets that have formulas in them and each time I want to find the values I need to change it in the options. I want the find function to always...

I've created a spreadsheet with a drop down list, however, i want the user to be able to select an from a list of options, which would then poplulate the...

I set schedule to open excel file, when it opens, the excel window's size is not maximized, and I have tried your approach, for manually opened approach, it...

Hi I have a workbook with 14 pages I add page 15 & 16 which are blank How do I move all of page 14 (contents, page layout, formating, headers/footers...

I have a sumproduct formula(s) that is calculating very slowly in my workbook. =SUMPRODUCT(((Data!$D$2:$D$10000=$E22)*(Data!$A$2:$A$10000='H-Code SS...

Dear All, i have a master data from client and my data from data entry. Now i want to compare from both data. ie, sheet1 (master data from client) Names ...

Good evening all the peeps of the Excel Community. This one has me completely flammuxed but hopefully someone can spot my obvious error that I can't ... I...

Can i set up an excel file to open automatically on pc start up?