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)

3
votes
3answers
21k views

How do I bring back the ribbon in Office 2010?

The ribbon in Excel 2010 appears when I click on Home or Insert or one of the other tabs, but disappears again when I go back to editing my document. I'd like it to always be visible - how can I get ...
0
votes
0answers
7 views

Chart format corrupted or size is wrong when I copy from Excel 2013 to Word 2013

When I copy charts from Excel 2003 or Excel 2013 to Word 2013 the charts are corrupted: the fonts are too big so the titles and legend text is a mess. If I don't want the chart to update in Word ...
0
votes
0answers
6 views

Excel 2013 charts - how can I setup default chart with distinct line colours and fonts as in Excel 2003

The default line colours in Excel 2013 have poor contrast and are not easily distinguishable. I would lie to use the same chart colours, fonts, borders, symbols etc. as was in Excel 2003. How can I ...
2
votes
1answer
15 views

Unable to enter date into a cell

While working on a Excel for Mac, I suddenly cannot enter any date in ANY cell. Also the same thing with all my spreadsheets, unrelated to the one I was working on. I can type numbers and letters on ...
4
votes
6answers
27k views

Excel 2010: The file is corrupt and cannot be opened. — Is there an error log?

Is there an error log file that can provide details of the following Excel 2010 error? The file is corrupt and cannot be opened. In Excel 2003 some error messages would be displayed in the ...
-1
votes
1answer
11 views

Solve .CommandType=0 error in excel

I am trying to run this macro in Excel that pulls data from a website in a loop. There is one table I need to pull from each of about 50 webpages and the loop is there to run the function that pulls ...
2
votes
1answer
779 views

Exporting a subset of an Excel sheet as a (clean) HTML tab

I have an Excel sheet with several sheets and containing quite a few tables of information which are really intended to be published on a common wiki at my company. Previously, we used to use ...
1
vote
3answers
6k views

In an Excel chart, how do you craft X-axis labels with whole number intervals?

I have a sorted list of values that I'd like to see graphed in an Excel chart just to see the shape of the curve. Here is the initial chart: Looks ok, but the X-axis is ugly, so lets clean that ...
3
votes
7answers
25k views

How can I avoid Excel reformatting the scientific notation numbers I enter?

