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)

1
vote
0answers
11 views

How can I use Excel data bars to format cells with text values?

I'm creating a spreadsheet for project planning and have a column that lists estimated effort as follows: Unknown Very High High Medium Low Very Low None I like the visual cues provided by ...
0
votes
1answer
17 views

How to disable specific Excel 2010 add-ins at startup?

I want to disable specific add-ins from loading in Excel 2010 every time I open up a new workbook or instance. How do I achieve this? When I disable the specific add-ins by unchecking them in the ...
0
votes
2answers
4k views

How to make a dropdown list such that… (see details)

I want to plot the stock prices of certain companies VS the S&P500. I have all the price data downloaded in my excel sheet already. I want to create a line graph in Excel. One line is fixed and ...
0
votes
1answer
24 views

Word document loads incredibly slow

I have a word document (286kb) which takes almost 2 min to load. The document contains a large number of excel objects (as links from the same workbook). This is what I've tried: Remove the "old" ...
2
votes
2answers
21 views

Dynamic formulas based on other cell formula results

I have 10 years of monthly data for 300 plants. While Excel can do moving averages for various time periods I am looking to do a moving median value for this data set. I can obviously figure out the ...
0
votes
5answers
7k views

How do you add extra value to a cell that already has an existing number in it

I find this hard to explain, but I'm stocktaking beers, spirits, and liqueurs and I want to keep one column for my ullage count for each product. However, as I go through the days, I often come across ...
1
vote
2answers
23 views

Deleting segments of a text cell value in Excel

I have many lines that follow a similar suit to the below format in my Excel sheet: JFB001 D (2 Stem Flower Spray Orange Handcrafted Sugar Decorations) Web.jpg What do I have to do, in order to ...
0
votes
0answers
14 views

Excel: Do not open files in multiple instances

How do I open all excel files in the same instance/window by default (happens only when I open from the menu, but not from the windows explorer)? I have this option unchecked, but is still not ...
0
votes
3answers
112 views

How to dynamically populate a filter list with “first match” on a row, using excel 2007

The image is an example of what I am working with. I am trying to write a formula in my leftmost column, just under the listbox cell that you can see, which will find a string/value match in that ...
1
vote
0answers
13 views

Feeding Data from SQL Server to Excel Template with visual studio c++ program [on hold]

I started a projet of automatic reporting. To realize this i am using Microsft Visual Studio 2010 C++ (Ultimate edition) Right now the project is almost finish, but i am getting stuck at the last ...
3
votes
2answers
81 views

Showing a zero in front of a number in Excel

How do you get a zero to show up in front of a number if the numbers in the column are all different sizes, such as bank account numbers?
3
votes
1answer
259 views

How to sort time column by value instead of alphabetically

I'm creating a pivot table by connecting to an SSAS tabular model (Data -> From Other Sources -> From Analysis Services) . The model has a "time" column that I want to sort by. The default (database) ...
2
votes
3answers
16k views

Excel or PPT: How to have two pie charts, but one legend

I would like to design a slide that shows two pie charts of the same size side-by-side, but with a single legend that is centered on the page beneath both charts. I can easily create one of the pies ...
0
votes
0answers
22 views

Excel import/ format problems

After clearing out lots of junk and formatting to a legible layout in excel im having problems crossing one final hurdle. My data I've imported is really hard to work with as its in the following ...
1
vote
1answer
19 views

Two Columns Sum if

I have an "amount column" and a "Date Vouchered column". What I would like is a formula in a "summary cell" that will show the sum total of the amounts once a date vouchered has been placed next to ...
0
votes
2answers
29 views

Shortening an Excel formula if possible

I am unable to shorten an Excel formula I am using in an Excel database. I have googled it, but this appears to be the shortest way already from the first page on Google. ...
0
votes
1answer
24 views

Formula Required for Costs to date based on number of project days completed

I am trying to put together a template for project costs and am looking for a way to roll forward daily costs for each account code that avoids the need to change the formula on a daily basis. I have ...
2
votes
2answers
16 views

