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)

4
votes
4answers
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 ...
8
votes
2answers
5k views

Move open Excel document to separate window

Related (but not the same): Open Excel files in new window If I've got an instance of Excel with multiple documents open in the same window. Is there a way to "tear off" one of the windows in ...
0
votes
0answers
13 views

How to add markers to all series in an excel line chart in one go?

I have about 15 series in my chart and do not wish to manually select and edit each one individually to give it a distinct marker Is there a way to do this for all lines in one go? I don't care if ...
41
votes
7answers
71k views

How do I join two worksheets in Excel as I would in SQL?

I have two worksheets in two different Excel files. They both contain a list of names and addresses. One is a master list that includes other fields, and the other is a list that only includes name ...
0
votes
2answers
21 views

In excel, how can I format a raw so that the second number is in parentheses?

I have a row with the following numbers: 4 (8) 3.8 (12) 5 (7) 4.6 (35) 5 (8) 4.4 (27) 4.8 (104) 4.3 (38) 4.3 (2,634) 4.4 (54) 4.5 (90) 4.8 (156) 4.6 (297) 4.5 (26) ...
-1
votes
0answers
9 views

Software to automate the download of a list of URLs to special paths

I have a similar question as Software to automate the download of a list of URLs However I have two columns, the first one contains list of URLs (images) to download and the second one (with the same ...
0
votes
1answer
290 views

Can I force MS Excel table column to use the specified pattern?

I need to develop a tool that enforces strict format of some table. The fields in this table follow specified patterns like number:number (11:20. 2:00), agreed date (11/20/2012 but not ...
0
votes
1answer
913 views

Formula to copy a specific character from one cell to another

I am using MS query to pull in data. I need to create a column that copies the first character in another column. For example: Cell A1 - E00633 Cell A2 - B00842 Cell B1 - I want this cell to ...
0
votes
0answers
6 views

MS Excel: save spreadsheet to tab-separated with UNIX end of lines and UTF-8?

I have a tab-separated text file with a table that has UNIX end-of-line characters (i.e. \n) and UTF-8 encoding. I can open it in MS Excel 2010 without major problems using Data → Import and selecting ...
0
votes
1answer
7 views

Open XLS file in protected mode manually

Is there a way to open the excel document in protected mode manually. I know one way to open it as a protected mode. Uploading to the web and Downloading it back let Excel think it's unsafe so that ...
0
votes
0answers
9 views

How do I separate a word document according to a list and email

I am using Office 2010. Our payslip comes in a word document and I usually print out and deliver to each staff. Each page has each employee's payslip. However, I want a macro or VB script that can ...
4
votes
2answers
22k views

Quick replace #N/A by 0 when vlookup

I use vlookup a lot in excel. The problem is with #N/A value when the seek value is not found. In that case, we often replace it by 0 using if(isna(vlookup(what,range,column,false));0; ...
4
votes
1answer
18k views

Excel 2011 Mac auto-recover file lost

Yesterday morning my colleagues Excel 2011 (on Mac OSX 10.8) crashed. He reopened Excel and was asked if he wanted to recover the previous document. Yes, he said and then got a document named ...
0
votes
0answers
7 views

Displaying data correctly in a chart Word 2013

On the horizontal axis on this graph, I only have data for 1, 5, and 25. I want the graph to display as if i had 25 values and have the data show it respectively. For example, instead of reading 1 ...
0
votes
2answers
16 views

Data modelling, calculation and visualization tools?

I often need to make decisions based on various kinds of data and their calculation results/visualizations respectively. For simple, tabular data I usually make Excel spreadsheets, however most of the ...
0
votes
0answers
15 views

How to know everything about Office Word and Excell? [on hold]

I'm looking for an on-line video training (free or paid) where I can learn everything about MS Word and MS Excel and how to use them professionally. Could you tell me about excellent website or ...
0
votes
0answers
11 views

Excel 2010 short cut keys - Ctrl + Left or Right Arrow Key - are not working anymore

My Excel 2010 short cut keys - Ctrl + Left or Right Arrow Key - are not working anymore. However, the short cut keys - Ctrl + up or down arrow keys are working. I will appreciate it if the learned ...
0
votes
1answer
21 views

Simples??? How to set all fields in Excel spreadsheet to convert from lower-case to UPPER-CASE

I know this must sound like I have no idea what I'm doing. Older versions of Excel had a page/sheet function which could be set to ensure all fields in an Excel spreadsheet would automatically convert ...
0
votes
2answers
6k views

Comparing columns in two different excel sheets and if they match copying third column

I have limited working knowledge of Excel and I hope someone will be able to help me with my problem. I have two different work sheets (say F1 and F2) with last name in Column A, first name in Column ...
0
votes
0answers
14 views

XL 2003 crashing on ANY VBA code in ANY class module - code module OK

Any sub in ANY class module including ThisWorkbook, an added class module, or even the worksheet class modules all crash IMMEDIATELY upon launch of XL 2003 or upon invocation via control or button. ...
21
votes
3answers
49k views

Is it possible to sum an entire column without setting explicit cell boundaries in Excel?

I'd like to sum all the values in a column starting from a certain minimum value, but I don't want to give an upper bound because any value in the table will be appropriate for summing (minus the ...
0
votes
0answers
7 views

Matching Dr and Negative amount in particular column [on hold]

I have huge number of amount in the excel column. Many of the items are netting to zero. These netting to zero items I need to match manually by checking each items. Is there any macro codes where I ...
0
votes
1answer
19 views

how to create persistent random numbers &letters in excel?

Below is link for example sheets https://docs.google.com/spreadsheets/d/1D-D29csRGAAZl_h7fyMwLJ6am0FpZAtCZ5r0XlmQVqo/edit?usp=sharing. This is a live spreadsheet, which can't be pasted in this ...
0
votes
0answers
12 views

Google Docs Formula [migrated]

I have a problem creating a formula for my sheets. I want google docs to put either "yes" or "No" in a specific cell depending on the values in other cell. in other words I want it to put "Yes" when ...
0
votes
1answer
12 views

Excel 2010 - Averaging columns data by different columns

My data includes several repeated measures (~4-5) for each participant and i want to be able to average all specific measures for each participant. for example, in the screenshot attached, i want to ...
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
14 views

Merge two files with fuzzy / inexact key column

I have two spreadsheets with different dimensions. They share a common column, but not all the names are 100% similar. Specifically, I'm merging two data files from counties around the US, one has ...
0
votes
2answers
17 views

Fatal error in excel “Errors where detected while saving filename”

I have some of excel files and I got an error while saving that says "Errors where detected while saving file name. Microsoft Excel may be able to save the file by removing or repairing some features. ...
2
votes
2answers
26 views

Return a value given that a number is within a certain range

I'm looking for a little help on my scheduled withdrawals problem. I currently solve this with nested IF functions, but I'm getting more and more ranges and that leads to more and more nested IF ...
0
votes
2answers
30 views

If there are values in specific cells, I need them to subtract from one main cell

I need to find an equation so if there are any values from B2-R2 it will subtract 1 from W2 which needs to start at a value of 17. For example, if the value of D2 is 6 it will subtract 1 from W2. ...
1
vote
3answers
43 views

Checking whether a label exists between two other labels in a column

I have a column (call it A) in Excel lists off different items and their properties. Every item has the word "Type" associated with it and so there is a cell with that label in column A so that in ...
0
votes
2answers
27 views

Excel IF Formula Not Working Correctly

I have an Excel IF formula that is not working correctly and I cannot figure out why. Here is the formula: =IF(D17<=200%, C17*130%, IF(D17<=150%, C17*120%, C17*140%)) When D17 > 200% it is ...
0
votes
1answer
16 views

Dynamic chart updates only when I let go of the scroll bar

I have done the usual scroll-bar to update the chart using dynamic name range. Now the problem is the chart only updates when I release the scroll bar. It does not update if I keep it pressed. I can ...
0
votes
1answer
2k views

Automatically Updating a cell in Excel from another sheet's data, based on another cell's value

So, I have setup a drop down menu with a list of names in A1. What I want to happen, is have the Data in F34 change based on what A1 is reading. I want to have F34 update with data from another sheet. ...
0
votes
1answer
25 views

how to make a Copy formula, Value from A3 to B3 if z3 = csl

Is it possible to have a formula that can copy text value from A3 drop down list of cars, paste the text Value into B3, once i put CSl into Z3. then i can delete A3 but still have the text Value in ...
0
votes
3answers
22 views

How to record in adjacent cell what my drop down selection was, as a Hard Record formula? plz

is there a excel function coding which can record in an adjacent cell what my drop down selection was From cell A3, into Cell B3, but to keep this even if i remove the drop down selection at a later ...
3
votes
2answers
12k views

Printers not visible in Microsoft Excel

When in MS Word or PowerPoint, when I go to File → Print, I can see all the printers. But when I do the same thing in Excel, no printers are installed. Yet I can use the Ctrl-P shortcut keys and ...
0
votes
1answer
45 views

Copy Active Cell Comment in Excel into a new word file

i do not know much about Macros, is it possible someone could help me out. I have a simple excel file with names of Clients that have a lot of comments on each name. is there a fast way other than ...
0
votes
4answers
98 views

Combining all combinations of data from three columns in excel

I have a few columns of data that I would like to combine, and get each unique combination. Concatenating across a row or set list is easy enough, but I would rather not have to enter each possible ...
1
vote
2answers
11k 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 ...
0
votes
0answers
89 views

Excel file marked corrupt because of alternate data stream

This Excel file, promoImportTemplate.xls, is a perfectly valid Excel file when opened from its source. When downloaded from my IIS server at the URL above, using either curl, Firefox, Chrome, or IE, ...
32
votes
10answers
58k views

Easiest way to open CSV with commas in Excel

CSV files are automatically associated with Excel but when I open them, all the rows are basically in the first column, like this: It's probably because when Excel thinks "comma-separated values", ...
1
vote
1answer
29 views

Align unique values in two columns in Excel

COL 1 COL 2 A E B G C A G A D C E F D F F F I want it to look like: COL 1 COL 2 A A BLANK A B BLANK C C D BLANK D ...
1
vote
3answers
2k views

CTRL+D in Excel 2010 fills values and formatting, but I want it to only fill values/formulas

When you press CTRL+D in Excel 2007 or 2010 (and probably older versions), it makes an exact copy of the cell above it (modifying cell references, of course). In doing so, it copies everything else ...
0
votes
2answers
76 views

Divide information

I have an Excel file with several rows (about 1k). Each row describe some action of one user and (my bad) for differents actions there are differents rows. Something like this action ...
2
votes
1answer
28 views

IF and then condtional format

In Column C, I Want to rename the Column A Name in order of Date Of Birth, but only if a duplicate is found. Otherwise, the name in Column C should be the same as Column A. For example, there are ...
0
votes
0answers
34 views

Change regional number format for powerpoint, but not excel

My clients (and me) are Germany-based, as such I need to use the German number format 1.000.000,00 for all client-facing documents, usually created in Powerpoint 2007. In Excel however, I use the ...
0
votes
1answer
28 views

Calculate the difference in hours from now and next workday's 9am

How do I calculate the difference in hours from now and the next workday's 9am? If NOW() is Thursday 6pm and the next workday is Friday, the function would then return 15. If NOW() is Friday 5pm and ...
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
votes
1answer
28 views

How can I use 2 different sizes of the same font in one cell?

For instance, I want to list a person's name in one size font, and his graduation year ('14) in a smaller font.