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
6 views

Excel- How to use lookup formulas to look up on part of the content of a cell

I created a table with a searchable drop down list that gives you all the prerequisites for the class you choose from the drop down list. I chained it so that it gives you up to five prerequisites ...
17
votes
8answers
1k views

How do I insert a new row in Excel via the keyboard?

Right clicking on a row and clicking insert is fairly time consuming. I'd rather not have to take my hands off the keyboard. How can I insert a new row above my current row using only the keyboard? ...
6
votes
9answers
13k views

Why is Excel 2010/2013 taking 10 seconds open any file?

I have a fast Windows 7 PC with two SSDs and 16GB of RAM, so I'm used to programs loading very fast. But recently, for no reason I can figure out, Excel has started taking way too long to open Excel ...
0
votes
0answers
5 views

cumulative profit of each client in table no 2 from data of table 1

I want cumulative profit of each client in table no 2 from data of table 1 formula i use is ...
0
votes
1answer
27 views

Duration calculation in seconds

This is what my data looks like. How do I calculate the duration, in seconds. I've tried some an answer but it looks complicated - =INT(E226-D226)&" days "&TEXT(MOD(E226-D226,1),"hh "" hours ...
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
0answers
8 views

Where to put the Change Event Code

CHANGE EVENT: I have 12 sheets in a workbook. Do you have to put the Change Event in the 12 sheet, if not, where I must put the code for this event. Thank you Jane
0
votes
0answers
9 views

Formula to search two columns of a database and return value from different cell in the matching row

I am designing a spreadsheet for scheduling appointments. On one sheet I have all the data but the dates and times are not in chronological order. I am having trouble writing a formula that will ...
1
vote
3answers
40 views

Excel - stipulate an average for random number function

I am wondering if anyone knows if there is a way to use the RANDBETWEEN function to generate a series of random numbers in Excel but also make those random numbers come out to equal a specified ...
0
votes
0answers
29 views

Excel, order column elements by row ID [on hold]

need your help for a sec > so the problem is in the following, I have a column of numbers: column A row ---------- 1 1.11 2 2.123 3 2.222 4 ... 5 ... 6 ... and what I want to ...
0
votes
2answers
23 views

import text file into excel

I have a text file that has the following text content: County Name: test county Athlete ID Count: 280 Activity Count: 574 Average Distance: 35255 ...
0
votes
1answer
14 views

Filter data for different data serie to display in XY-Plot

I want to paste the date (see image) in my excel sheet a get a XY-Plot with 4 data series, one for each Method Until now I filter them by Method and copy each result, so I get 4 tables for 4 data ...
5
votes
4answers
13k views

Check if Excel cell text is numeric using formula only

I have to find out if my cells text is a numeric value and wanted to use an elegant non VBA method that doesn't impede on its current state or value. What I've found is that the ISNUMBER() function ...
-1
votes
1answer
17 views

Merge Two Dynamic Tables in One Table [on hold]

I have try to merge/combine two tables but I have always fail. How can I merge/combine two dynamic tables in one table
0
votes
0answers
18 views

Excel timeline summing overlapping values

I have an excel spreadsheet with the following values: Start End Value 1/12/15 5/12/15 6 3/10/15 4/8/15 3 I want a timeline that starts at the earliest date out of the entire ...
0
votes
1answer
30 views

Excel combination 6 [on hold]

Good morning, I am trying to do in excel all possible combination of 1 to 6 without repeating. 6! How can I list the 720 possibilities Thank you, examples 123456 132456 654321
0
votes
0answers
14 views

Excel cell value showing when printed despite font colour and fill colour being exactly the same

