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
1answer
13 views

Run a Mail Merge using a Database from Excel

I have an Excel database that lists all our employees and the training courses they have completed. Each course is listed on a separate line with the employee name. I would like to run a mail merge ...
0
votes
0answers
11 views

How to filter common values of two columns with advanced filter?

I have one column containing some common values that are in another column. I want to filter values from one column that are present in other column but without using VLOOKUP. How can i do it using ...
0
votes
3answers
9k 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 ...
2
votes
4answers
12k views

Cell colors change when copy&paste in Excel 2010

We have a 3rd party tool that creates an Excel file (xls, 97/2003 format) and formats some cells in different colours. When I copy a range of cells into a newly created file (xlsx, 2007/2010 format) ...
1
vote
2answers
2k views

Cyrillic export from Excel to CSV

I have an application where I upload some content in CSV format, however the main document where I have my data is an Excel document. I use Save As » CSV in order to make a CSV file, but it is not ...
0
votes
0answers
10 views

How do I sum the last 4 cells in a column that have a value greater than 0 & contain only numbers in excel?

I have created a spreadsheet for working out the pay of our employees. The data starts in Row 14. Col A contains that week's pay date eg. 24/3/15 etc. Col B has the total hours the employee has worked ...
0
votes
0answers
7 views

Different colored columns in excel

I have data such as this: 1 | 2 | Y 2 | 4 | N 3 | 3 | N 4 | 2 | Y ... I need a bar graph that will display column 1 as the x-axis labels with column 2 as the y values. The color of each bar will be ...
1
vote
2answers
36 views

Microsoft Excel - comparing values of multiple columns against values of multiple other columns

I have a spreadsheet containing names. I have 5 columns of unique names, let's call the headers: Name A Name B Name C Name D Name E I also have 10 columns of other names (not necessarily unique), ...
1
vote
1answer
8k views

Linking dropdown lists

I would want to link a drop-down list to the values of an adjacent cell. Let say, we have two cells A2 and B2. A2 is a drop-down list with values: Agric, school, sme and housing, while B2, which is ...
1
vote
0answers
25 views

Cell Formatting, 0.00 where blank value

I have some cells that are formatted as hours and minutes i.e. [h]:mm. If no value exists in a cell I want the cell to show 0:00 without having to manually type. It needs to be user friendly, so if ...
0
votes
3answers
22 views

Excel macro: Last non-empty cell in a column

This is a followup question to this one. The following formula can be used to find the value of the last non-empty cell in a column, in Microsoft Excel: =LOOKUP(2,1/(A:A<>""),A:A) My ...
1
vote
1answer
2k 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?
0
votes
2answers
3k 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 ...
1
vote
1answer
133 views

head and cat don't recognize Microsoft Excel text files

I have a large .xls file with 53760 rows and 19 columns. I saved it as Tab Delimited Text in order to pre-process it through command line tools and load it into R later. However, when I run head ...
47
votes
9answers
48k views

Open Excel files in new window

When I have Excel running and I double click an Excel file in Windows explorer, I'd like it to launch in a new window by default so that I can move documents to separate monitors. Is there any way to ...
5
votes
5answers
8k views

Copy/paste filtered column in Excel - error message

In short, I have filtered a worksheet by column A, and I want to copy/paste from column B to column C. Obviously I don't wish to copy/paste values from rows that were filtered-out here. The above ...
0
votes
2answers
29 views

Excel formula for average daily profit

I have a table that has just two columns, Date and Profit: Date Profit 24 - March 25.00 24 - March 19.85 25 - March 5.25 26 - March 6.36 26 - March 10.18 26 - ...
7
votes
6answers
24k views

How to export selected columns into csv file

I want to export specific number of columns from excel into .csv file. I have around 10 columns like lname, fname, phone, address, email and so on. what should i do to export certain columns like ...
-2
votes
1answer
15 views

How to transfer spreadsheet to downsized spreadsheet [on hold]

Can I copy an excel spreadsheet with 20 columns and paste into a template using only 8 of those columns with the column sizes slightly changed?
0
votes
1answer
15 views

How do I prompt a user with file “Save As” dialog using a macro?

I created an Excel macro to replace data from "Quote" to "Invoice", but after running the macro, I wish for the macro to continue to run and stop at: "Save As..." mode so that the user can provide a ...
0
votes
2answers
27k views

VBA code to hide or unhide rows based on a cell value

Heres my code, but its not really doing anything, I dont see anything wrong with it: Private Sub PG1(ByVal Target As Range) If .Range("E50").Value = "Passed" Then ...
0
votes
1answer
26 views

how to CONCATENATE array text?

Let the cell A1 has "abccba" Now I write a formula in the cell B1 =RIGHT(LEFT(A1,ROW(INDIRECT("1:"&LEN(A1))))) it gives value "a" or array string as{"a";"b";"c";"c";"b";"a"} Now when I concatenate ...
0
votes
1answer
20 views

Excel 2013, Vlookup - accessing different sheets.within a workbook

I Have a cell (lets say its A1) that specifies (from a drop-down list) a Sheet Name (AA BB CC DD etc) I want to pass that sheet name to a VLOOKUP Formula which would (if life were simple) be SOMETHING ...
0
votes
1answer
23 views

Excel Daily Average Profit

I have a table that looks like this..Just two column..Date and Profit: Date--------------Profit 24 - March------25.00 24 - March------19.85 25 - March------5.25 26 - March------6.36 26 - ...
0
votes
1answer
36 views

excel 2010 Vba, looping through named ranges, Run-time error '1004':

