1
  • Current column name in Microsoft Excel

    Could someone tell me what the function is to get the current line number / current column name for cells in Microsoft Excel? Thanks!

    ITKE345,000 pointsBadges:
  • Compatibility mode

    My Excel documents are saving in compatibility mode. How do I change this?

    jlynkett75 pointsBadges:
  • Excel 2010 Second drop down based on first, not working

    I have tried a number of different formulas and data validation scenarios but I have not been able to get my second drop down to recognize the choice in the first drop down. I have a chart of sizes (including fractions) and several weights for each size. I want the weights in dropdown 2 to be only...

    jacktal5 pointsBadges:
  • Excel 2010

    The averages in several columns do not include the product in row 4. adjust the functions in these cells so that all products are included in the calculation.

    enforcer310 pointsBadges:
  • How to change shade color for selected cells

    How do I change the shade color for selected cells?

    woge495 pointsBadges:
  • Excel lookup and totals

    Find specified values in one column, and total vaues in other columns of the specified value.

    tcmichigan10 pointsBadges:
  • Excel function to identify combination of text and numbers

    I have a list of IDs (for example NSD2015, 751234, 92231J,V1819, GR5007 etc.)and would like to identify those from a list of thousands of IDs (each in a separate row in the same column). Tried VLookup but it appears that only works with values? Getting frustrated and I'm sure this is easy to do......

    topdrawer5 pointsBadges:
  • Excel 2010 question

    How do I execute fill right, fill down, and simply undo?

    DLemmon5 pointsBadges:
  • Excel Menu Bar disappeared

    How do I get the Excel Menu Bar back. I add it through the VB Editor, but once I closed and relaunched Excel, the menu bar disappeared again. I was told to search for *.xlb file, but could not find any! Please help.

    Furaha5 pointsBadges:
  • If-then looking for any text in a cell

    This is what I'm trying to do: If cell A has any text in it, then look at cell B and populate cell C based on what is found in cell B.  If cell A is empty, do nothing.  Is it possible? L.

    ExcelBeginner15 pointsBadges:
  • Find and Replace

    I have a spread sheet where I need to replace the space between each word with a hyphen. Since find & replace does not recognize space, is there another way to do this?

    needtobecloned15 pointsBadges:
  • Microsoft Excel

    Gents: Could you please assist me in the below case: 1-I have 2 Excel sheet on my PC (Excel A is extracted on a daily basis from I Series by using data transfer while Excel B is the target one). 2- Excel B (target) has a special header and colors and contains 4 columns and 20 rows with zeros amount...

    Senior1systemanalyst260 pointsBadges:
  • Copy

    Normally when I want to copy a group of cells they become highlighted in blue. One of the sheets in my workbook no longer does this. How do I restore this feature to that worksheet?

    tallpen5 pointsBadges:
  • $ sign and numbers after decimal

    One of my columns is for a $ amount that never changes for that particular person. Recently, I wrapped the text to print out a readable copy. For some reason I lost all the $ signs in that column. Also, when changing an amount such as $176.37, the .37 will not stay.  The $ sign is true for all 129...

    kaykay9085 pointsBadges:
  • I want to play one of two wav files

    I want to play one of two wav files when cell D11 value changed from Right to Wrong. What I have works perfectly for the value "Right". But I don't know how to change the code to play a wav for "Wrong". I tried adding a second modual but that did not work. Sheet 1 Private Sub Worksheet_Change(ByVal...

    Moses585 pointsBadges:
  • problem converting time stored in text datatype to time format in EXCEL

    Hi, Anyone has any idea to convert the time stored in text to time format in excel e.g. 0838 0825

    Leyenda15 pointsBadges:
  • find and replace in excel

    I want to use the find and replace feature under Edit. i want to find a word and replace that word in a difference format. For example, replace charcoal with [strong]charcoal [/strong](in red, bold format), but instead it replaces [strong]ALL the contents in the cell[/strong] with 'red, bold'. I am...

    Lrhehn5 pointsBadges:
  • Function with hours & minutes involved

    Any ideas on how to do the following: I have a payroll spreadsheet that has columns that show the clock in and clock out time that I formatted the cell to give me miliatary time.  I then have a "sum" column that subtracts one from the other to give me thetotal hours/minutes worked.  I have two...

    Coxesoflb5 pointsBadges:
  • Image storage in Microsoft Excel

    I'd like to know the code or procedure to use in Ms Excel that will help me to lookup a photo into a cell. I've observed some customised banking software which is able to display the picture and signature of a client whenever his unique account number is entered. Could I use excel to perform the...

    Snowolf5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following