Excel: Auto-updating chart with changeable starting point

I have hooked up excel to an auto-updating database, but now I want to go a step further and make all essential report items automatic as well. And not only that - I want to make the way report looks ...
2
votes
1answer
34 views

How to convert data in Excel to percentages of total?

Is there a quick way to convert all cell values in a table to a percentage of a total listed in a separate column? I tried posting an image of my data as an example, but my reputation here isn't ...
0
votes
1answer
18 views

MS Excel : point a cell by concatenating text

In Microsoft Excel 2013, I want to point to a cell with this kind of formula : =Sheet1!["A"+E1] Where E1 contains the number of the line, for instance 25. So the purpose of the formula is to get ...
0
votes
1answer
13 views

excel: compare 3 column's numbers, decide on the largest number and place the column header in the 4th column

i want to compare the numbers of three columns, row by row, decide on the largest number and then place the title of the column of the largest number in a fourth column. the fourth column will end up ...
3
votes
2answers
2k views

Counting occurences of a character in an excel spreadsheet

Feel silly asking this question, but I need some help! I want to count how many * appear in a range of 5 cells. The cells will range from 0-7 * each. I was thinking of using the ...
-3
votes
1answer
18 views

Find and Replace in all excel files

I am no programmer. Is there a macro/vba/tool that allows me to find and replace in all opened excel files, at once? If not, an external tool that allow me to drag & drop files, because I have ...
0
votes
1answer
3k views

Tie stock quote value to cell in Excel 2011 Mac

I've been working on a mock stock portfolio in Excel, and I've been looking for ways to automatically update the data, eg. stock price and P/E ratio. I have tried using a web query to MSN Money, but ...
-1
votes
0answers
15 views

Source code vCard to MS Excel [on hold]

Do you have any source code to convert contacts from vCard to MS Excel? Any type of language such as Java, C# and C++. Thanks in advance
1
vote
2answers
2k views

Excel function to remove last two words from a cell

Using operators for simple arithmetic 4m 44s creating new database 3m 2s These are the two values in two Excel cells. I want to remove the last two words, that is, 4m 44s from every cell so ...
0
votes
0answers
11 views

Adding to ranges within the XIRR function

The following (left side) is the standard example from the help on the XIRR function. The 37.43% is the XIRR. Now, assume that the initial row values are from somewhere else and I want to somehow ...
1
vote
1answer
61 views

Setup Excel 2010 sheet that automatically popluates bi weekly dates

I'm trying to set it up where if I fill in a date it will automatically fill in the next column and on down. For example: A1= 10/06/14 B1= 10/19/14 I want A/B 2 to be 10/20/14 and 11/02/14. I found ...
0
votes
2answers
144 views

Create Excel pie chart from choice placement

I have a table like the following : Choice 1 Choice 2 Choice 3 Person A 3 2 1 Person B 1 2 3 ...
1
vote
2answers
29 views

Excel - Pick Top 3 Choices

I exported a Qualtrics survey which had users rank 6 options. I want to then take their top 3 options and list them in the row. Example: Choice A Choice B Choice C Choice D Choice E ...
2
votes
1answer
3k views

Split Text into Columns Function in Excel

I have an excel spreadsheet with rows of data as shown below. There is a code with the product name and then a number. QA32 Product One (Large) 23 AZ63 Product Two 96 PR65 Product Three 149 How do ...
1
vote
2answers
10k views

How can I create matrices of data in Excel?

I want to create a 4x4 matrix in Excel 2007 by taking three or more columns or conditions, for example: Column index Row index Name 1 2 x 2 3 y ...
-2
votes
1answer
25 views

Compare two rows and two columns and sum the 3rd row of the common value

I want to compare two rows and two columns and have to sum the third row of the common value. I have two sheets. In one, I have the work the students made, ordered by date. In the same sheet, I have ...
0
votes
1answer
40 views

Compare Excel Columns A & B and return C

I am a High School Principal and I need help figuring out how to use excel to create a class tracer for my students. A tracer is a spreadsheet that tells you what classroom a student is in during a ...
0
votes
1answer
15 views