I am assigning the same Macro to several OptionButtons. I try to determine in which named Range the cklicked OButton is located. So I get the Cell of the Button and loop through all named Ranges in my ...
0
votes
0answers
14 views

Hyperlink to file in TextMate

I use TextMate to edit LaTeX documents. Let's say I have the file foo.xlsx on my Desktop. In my .tex file how can I add a hyperlink to foo.xlsx, so that when I click on the link, the file is opened ...
1
vote
0answers
23 views

Office 2013 on Windows 8.1 gives out of memory error when opening files

We have the same error that has been posted here: Problems opening Excel attachments from Outlook Namely, when a user opens a file from the internet, the internal network or an outlook attachment ...
7
votes
5answers
25k views

How do I save an excel spreadsheet as a semi-colon separated values file?

I am running excel and would like to export my file as a .scsv (semi-colon separated values) sheet instead of a .csv. Is there any way to do this? ps. I can't do a .csv and search and replace ...
1
vote
2answers
3k 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 ...
0
votes
1answer
3k 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. ...
2
votes
3answers
4k 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 ...
1
vote
2answers
43 views

Excel: Sum a column of text excluding duplicates in another column of numbers

I am trying to figure out a formula. I need to know how many times a certain issue happens based on case numbers. Meaning there are multiple entries under a specific case number for that subject, but ...
0
votes
3answers
19 views

Display excel grid lines in front of a chart?

I have an area chart in Excel for Mac 2011 that I'd like to display grid lines in front of. Is there a way to do this? I know I could make the chart semi-transparent and show the grid lines through, ...
1
vote
2answers
46 views

Excel: How to connect to a sqlserver localDB

I have created a LocalDB that I can work with in MS sqlserver management studio 2014, linqpad, and visual studio 2013. Here is the part of the "connection property" dialog in SSMS which shows the ...
0
votes
2answers
25 views

Finding a value in one colunm that matches another column then putting that value in a third column (excel 2010)

All of the values are texts since the are usernames that are from two different systems. so one column has: Column A Column B smit19108 Fred99015 Fred99015 Smit1908 ...
1
vote
1answer
22 views

How can I assign Excel keyboard shortcuts for macros that use keys other than Ctrl + {alpha character}

I would like to assign keyboard shortcuts to Excel macros that use keys other than the standard Ctrl + {alpha character}. Based on this post it sounds like it is possible but I am not sure how: ...
0
votes
0answers
26 views

setting upper and lower limit excel histogram

I am using the built-in data analysis tool to create a histogram for a column of numerical data in Excel. I'm doing the same thing for many different files, and they all need to have the same scale ...
1
vote
1answer
39 views

Excel formula to show FORMULA

Ok, guys. I am 100% sure that a few days ago I saw and tested a real built-in Excel formula for showing a formula as text in any cell. Now, when I need it, I cannot find it!!! No VBA, no tricks. Just ...
1
vote
2answers
4k views

Excel tries “Accessing Printer” while opening specific workbook

Excel 2010 (Windows 7 Professional 64-bit) is loading a specific Excel file to 100%, then the status message on the splash screen rotates between "Opening (100%)" and "Accessing Printer". It sits and ...
0
votes
0answers
23 views

Multiple Values in one cell needing separate row in Pivot Table

I am looking for a solution on how to have a separate row in a pivot table for 2, 3 even 4 values in one cell. Example - Columns are as follows: Date, Job Name, $ Value, Distributor Quoted, ...
-1
votes
1answer
24 views

Fixate scroll in excel [closed]

How do I "fixate the scroll" at line 27 as khan did in this excel spreadsheet? https://www.khanacademy.org/downloads/buyrent.xls
3
votes
8answers
28k 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 ...
2
votes
1answer
28 views

How to unselect Excel Cell using Keyboard Shortcut?

One can select multiple Excel cells (either contiguously or not) using the keyboard shortcut Ctrl+Click. How do you deselect one or more of these previously-selected cells?
23
votes
11answers
100k views

Excel displays ### for long text - what's wrong?

We've got an excel sheet with a pretty long text in one cell. Instead of line breaks (as set in the cell format), we get a long line of ####s. We can go back and forth by deleting and adding chars at ...
1
vote
2answers
21k views

Excel Formula To Get First Non-Zero Value in Row and Return Column Header

I am attempting to find a formula where I can look at a column range within a row and return the column header in that row where the first non-zero value occurs, moving left to right. Below is a ...
0
votes
1answer
14 views

Return transposed list of all strings in a row in Excel

In my Excel (for Mac 2011) sheet, the range B2:2 contains mostly empty cells, but some cells contain strings. I would like to print these strings into a transposed list beginning at A12. This list ...
0
votes
0answers
13 views

Import image from MS SQL Database into Excel

I have a MS SQL Database where images are stored as byte[]. Is it possible to import these byte[] into Excel and convert them back into images? I already have a connection to the database in my Excel ...
0
votes
1answer
27 views

Excel converts datetime to other format where days are low enough to be months

I live in europe and our datetime format is usually dd/MM/yyy I have an excel spreadsheet where I have ALOT of dates But for reasons I do not know, Excel converts where (dd < 12) to mm/dd/yyyy - ...
2
votes
1answer
25 views

Excel Formula - returning data

I have a spreadsheet that has four columns of data. I want column number four (D) to display the value of column three (C) IF the number next to it in column two (B) matches ANY number in column one ...
1
vote
1answer
27 views

Show increase in trendline by using Excel vba

I have data in c5:c12 (sales1) and I plotted a graph and a trendline of this data. I also have data in d5:d12 (sales2). I would like to show an increase, graphically, in my existing trendline by using ...