**3**

votes

**3**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**6**answers

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

**1**answer

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

**1**answer

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

**3**answers

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

**7**answers

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

**4**answers

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

**3**answers

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

**3**answers

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

**1**answer

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

**1**answer

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

**4**answers

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

**2**answers

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

**2**answers

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

**2**answers

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

**2**answers

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

**3**answers

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

**5**answers

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

**1**answer

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

**2**answers

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

**4**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**3**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**3**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**3**answers

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 ...