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)

0
votes
0answers
3 views

Pivot Table Does Not Refresh Source

Typically, when selecting a data source for a pivot table in Excel 2013, it is possible to refresh the table by selecting "refresh table" or "refresh all". This triggers an update in the Pivot Table ...
0
votes
0answers
33 views

Finding dates on Excel sheets

I have an Excel workbook with around 200 worksheets. Column A on each sheet is a date column. I need some VBA which will give the names of all sheets that have a stipulated date in column A. e.g. I ...
0
votes
2answers
36 views

Excel formula to compare single value in one cell with multiple values in other cell

I have a value in Column A, which I want to compare with multiple values of corresponding cell in column B, and depending on that value, put the answer in column C. For example, using the table ...
0
votes
1answer
15 views

Forcing Date format

I have the the following date format 02/02/02 and I need this format to save to a csv file to be uploaded. How do I program excel to not force the date back to 02/02/2002 ? Thanks in advance.
1
vote
0answers
80 views

excel: how to filter for a specific ID given time constraints on a text field

I have an excel sheet that has a three fields: USER_ID | DATE_CREATED | TAGS Tags applied to the items in the sheet vary quite a bit, and are set up like |tag1 tag2 tag3...| within the field. I ...
0
votes
1answer
123 views

Updating multiple links in multiple workbooks

I have 3 workbooks. Call them A,B and C. B receives data from C via a link A receives data from B, including data B received from C I want to update all the links when I open A I get that a ...
1
vote
0answers
58 views

Copying Tables from a Website

I have difficulty making an Excel-readable file from a table on a Website. The problems very specific to my question are: I have to use IE 7 to access the site. Excel is installed in another ...
0
votes
0answers
10 views

How to Run macro in excel instance “2” from excel instance “1”

Lets say i have already opened Workbook 1 in Excel instance 1 and Workbook 2 in excel instance 2 And i have macro called "AAA" in instance 1 and "ASD" in instance 2 i want to call "ASD" in instance 2 ...
2
votes
3answers
4k views

Excel 2007 - delete worksheet shortcut

I know the shortcut to add a new worksheet (SHIFT+F11). But please tell me the shortcut to delete a worksheet. I spend a huge amount of time on selecting worksheet through mouse and deleting them. ...
0
votes
1answer
3k views

How to customize Paste Value Excel Short Cut

I was reading in this other post about how to set up a macro to past values in Excel. I understand how to create he macro but I would like to set the keyboard shortcut to Ctrl d but excel pops up an ...
1
vote
1answer
5k views

How can I make filtering rows on an Excel spreadsheet easy?

I have an Excel 2010 spreadsheet that looks like this: Department Location Staff Accounting SF 10 IT NYC 20 Finance NYC 15 Design ...
0
votes
2answers
1k views

How do I create a chart in Excel with dynamic series based on the data content?

How would I define a chart in Excel (2010) that shows a time series graph containing various series based on the data content itself? For example, here is a data set: Date Series A Values ...
2
votes
1answer
3k views

Bat file to open excel with parameters - spaces

I would like to run Excel, open a specific file in it and pass arguments to this file. My call is "C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE" ...
1
vote
1answer
697 views

Have Excel's Correlation Function Respect Filtering

I've got a cell that's using the CORREL function to return the correlation of two rows of data in my spreadsheet. The issue is that I'd like this to update based on the filter that I have applied. ...
0
votes
1answer
17 views

Excel macro to save workbook on another session of excel

Im trying to make a macro in one session of excel that saves a particular workbook in another session of excel. Lets say i have Workbook1 and Workbook2 and i have opened them in different excel ...
0
votes
1answer
31 views

Populate default value to a cell based on another cell content

We use a spreadsheet as our time cards. The template is stored in a server with links to it on the individual's desktops. I am trying to figure out VB code that would help in achieving the flliwing: ...
0
votes
1answer
2k views

How to troubleshoot “Automatic update of links has been disabled”

