Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

9
votes
2answers
25k views

Excel pie chart: How to combine smaller values in a single “Other” slice?

I have this pie chart in Excel 2010 (based on a pivot table): I'd like to combine all the values smaller than X% in a single "Other" slice. In previous versions of Excel, it was possible to use the ...
0
votes
1answer
169 views

Excel 2010 - How do I record a macro and play it back for all cells in a column?

I need to make a macro. I can (barely) figure this out. This macro will perform an operation on a single cell (convert link text into a live link as in In Excel, I pasted in a bunch of URLs, but they ...
1
vote
1answer
3k views

Excel - replace multiple strings in a single cell, based upon a lookup table

I would like to do a replace on multiple strings within a cell, based upon a lookup table. My lookup table has two columns: AUSTRIA | AT BRAZIL | BR COLOMBIA| CO My data table has two columns: ...
7
votes
4answers
17k views

How to batch convert .csv to .xls/xlsx

I am looking for a way to quickly convert a directory of .csv files into the .xls or .xlsx format (would be nice if I could do either/or). Is there an easy way to do this or do I need to install a ...
2
votes
1answer
2k views

In Excel, I pasted in a bunch of URLs, but they aren't live links — how do I bulk convert them to live links?

In Excel, I pasted in a bunch of URL's into a column. However, they aren't live links after pasting. How do I bulk convert them all to live links swiftly?
5
votes
4answers
14k views

Excel VBA Function runtime error 1004: Application-defined or object-defined error

I'm trying to learn functions for the purpose of simplifying and reusing code whenever necessary. I began by turning something I use pretty often into a function: Returning the integer value of the ...
4
votes
3answers
11k views

Excel 2010 data validation warning (compatibility mode)

We have some legacy worksheets that were created in Excel 2003, which are used by LabVIEW-based test automation software. The current LabVIEW software can only handle the legacy .xls format, so we're ...
2
votes
1answer
928 views

Convert time to decimal equivalent it Excel / Emacs

I'm trying to create a chart of my times for my runs (e.g. 25:30, for 25 minutes and 30 seconds). How could I convert this "analog" time to the decimal equivalent (e.g. 25.5 minutes)? The problem is ...
1
vote
0answers
337 views

Excel - Clickable link in pivot detail

I have an Excel pivot table with a SQL data source. One column of my data is the path and filename of an image. I'd like the user to be able to click to open the image when they are in the details ...
-6
votes
1answer
814 views

Is there an equivalent of Excel's DATE() function in Access 2007? [closed]

Is there an equivalent of Excel's DATE() function in Access 2007?
1
vote
1answer
693 views

How do I Transfer the Cell Data from one Column to the Hyperlink Address for a Corresponding Column's cells?

How do I transfer the cell data from one column to the Hyperlink address for a corresponding column's cells in Excel 2010? Example: Cell F4: www.microsoft.com Cell F5: www.google.com Cell C4: ...
2
votes
1answer
807 views

Macro for helping superscript last character of many rows in a single column

I'm adding footnotes (always adding footnotes) to a table and I would really like to be able to automate the repetitive nature of making my symbols superscript. Currently it’s: >enter cell>highlight ...
2
votes
1answer
304 views

Excel 2010: How to rearrange a column into a row

I'm trying to invert columns and rows in a part of my worksheet: columns should become rows and vice-versa. How can I easily do that?
0
votes
1answer
655 views

Is there a way to update Outlook contacts from Excel?

So I have a list of contacts in Outlook (imported a long time ago from an Excel sheet). People move, people get new email addresses and so on, so the Excel list is updated. Is it possible to import ...
8
votes
6answers
114k views

Why does Excel not auto-update my equations anymore? [duplicate]

For some reason all of a sudden when I update cells in Excel, my equations are not being updated. For example, I have a simple equation =SUM(C4:C16). If I change any of the cells in C4-C16, the ...
0
votes
2answers
455 views

The value “1000.00” is displayed as “1000.00.00” in Excel when opening a HTML page

The following fake excel file: <style> .text { mso-number-format:\@; }</style> <div> <table class="results" cellspacing="0" rules="all" border="1" id="ctl00_content_grdData" ...
4
votes
3answers
2k views

Calculating the average of variably sized blocks of numbers within a column?

In column A I have a set of numbers (over 1,000), and I want to get an average of a block of them at a time, (e.g., 10, so A1:A10 then A11:A20 and so on) and write these averages into column B, such ...
0
votes
3answers
2k views

How to stop automatic conversion from text to hyper links?

How to stop in Excel automatic conversion from text to hyper links with formatting style? I know that this feature is good in most cases, but I work on report creation and I have problem with long ...
4
votes
2answers
3k views

Excel 2007: where to find the option 'Trust access to Visual Basic Project?

I tried to run a plugin in Excel 2007, and I got this error message Do anyone know how I can access this feature from the 2007 GUI? I am confused by the new interface.
0
votes
2answers
847 views

Excel - Enter Qty of Hours as hh:mm And Perform Calculations on It

I guess this is two related questions in one question. I'm creating an Excel spreadsheet and I need to enter Qty of Time Spent in the format hh:mm in one cell and in another I'll be calculating the ...
4
votes
2answers
1k views

Excel 2007 save import steps on csv file?

I have a csv file that constantly needs opened into Excel and then have the data copied over to a separate workbook. I find the process of having to click through all of the dialogs, setting the text ...
4
votes
2answers
2k views

Excel: How to force cell evaluation

I have a list of start times that need to be converted to 24 hour format. I changed the format for the entire column, but i have to press Enter for every row for excel to apply the new format. Is ...
6
votes
2answers
24k views

How to disable the annoying compatibility warnings in Excel?

Every time I edit a CVS or 2003-2007 Excel file it gives a warning that it will be saved in compatibility mode. I have this habit of saving every other minute via Ctrl+S and the window keeps popping ...
3
votes
7answers
13k views

Opening CSV file in Excel corrupts telephone number column

I export listview data to csv file. There is a column, 'Contact No'. This column's data type is 20 field size of text in MS access. Opening this csv with Notepad, it shows the actual data value, ...
3
votes
2answers
3k views

Only Add Odd Or Even Numbers To A Cell

I want to create a cell in and Excel spreadsheet that can only have Even numbers entered into it and also one just for Odd numbers. Any ideas what formula I can put into the Data Validation formula to ...
2
votes
2answers
6k views

Excel: Bubble chart labels - use 4th dimension?

I've got a dataset that has 4 dimensions - lets say they're the following: +------------------------------+ | Type | Amnt |Price| Quality | +-------|------|-----|---------+ |  A    |  15  | 4.0 |   ...
2
votes
4answers
16k views

How to set a character limit and remove characters over that limit excel 2007

I have to provide a CSV file for a telephone system with names and numbers on for a directory. The numbers cannot contain any spaces, and the names must be 20 characters max. I have a list of ...
2
votes
3answers
15k views

How can I sum values within a specific time and date range?

I'm trying to work out which formula to use for summing values within a period of time and date. I have the following data: A B C Jan 1, 2011 8:00 AM 10 Jan 1, ...
5
votes
4answers
15k views

Is it possible to run Microsoft Excel under Ubuntu?

I have a dual boot system with Windows 7 and Ubuntu installed on my machine. I use Ubuntu much more often than Windows 7. On Ubuntu I can use LibreOffice Calc, but I'm more used to Microsoft Excel ...
1
vote
1answer
272 views

Automatic Conversion to Specific Date Format in Excel 2010

Each time I enter 6/1988 in an Excel 2010 cell and press Enter, or select other cell, that entry, 6/1988 changes to Jun-88. I want to keep that entry as 6/1988. Even if I choose general formatting for ...
5
votes
3answers
1k views

Preserving Greek letters on my PC

How would convert this long table of vocabulary (one column of greek then one of english) in this document into one excel spreadsheet where the Greek characters are preserved? Whenever I try to ...
0
votes
1answer
1k views

Excel: Filter Pivot Table from Another Sheet / Duplicate Filters Across Sheets

I am working with Excel for Mac 2011. I have several different pivot tables that each organize data for graphing on a summary sheet. Every pivot table should be filtered the same way. Questions: ...
1
vote
2answers
17k views

How to disable auto recover?

I've tried disabling "Save AutoRecover information" option, but to no avail. The window "Excel has recovered the following files" still pops up at the start. Any other ideas? UPD Auto-recover window ...
0
votes
1answer
426 views

Subtracting time values in Excel - If sum is less than one hour it automatically adds 12 hours to sum

A team of our uses an Excel spreadsheet for their timesheets and uses the 12-hour format. When inputting time worked if the time is says 2:15 PM - 1:30pm, the sum should be :45 however, for some ...
1
vote
2answers
3k views

Make cell in Excel mandatory (prevent save) - without macro

I'm looking to prevent an Excel document from being saved if a particular cell (say F5) is not filled out. However, I cannot use a macro, as I'm providing this document to users to fill it out as a ...
0
votes
1answer
499 views

Zeroing everything except formulas and text in excel

Is there a way within excel to clear a sheet of all numbers, but leave behind text and formulas? To elaborate: I mean cells that contain ONLY numbers. If a cell contains text and numbers (like ...
2
votes
1answer
10k views

Excel PivotTable - Categories and Subcategories?

I'm trying to do a fairly simple pivot table on a range of person financial transactions. Each transaction is a row in the source table, and has the following columns: Type, Description, Amount, ...
0
votes
1answer
2k views

Sort doesn't work properly for cells with references to other cells

I have two tables in Excel 2010, the second table has the last column filled with cells that reference the last column cells from the first table: For instance, the value of the first cell in the ...
1
vote
1answer
75 views

Can excel organize my data into groupings?

First off, my data sample: EZ LOADER 1 FAIRMONT MOBI 1 FARMALL TRACT 3 FORD 5 FORD 700 1 FORD F-150 1 FOUR DOO 1 FOUR WINNS 1 GENERAL 3 GENERAL ...
2
votes
1answer
664 views

How do I create a macro that copies one row down based on the # of records in another sheet?

Using Access I export/create a daily Excel spreadsheet which has an increasing number of records/rows. I'd like to then open a master Excel sheet, which: Opens the exported sheet. Counts the number ...
1
vote
2answers
4k views

Excel data validation for decimals, but without a range?

I want to use the Data Validation in Excel to prevent users from entering a non-decimal value, but I want to allow them to enter any decimal value, however you are forced to provide a range or ...
2
votes
2answers
10k views

Pass a cell contents as a parameter to an excel query in Excel 2007

I have tried really hard to solve this issue but I think I am going to need a little help. I can program in different languages but I don't have any experience with Excel, VBA or the queries you can ...
1
vote
3answers
4k views

How to map the details between Excel sheets?

I have an Excel worksheet with two sheets and two columns each with the below input: sheet 1 data: column1 column2 ------- ...
0
votes
2answers
742 views

Excel pivot table - missing fields

OK - I've inherited a spreadsheet with a pivot table I can trace all the pivot table fields to the headings in another worksheet, except one of them. There is a field shown in the list I can't find ...
0
votes
1answer
239 views

How do I sort two columns against one in Excel 2003?

I need to produce a method of moving the B and C columns to match up with A so: with a macro or formula it should produce: Column 1(A) should be unchanged but 2(B) and 3(C) moved; 2 and 3 will ...
1
vote
2answers
728 views

How to have a whole, refreshable MySQL database inside Excel

I have a MySQL database and have a lot of users that want to use Excel to process this data. I know how to do two things that I don't want: I know how to import a MySQL database into Excel. I know ...
4
votes
4answers
75k views

Keyboard shortcut to change case of text in cells in Excel 2010?

Is there a keyboard shortcut in Excel for changing the case of selected cells (to lower or upper or whatever)? All my searches lead me only to functions to do this. But that is not what I want.
2
votes
4answers
958 views

Excel: How can I summarize by a field and then sort by it?

I have customer support case data like this: Customer Time Account_A 90 Account_A 45 Account_B 25 Account_B 90 Account_B 35 Account_C 100 Account_C 120 How would I summarize by customer ...
1
vote
4answers
3k views

Excel: struggling to use CF to highlight differences between columns in the same row

I have a list of vaules in column A and column B. I need to highlight where there is a difference between values that are in the same row. I've used a simpe formula in B1: $A1<>$B1 (format bold). ...
2
votes
3answers
6k views

Is it possible to have a custom data table visible underneath a chart in MS Excel?

I have a column chart with a single series of data to be shown on the chart. However, I also have another column of data that corresponds to the one being visualized, but instead of charting it, I ...