In Excel, if I set the fill colour and font colour of a cell to be Gray (RGB 217-217-217) and then type "TEST" in the cell, I cannot see any text but when I print it (I made the cell significantly ...
0
votes
1answer
23 views

Searching for a value across 2 tables in Excel 2010, returning yes or no

I have one workbook with 3 separate worksheets Sheet 1 contains 2 columns. Column A has a range of unique alphanumeric identifiers. Column B has a range of non-unique numbers. A B ...
0
votes
0answers
11 views

How to open an excel and prevent the automatice convert the numeric fields larger than 15char

We work with a software that we must export data from and use this information for multiple functions, one is the data is reopened in Excel. Excel converts the numeric fields greater than 15 char to ...
-1
votes
1answer
12 views

Creating a button linked to tex and not cell [on hold]

I want to create a button in Excel that is linked only to a word, so that if lines are removed, the button is still linked to the text and not the cell. How can this be done?
1
vote
2answers
27 views

Column of Text in Excel

I have a column in my spreadsheet in which each cell is either a YES or a NO. I'd like to produce a NO result even if there is only one NO in the column. I tried =IF(C4+"NO","NO","YES"). This ...
0
votes
0answers
8 views

Information into multiple sheets

I run a drag racing promotion company and need some help in creating a workbook for shows. I want to put a master list of names in sheet 1, sheet 2 through 20 will be the different classes. Is there ...
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 ...
-1
votes
0answers
14 views

Formula copy display only formula [on hold]

Suddently I cannot copy formula from one cell to another it just expose the formula. this formula is correct, it work in original cell. the destination cell is setup on automatic, If I type manually ...
17
votes
10answers
52k views

Why does Excel treat long numeric strings as scientific notation even after changing cell format to text

I'm trying to process some data in Excel. The data includes numeric account numbers and other long numeric strings (like cell phone MEIDs). I am not doing math operations on these strings, so I want ...
0
votes
1answer
15 views

I would like to add specific text to get total count

I am trying to create a holiday calendar for team. We have defined terms like H= Holiday B = Business trip S= Sick I would like to count total of H , S &B for calendar year. How can I do ...
0
votes
1answer
35 views

How do I generate random numbers between a range in cells? [duplicate]

I'm wanting to create a button that generates a string of 10 random numbers into cells, and pulls the range for these random numbers from, for instance, in B1 and B2. Basically, I'm looking to use the ...
0
votes
0answers
12 views

Auto populate data from one worksheet to another [on hold]

I have an excel worksheet with a nominal of employees I would like to be able to filter departments to a separate worksheet I have been trying all day but to no avail.
0
votes
1answer
22 views

Frequency formula in Excel 2010

I am just trying to figure a way to get the frequency of occurrence of a number within a large array, not the freq of the number in the array belonging to a range. Eg, how many times does the number ...
0
votes
6answers
19k views

My excel spreadsheet won't sort/alphabetize properly

I have a spreadsheet with multiple columns and over 4000 rows. I need to sort, then alphabetize my report and everytime I do, there are 43 rows that do not sort with the rest of the report; they go ...
-1
votes
1answer
17 views

Excel macro to group rows based on a cell value

I have a hierarchical list of items in an Excel worksheet and want to create a macro to group each row based on a cell value that gives the level of indention. The data looks like this: Index Level ...
1
vote
1answer
2k views

Query parameters in an external connection to sql server

I want to do exactly this:http://dailydoseofexcel.com/archives/2004/12/13/parameters-in-excel-external-data-queries/ but I want to do it in Excel 2010 and also I am querying SQL Server instead of MS ...
0
votes
1answer
22 views

Comparison of two files in excel [on hold]

I want to compare two files including ticket number and amount.How to compare? I can also send you sample files format.The ticket number and amount is same in file 1 and also in file 2.But,they are ...
0
votes
0answers
17 views

What do I need to see if there is matching formula between two cells in Excel?

I'm awful at excel and I'm trying to figure out what I need to do to see if there is matching formula between two cells. As an example D6 has a number 55, P6 has something like mon200055. Is there a ...
1
vote
1answer
12 views

Excel 2010 SUMPRODUCT FUNCTION - unable to do date comparison

I run a small share investment club and of course use Excel to keep track of our activities. On one worksheet (Asset worksheet) I am trying (for each company we hold) to add up the dividends received ...
5
votes
3answers
4k views

Colour coding blocks of rows using conditional formatting

My macros have been taken away; never to be used again! I'm gutted. I now need to use formatting to help me highlight the different users and their data. Doing this manually is a chore. Using Excel ...
0
votes
0answers
9 views

Excel automatically applying styles to new data

I'm having a problem with Excel 2013. I have a spreadsheet filled with names and related information for applicants. When I contact the applicants, I highlight the cells (using the fill tool) so I ...
0
votes
0answers
8 views

How to make Excel scatter plot axis show months rather than days?

I have an Excel scatter graph that is separating months into 20-day segments instead of the entire days of each month. How do I fix this? I want to have it reflect the days of the month by simply ...
31
votes
5answers
119k views

How to remove the print preview lines in Excel 2010?

Somehow or other I have managed to switch on the print margin lines in Excel 2010. I cannot seem to turn them off. I went to Page Layout->Page Setup->Print Area->Clear Print Area but the lines remain ...
-1
votes
0answers
8 views

Is there a short cut key to put MS Outlook for text to column option [on hold]

Hi team i am using windows 7 operating system and king office 2013 software. I have a doubt what is the shortcut key for text to columns in king office 2013 spreadsheets. Help me team
-1
votes
0answers
8 views

MacBook Air, OS X 10.9.3 - Excel for Mac 2011 [on hold]

I am trying to save a spreadsheet that was built in a different version of excel and the conditioning formatting formulas are too complicated for Excel for Mac 2011. Any ideas?
0
votes
0answers
15 views

Excel locked columns

-Is is possible to lock a column, for example column F, and then set it so if i scroll from column E, all other columns will appear before the F column. I am trying to set F up at the end of a spread ...
0
votes
0answers
25 views

Selecting random entries from lists in Excel with VBA

In Column A, I have n number of names. In Column B, I have n number of Order numbers for each name. In one cell I will be inputting the number of orders I want to pick randomly. Once I input the ...
0
votes
2answers
42 views

How to get SUM and COUNT in the range

I have dates in one column, names in the next column and counts in other column. I want the formula to count the individuals as per the date. 1. For example, on 11/1/2014, I want Sum of Kiran's ...
0
votes
1answer
26 views

How to constant 0 in the range when the number is not inputed

In cell A1 I have number entered as 10. If I delete the number 10 from the cell A1 I want 0 to be constant in the cell A1 automatically instead of manual entry of 0?
0
votes
1answer
76 views

Track username and date when the sheet open

I'm using VBA to display a welcome message with the username. Additionally I want to keep track of the username (taken from environment variables), date and time in one of the sheets. For example: ...
0
votes
1answer
23 views

In excel shared workbook can you insert data and not replace on conflict?

I have 2 users that asked for a shared excel workbook a while back. Now after the holidays they complain that the workbook creates conflicts and that this issue never happened before. The file just ...
3
votes
1answer
20 views

change layout in excel sheet

I have excel sheet (plz visit link below,unable to post img) http://postimg.org/image/q4nf8j7qd/ which contain first name,last name,city,address, etc of many person.. A | B | ...
2
votes
1answer
25 views

Excel averageifs multiple criteria on one range

I know how I can use average(if(... etc using an array, however I'm stuck on how to include other criteria in this This is what I've got so far: ...
3
votes
1answer
6k views

How can I move linked Word/Excel files without breaking the links under Windows 7?

I currently operate under Windows XP and have multiple links between my Word and Excel files. I have to upgrade to Windows 7. When the .doc and .xls files are converted to .docm and .xlsm, ...