When I open some spreadsheets I get the error "Security Warning Automatic update of links has been disabled". I can only imagine this might be in reference to formulas or other content in the workbook ...
3
votes
1answer
2k 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 ...
1
vote
2answers
2k views

Get Excel to base tick marks on 0 instead of axis ends (with fixed maximum or minimum)

In other words, I want Excel to anchor the tick marks at 0. I am trying to get an axis that goes from -35 to 35, but with the ticks on multiples of 10: 30, 20, 10, 0, -10, -20, -30 I have set set ...
7
votes
1answer
27k views

Create a pie chart from distinct values in one column by grouping data in Excel

I have an Excel document containing information from a survey. I want to create a pie chart over location (countries). How can I make Excel group all the distinct values together and then display ...
0
votes
7answers
14k views

Excel automatic axis scale completely inappropriate for data

How can I make Excel use the correct scale on its graph axis? For example, I have a graph which looks like the following: The x-axis has the wrong scale - it should range from about $3000 to ...
0
votes
1answer
888 views

Product sales chart in Excel, from data in Access

I have a table in an Excel 2007 worksheet containing details of orders (note: I have manually changed the details to be fake on everything) I want to count the number of products ordered for a ...
1
vote
1answer
1k views

Box and whisker graph in Excel

Is there a way to draw a Box and Whisker graph in Excel?
1
vote
2answers
2k views

Distribution of values as a graph in excel

I have a set of 1-D data (0,0,0,1,2,1,1,5,6,1,1,100,1,etc) and I'd like to generate a graph from it that shows the number of values in a set of ranges. I.e 0 - 3 1-7 - 8 8-30 - 0 30+ - 1 The data ...
0
votes
1answer
13 views

How to move the y axis to the left in excel , scatter plot with x-axis log scale?

I have my scatter plot with x-axis log scale like below: I want the position of y-axis moved to the left. How can I do this?
-2
votes
1answer
36 views

Randomize Huge List - Windows 7

i've been searching for a solution for this but i couldn't find it anywhere. I have a large list, more than 2 million entries. I need to randomize it. I can randomize lists in excel but excel ...
0
votes
3answers
37 views

Average Difference and Direction Between Values in Excel with Blanks

I have a sheet that looks something like this: Sheet 1 1 2 3 4 5 6 7 8 9 10 11 1 6 2 3 5 3 ...
-1
votes
1answer
21 views

How can I populate other columns after user selects choice in drop-down?

I have a spreadsheet that is essentially going to be a form for our user to print out and hand to the necessary individuals. What the user needs to be able to do is select a customer number from a ...
3
votes
5answers
50k views

Excel chart: How to reverse the X axis of time series data

In Excel 2003, I have a time series from a financial report that goes something like this: 2007 2006 2005 Amount 300 200 100 I want to create a graph of the time series that looks ...
1
vote
1answer
52 views

Excel Pivot Table - Average per day

I have a table of data Date Item Quantity Operator 01/01/2014 Item1 3 John 02/01/2014 Item1 7 Bob 02/01/2014 Item2 4 John 03/01/2014 Item1 2 ...
0
votes
1answer
18 views

Comparing two strings in excel, add value for common variables

I'm comparing two large datasets containing strings in excel. Column A contains the numbers 1-1,000,000. Column B contains 1,000,000 strings, neatly organized in the desired order. Column C contains ...
27
votes
7answers
66k views

How do you force excel to quote all columns of a CSV file?

Excel only places quotes around certain fields, how do I force excel to save a CSV file with quotes around every column?
0
votes
0answers
16 views

Histogram - adding vertical line (x-value) - Excel

I have created a histogram from a list of data: -0.0892 8 -0.0711 16 -0.0529 19 -0.0348 13 -0.0166 5 0.0015 12 0.0197 5 0.0378 5 0.0560 3 0.0741 4 0.0923 5 0.1104 1 I would like to add a ...
0
votes
2answers
32 views

SUM From Sheet 1 Columns to Sheet 2 Rows