Running Excel Line Graph?

I have a spreadsheet that automatically scores a questionnaire into 10 different subscales in the first worksheet. What I would like to be able to do is plot each data collection point on a line ...
0
votes
1answer
225 views

Hiding a column from a pivot table without removing it from the chart

I have a pivot table with two columns: number of users who visited a website (impressions) and number of users who registered on the site (regs). The rows are for dates. I want to visualize the ...
0
votes
1answer
17 views

LO Calc / Excel - Dropbox change another cell

I am creating a simple Point of Sale System for a store using an excel/libre office spreadsheet. The spreadsheet has a sheet called "Inventory" which has the following columns: Name Price This ...
0
votes
1answer
42 views

Lookup Values Based on Values in Other Cells

I have an inventory list that contains a manufacturer name and product category for each product. I want to look up the code for the manufacturer and the category code for the product and place the ...
1
vote
1answer
2k views

probable cause of excel files getting corrupted

how to find out the probable cause of corruption of excel files...here i m not saying of a single file...files are getting corrupted one after the other...can 1)using windows 8 with excel 2007 and ...
0
votes
1answer
2k views

Cells are not showing date as per Format in Excel 2010

In my excel sheet, I have selected date in Format Cells as 3/14/01 (which is M/DD/YY) Some cells in DATE column are showing date in correct format like 5/31/12 (M/DD/YY), while some are showing it as ...
2
votes
2answers
4k views

Efficient approach of selecting large amount of rows in an Excel file

I have an Excel file which have large amount of rows. Is there an efficient way to select say 100,000 rows other than dragging my mouse?
1
vote
2answers
31 views

How to highlight calendar cells based on given start and end date

For a while now, a coworker has been using a chart similar to the one shown below and wants to automate it (i've already added the days before/after due date). The chart is printed or worked on at ...
2
votes
1answer
31 views

Can I sort in excel but read the cell values from right to left?

I have an excel worksheet list of names and email addresses. Some of the email addresses, however, are cutoff on the right and have "...". For example: some email addresses are "test@test_user...". ...
1
vote
2answers
2k views

MS Excel: Can I link images using a relative path?

I am working on an MS Excel document that contains a lot of (around 200) images. They are currently saved within the document, so the file becomes huge and working gets very slow. Linking the ...
-1
votes
2answers
43 views

Use Excel VBA If value in column a is not in column b then add value to column c

Dim i As Variant 'For i = 1 To 5 For Each i In rngWatch Dim c As Variant c = rngWatch.Cells(i, 1).Value If i <> rngReconcile.Cells(i, 1).Value Then MsgBox i ...
0
votes
0answers
11 views

How can Excel add-ins be managed in an environment with multiple version of Office?

I have both Excel 2010 and 2013 installed. COM add-ins appear to be shared by all versions of Office. This is problematic because the whole point of having multiple version installed was to be able to ...
0
votes
1answer
47 views

How to make Excel treat days/dates as starting at 8 p.m. rather than 12 a.m

Our 24-hour day is 8PM to 7:59PM. That's considered 1 day, not 12AM to 11:59PM. For times after 8PM, I need the entries to be considered part of the next day. For example: Actual Date/Time ...
-3
votes
0answers
23 views

Password protect excel sheets [duplicate]

How Do I password protect excel spreadsheets? I am making dashboards for employees and I would like to assign each employee a certain password to access their worksheet.
4
votes
9answers
38k views

Copy Excel worksheet and maintain relative cell reference in formulas

Another copy problem in Excel: How can I copy a Worksheet from WorkbookA.xlsx into WorkbookB.xlsx without the copied Worksheet still referencing WorkbookA.xlsx e.g. the formula =B!23 becomes ...
3
votes
1answer
2k views

Excel: Why does double-clicking in a cell jump to a different cell?

Normally, when you double-click a cell, you enter in-cell editing mode, right? This works most of the time, but occasionally on random cells, a double-click instead moves the focus to a different cell ...