When I enter a number like 8230e12 into a Microsoft Excel 2000 cell, Excel changes the number I entered into 8230000000000000. (This is what I get when I press F2 to edit the cell's contents, not what ...
1
vote
4answers
137 views

Count the number of rows with equal values in two specified columns

I have two columns in MS Excel/LibreOffice Calc/Google Spreadsheets with numbers. I would like to count the number of rows which have identical values in both columns. In the following example: ...
13
votes
3answers
662 views

Excel does not honor the delimiter setting for reading or writing CSV files

When saving/opening CSV files in Excel, the default separator is a semicolon (;), as I need it to be a comma (,) I tried to change it by changing the Language and Regional settings following several ...
0
votes
3answers
4k views

Dates not recognized as dates in pivot table pulling directly from SQL Server

My pivot pulls from an external data source with a date column. Excel doesn't see this column as a date and the 'Format Cells' option panel doesn't change how the dates are displayed. The cell data is ...
0
votes
1answer
14 views

Create a spreadsheet that filters data and allows users to edit filtered data

I have a master datasheet with lots of information. I extract data from the master to a simple overview pertaining to only specific groups of people which takes this data and calculates other ...
0
votes
1answer
13 views

Excel saves absolute references to other sheets in my workbook. This causes problems when emailing the workbook to colleagues

I have this the following problem. I create a pivottable and set a reference to anther Sheet, for example: =Sheet1!A:C When I save, copy, cut and paste file to various locations, I end up with the ...
0
votes
4answers
380 views

What is the best way to manually edit and update data within a large table in MS SQL Server?

I have a table in MS SQL server which currently has around 800 records and 20 columns. I want to manually update and add to the information within this table on a frequent basis. Would exporting the ...
1
vote
2answers
9k views

Text values in a pivot table?

I have a table (in MySQL) with 3 columns: Location Category Supplier A Computers Company X A Printers Company Y B Computers Company X B ...
0
votes
2answers
3k views

Setting custom cell margins causes text to display as if centered

I'm using PowerPoint 2007 and have pasted in a table from Excel 2007. When I paste it in it automatically becomes a PowerPoint table, and looks fine. However, everything is quite squashed together, so ...
1
vote
2answers
27 views

Macro for cleaning all sheets in a workbook (VBA - Excel 2010)

I have a macro file with 5 sheets and I would like to add a VBA command button into the same file to clean all workbook contents with a single click. Does anyone know how to do it by using VBA on ...
0
votes
2answers
25 views

Excel: how to remove leading characters of a string with a function?

I have a text column in Excel full of hexademical values like this: 0000000000000c10 00000000000036f0 00000000000274da 00000000000379e0 Which function can help me strip the leading 0's up until the ...
0
votes
3answers
37 views

How do I get the fiscal year to start on a specific date each year in Excel?

I used the formula listed here to generate a fiscal year based on the current month. I have an odd requirement where she wants the fiscal year to start on 6/20. For example, any dates ranging from ...
4
votes
5answers
10k views

Excel 2010 PowerPivot: How to show items with no data?

In standard Excel pivot tables, there is an option for fields that allow you to force display of all items even if there are no results for your current selection. Here's the option: However, using ...
0
votes
1answer
2k views

Change numbering language of the Excel context by changing the Windows language

How could we change the numbering language of MS Excel 2010 by changing Windows language In version 2007 as I can remember we had an option in the advanced options tab that allowed us to do that with ...
1
vote
2answers
536 views

Filter and reorder columns in Excel

I've got a service (phplist, a newsletter manager) that exports a user list with several fields. At the end of it, each user has one or more lists to which he has subscribed. The problem is, that ...
8
votes
4answers
18k views

How to delete rows not in filter

I have a very large table in Excel (1000's of rows) and I filter it to only show 10 rows. I wonder if there is a way to delete the rows not shown (i.e. don't meet filter conditions)? This would ...
0
votes
1answer
273 views

Prompt to select excel spreadsheets in Access?

I have a Microsoft Access 2007 database that uses excel spreadsheets to track changes between the two. A new file is generated every week. I then do a compare against the two of them with some custom ...
6
votes
2answers
3k views

How to paste table from MS Excel to Wolfram Mathematica?

When I am pasting a region from MS Excel, which contains multiple numbers, to Mathematica, I am getting just a long plain sequence of digits, i.e. one integer number in Mathematica. How to have a ...
0
votes
1answer
13 views

Sum values in range if lower than a threshold otherwise sum the threshold value

As per the title, the best I could come up with is this, however it yields an error. My unremarkable knowledge of Excel prevents me from making further progress. This example formula should add all ...
-1
votes
1answer
28 views

Excel formula to collect data

I have this type of table in Excel: A | A1 B | B1 A | A3 A | A4 B | B3 What I need is to create a new table where the data would look like this: A | A1, A3, A4 B | B1, B3 Is ...
0
votes
1answer
111 views

Extracting Excel-published tables from a PDF document

I'd like to copy Tables 1,2, and 3 found at the bottom of this PDF file: http://www.cbo.gov/sites/default/files/cbofiles/attachments/03-13-Coverage%20Estimates.pdf into Excel. I've tried Copy+Paste ...
1
vote
1answer
3k views

Use Excel Table Column in ComboBox Input Range property

I asked this in StackOverflow and was redirected here. Apologies for redundancy. I have an Excel worksheet with a combo box on Sheet1 that is populated via its Input Range property from a Dynamic ...
1
vote
2answers
2k views

How do I group rows in a table by one column's value in Excel?

I have a table of data (5000+ rows) with two columns, ID and value. It may look like this: ID Value 01 02 01 03 01 17 02 05 03 06 03 28 What I want to do is find the average value for each ID. ...
2
votes
1answer
4k views

Two Way Link between excel workbooks

Is it possible in Excel to link two cells together (in different workbooks) so that a change in either is reflected in the other cell? The one-way linking whereby one cell is a view of the value in ...
0
votes
0answers
9 views

excel chart data labels failing to apply to all series

if I have a multiple series chart (pivot chart to be exact, can be line or bar) and I select (from the ribbon) layout data labels more data label options... then it automatically slaps ...
3
votes
1answer
3k views

Create progress bar or milestone type graphs in Excel 2007

I want to display project progress in Excel 2007. Is there a way to show a progress bar like graph filled for completed percentage and empty until end date for a milestone or the whole project? It ...
2
votes
3answers
6k views

Ctrl + Shift + Arrow stopped working

When I work with a big amount of data, I introduce formulas in Excel by using the shortcut: Ctrl+Shift+arrow. That shortcut allows me to select a whole set of data to the left, right, up or down. ...
0
votes
1answer
13 views

Can I filter out all rows corresponding to reference list in excel

I have a list of IDs that I would like to select in a excel sheet. I am used to using the filter function to search for 1 ID, but now I would like to filter out all the rows with that match the ID in ...
0
votes
2answers
19 views

Why is using this code to replace a formula giving me an error?

In Excel I use the following to clear cell E5 and replace it with the word name. Sheets("Invoice").Range("E5") = "Name" I can also use the following to replace G11 with the VLOOKUP code I have here ...
3
votes
2answers
3k views

Excel chart won't update, based on calculated cells

I have an Excel document (2007) with a chart (Clustered Column) that gets its Data Series from cells containing calculated values The calculated values never change directly, but only as a result of ...
0
votes
1answer
16 views

Excel formula - Return value from lower row

I'm looking for a way to search for a value in a single column and return a value in that same column two below it. Example: A1: Apples A2: Bananas A3: Oranges A4: Pears If I search for ...
1
vote
2answers
23 views

How do I format cells in one column based off cells in another column?

So I found some similar questions to this already answered here, but they don't go deep enough for what I want to do, and was hoping to find some more help. At a high level I want to format some ...
-1
votes
0answers
22 views

How to write % change formula in Microsoft Excel

I have a spreadsheet that I am building and I need to show staffing level changes. I currently have several cells with 0 counts that will be changing to 1, 2 or 3. How do I write the formula to show ...
4
votes
1answer
2k views

Linking Excel 2013 cell to Word 2013 table cell adds unwanted line breaks

I have a problem where I am trying to copy an excel cell that contains content using a formula, into a word document table cell and link them such that the formatting is used in word. What happens is ...
0
votes
2answers
20 views

Excel Conditional sum on same row

I have a rather basic Excel question, but my Excel skills suck. What I want is a conditional sum, but I'm not sure how to do it. Example: A B C D E ...
-1
votes
0answers
16 views

How do I export data from an excel file to xml with fixed width columns? [on hold]

I have an excel file with 7 columns. The data in this file in some cases is shorter than the required fixed widths needed (the export will be used to load into a table in our data warehouse via an ...
0
votes
3answers
27 views

Excel Averageifs with multiple conditions in one column

I am looking for some help for how to tidy the second formula below in bold. I am looking to calculate the average 'Pupil_Score' (this is also my first try with named ranges) based on race, I am ...
0
votes
0answers
17 views

Macro to update Date in Specific row in excel

I want macro to update current date in cells M10, M15, M18 and M19 Ex: If format of the date is 01-11-2014,then, macro should update cells M10,M15,M18:M19 with 1 ...
0
votes
1answer
23 views

Formatting of output .csv file generated by a software

I've been using a software which gives the output in .csv format automatically. In my .csv output file "." is used as a decimal separator. But in my colleagues' computer, with the same software the ...
0
votes
0answers
12 views

Find duplicates [on hold]

I have a 1 workbook 13863 records. And I want to search these record to 73 xls works. These 73 excel files contain 800,000 records. I want search text from 1 file to 73 files one by one. And match ...
0
votes
0answers
17 views

Scan only to excell cell

I am trying to set up a system where particular cells on various spreadsheets can only have data scanned into them. It will also be necessary to disable the ability to input data into that particular ...
0
votes
3answers
59 views

Need two excel windows side by side, on different monitors [duplicate]

Excel opens all workbooks in the same instance and as a result you cannot place them on different monitors (or side by side). You can extend one window across both screens and then split windows from ...