Tried searching for a while, didn't see what I was looking for. On Sheet1, I have approximately 100 columns, each representing an item. Each row is populated by a quantity of that item. As you can ...
0
votes
1answer
3k views

Is there a way to get a shared spreadsheet to update without closing and reopening?

Using Excel 2010, I have a spreadsheet that is used by 3 different people at any one time. But if one person has the spreadsheet open on there PC the other people can only view it as read only. I ...
-2
votes
1answer
22 views

How to assign a unique number per group of entries in a column?

I have a list of part numbers in Column A and a location in Column S. I need to assign a value of 1 for all part numbers that are the same (A3-A16), then change to a value of 2 when the part number ...
0
votes
0answers
17 views

Is it possible to insert multiple objects at once in Excel 2007?

My co-worker keeps a spreadsheet of candidate data, which includes the resume of each candidate inserted as an object. How can we insert multiple objects (resumes) at one time, instead of going ...
1
vote
3answers
41 views

IF formula returns wrong value

https://www.dropbox.com/s/v6nd2z4icftmnvf/example1.xlsx We have Excel 2007 (German) and vista ultimate. I am trying Excel by building a roster but have run into a problem with the following formula. ...
0
votes
1answer
17 views

Excel shows different files in same window

In Firefox, I downloaded an Excel spreadsheet and it displayed a dialog box asking what to do with it, so I selected "Open in Excel". Then I downloaded another Excel spreadsheet and opened that one ...
1
vote
5answers
11k views

Microsoft Excel 2007 - Cannot Fit All Text Into Cell

Is it possible to fit a large amount of text within a cell in Excel 2007? I have 1,890 words - consisting of 10,110 characters (without spaces) - that I need to put into a single cell in Excel. I ...
0
votes
3answers
6k views

Why isn't Excel updating formulas automatically?

Excel is not working correctly for me. When I change the input of a formula, the output is not automatically updated. Could this be due to a virus? How do I get Excel to update formulas automatically ...
2
votes
7answers
15k views

Stop excel from converting copy-pasted number/text values to date

I'm copy-pasting some data from html table into excel. But excel automatically converts some text or number values to date! When I change the format, the number is perversed, the number is something ...
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
1answer
14 views

Comment in fixed line in Excel gets truncated when I scroll down

I have an Excel sheet with a fixed header (first row is fixed) and some of the cells in this header contain comments. When I don't scroll down and hover over the cell, the comment is fully visible, ...
0
votes
1answer
15 views

I want to create a format in Excel to trigger a colour code?

Currently I have a drop down list on certain cells, connected to a list of statuses. 'Complete' which marks as green, 'Pending' which marks as orange, 'Outstanding' which marks as Red. I want each ...
0
votes
1answer
18 views

Nvidia How to display particular workbook of Excel file on TV and no matter what i do on the computer the TV displays the workbook

Basically i have a computer and a TV.I want to display particular workbook of excel file on the TV ( monitor 2 ) and when i work on my computer monitor ( Monitor 1 ) nothing happens on Monitor 2.I ...
1
vote
1answer
4k views

Plot scatter graph in Excel graph with 3 variables in 2D

3 Columns of Data: Date (from 1st till 31st) Variable 1 variable 2 I want to make a simple graph where Variable 1 range is X axis and Variable 2 range is Y axis, I plot the date on the graph ...
0
votes
1answer
13 views

Can I use excel to read barcodes and take me to a specific cell?

I work for a community group that holds an annual fund raiser for charity over a weekend. I am an excel user and am wanting to set it up so that I can assign a barcode on a card to a specific person. ...
0
votes
1answer
24 views

Cell in a cell excel 2013

Is it possible to insert a cell in a cell? I need to divide a cell in half horizontally. I don't want to have to insert another row as I would like it to be horizontal. Can this be done?
4
votes
3answers
4k views

Making Excel formulas only evaluate once

Is there any way to embed the result of a formula evaluation in a cell, such that the evaluation only happens once? For example: If I put =TODAY() formula in a cell today, if I open the spreadsheet ...