• Find high value than look up value in Microsoft Excel column

    The VLOOKUP function in Microsoft Excel is great at finding exact matches or the value just less than the lookup value. I need the next higher value than the look up value from a list of  values in single column.

    Bikashgoon5 pointsBadges:
  • Limit to number of rows and columns in an Excel spreadsheet

    What's is the limits to the number of rows and columns that an Excel spreadsheet can have?

    Famous5 pointsBadges:
  • Entries are reversed in Microsoft Excel spreadsheet

    This is an interesting issue. I'm using Office 365 and whenever I start typing into an Excel spreadsheet, it's writing everything backwards. Basically I type this word 'number', it gives me 'rebmun'. I'm not sure how to stop it. Why is this happening?

    ITKE1,021,365 pointsBadges:
  • Importing CSV file into Microsoft Excel 2016

    This may seem simple but I feel like every version of Excel is getting worse with CSV files. I'm running Excel 2016 and I can't open a CSV file. I can't import the data at all. Can someone help please?

    ITKE1,021,365 pointsBadges:
  • Program that exported data to Microsoft Excel

    A co-worker from another department send me an Excel spreadsheet that has is exported data from another program. I need to find out which program it is. Can anyone help?

    ITKE1,021,365 pointsBadges:
  • Go to Excel worksheet by clicking on cell

    I have two worksheets - namely ABC and XYZ. In worksheet ABC, I have written XYZ in one cell. So now how to I go to the worksheet XYZ by just clicking on the cell containing XYZ in worksheet ABC?

    fkpwala15 pointsBadges:
  • Zero keeps disappearing in my Excel spreadsheet column

    So I'm adding some of my personal information into an Excel 2007 workbook and I've noticed that when I put in a number count that starts with zero, it automatically disappears. Here's an example: 012345678 changes to 12345678 What do I have to do keep the zero as entered and not disappear.

    ITKE1,021,365 pointsBadges:
  • Lock specific columns in Microsoft Excel

    In my Microsoft Excel spreadsheet, I have three columns that I want locked (so no one can change anything). But when I clicked on format -> Lock Cells, it's protecting all of the columns. I just want these three locked. How can I do this?

    ITKE1,021,365 pointsBadges:
  • Add colors to Microsoft Excel template

    Hello, I'm using Microsoft Excel and I have multiple charts that I want in the same colors. I have a list of 20 or so colors so I'm looking for a template that I can implement these colors in (so I don't have to do it manually every single time). How can I do this?

    ITKE1,021,365 pointsBadges:
  • Exporting “Appointments and Meetings: More Choices – Advanced Find” to Excel

    How can I export advanced searches done in "Exporting "Appointments and Meetings: More Choices - Advanced Find" to Excel, print as a list (not as individual memo's), or save as a file to refer back to?

    chadlrhvac5 pointsBadges:
  • Delete non-English/alphanumeric characters in Excel workbook

    How can I delete non-English/characters, special characters, unnecessary spaces? I have a Microsoft Excel Workbook where I've 240 Thousand different type of  descriptions that are alphanumeric and Chinese characters. Examples: 03�� 120 10 千克≤重量<50 他猪(改良...

    EmyHazel5 pointsBadges:
  • Recover password for Excel VBA macro

    About a month ago, I set a password for an Excel VBA macro but now I forgot it. I can't download the Hex Editor. What should I do? How can I get my password?

    ITKE1,021,365 pointsBadges:
  • Macro for removing bullet points in Microsoft Excel cells

    In Microsoft Excel, I have a column that has thousands of cells in it. The cells include: Text Bullet point I need a macro which would delete all those bullet points (but not the text). I don't want to do this manually - would take up too much time. Can I do it?

    ITKE1,021,365 pointsBadges:
  • Microsoft Excel: How to convert data from rows to columns

    I have a bunch of data in Microsoft Excel that I need to convert from rows to columns. Basically, here's what I want to do: Sport College Coach Division Basketball Uconn Ollie Division 1 Change that to: Sport Basketball College Uconn Coach Ollie Division Division 1 How can I do that?

    ITKE1,021,365 pointsBadges:
  • Cannot open Microsoft Excel document: There was a problem sending the command to the program

    Whenever I try to open a document in Microsoft Excel 2010, I keep getting this error: There was a problem sending the command to the program. Here's the key - when I have Excel already open, it's fine. This is only happening when Excel is closed. What can I do?

    ITKE1,021,365 pointsBadges:
  • Excel formula help IF LEFT or

    I need an Excel formula: =IF(LEFT(b1;2)or(1.;0.;2.;3.;4.);b1*4;b1*2.1). I don't think it is correct. It should duplicated the number in cell C1 from B1 with 4 when first two letters are 0. or 1. or 2. or 4. If not, it should duplicate with 2.1.

    postavosta5 pointsBadges:
  • Microsoft Excel formula for how many times a name shows up in a column

    My Microsoft Excel sheet has several columns that contain different names in it. For example: Michael Melanie Matthew Katie The names are in the column multiple times. How can I count how many times a name shows up in a column? Is there a formula for that? Thank you.

    ITKE1,021,365 pointsBadges:
  • Microsoft Office: Missing Localized Strings Here

    I downloaded microsoft office from my college's website, and when I tried to open it the message "missing localized strings here!" what does that mean and how can I fix it?

    dsawyer5 pointsBadges:
  • VBA Do While Loop

    Dim iJob As Integer Dim strJob As String iJob = 5 Do While ThisWorkbook.Sheets("Defaults").Cells(iJob, 21).Value <> "" And iJob <> 4 If ThisWorkbook.Sheets("Defaults").Cells(iJob, 21).Value = strJob Then Select Case ThisWorkbook.Sheets("Defaults").Cells(iJob, 21).Value Case strJob...

    Wolfehound725 pointsBadges:
  • Download details of VK13 in Microsoft Excel

    Can I download/export details of vk13 (condition type- Slab Price with historical data) in Excel. Is there any T-code or table?

    Marmik5 pointsBadges:

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.

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

Following