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

Changing cell style groups

I was sent here from stakoverflow When I create a new cell style in Excel, it goes in a group called Custom. The standard groups include Good, Bad and Normal, Data and Model, Title and Headings, and ...
0
votes
1answer
9 views

Excel Data Extraction Formula - Windows 7 (64-bit) Office 2010

I am trying to run a report to evaluate the Downtime of devices in a network. The OpManagement report doesn’t have any customization available for output reporting. So I am looking for a way to ...
0
votes
1answer
9 views

Excel Decimal auto round up or down to 5 or 0

Example, I have this 221.54,195.97, Now i want it automated roundup or round down to 221.55, 195.95. Do have and formula for this?
0
votes
0answers
5 views

Extracting HTML from excel to enter in MySQL/Wordpress site

I have a WordPress site and a Excel document. I'm not familiar with excel forumlas so forgive me. In the document it contains a lot of names, email address and telephone numbers. I want to create a ...
0
votes
0answers
9 views

Excel Graph with 2 X-Axis Non-Linear Mapping

I have the following problem someone might be able to help with. I have two risk scales, one from 1 to 11 (old) and one from 1 to 21 (new), where the mapping is non-linear, i.e. old scale->new scale ...
1
vote
1answer
5 views

Summing multiple cells that match row AND column criteria?

I've been given a file with 2 years worth of dates as column headers and sales info below. There's also a column that contains Year data. I'm trying to sort by both Year and Day of the Week. I'm ...
0
votes
3answers
5k 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 ...
0
votes
2answers
4k views

analysis group not visible

I want to do some regression. However I have no Data Analysis group in the Data tab. I've been through the sequence File/Options/Add-Ins and the Analysis ToolPak is in the upper group "Active ...
0
votes
0answers
21 views

Pairing Numbers in Excel

I have a list of congressman (and some of them repeat) and I’m looking for something that will fill in the matching distract number in the corresponding cell, so I can eliminate the risk of the human ...
7
votes
11answers
20k views

When does Excel decide to overflow text into adjacent cells, or cut them at the boundary?

In Excel, 2010 or any other version probably, if I enter in a cell, a long single-line text that is longer than the width of the cell, Excel sometimes render the text across the next adjacent cells; ...
18
votes
3answers
101k views

What is the Excel hotkey to re-calculate all formula in sheet?

I have a sheet that contains many formulas. But they do not recalculate automatically when I change input. I'm looking for a hotkey, that can re-calculate the sheet. According to this page, F9 ...
0
votes
0answers
7 views

Access 2013 How to prevent from saving a record

I had created a form in access 2013 to add records to a table but I'd noticed that if I close the form without saving the record access still saves it to the table anyway. I would like to know how to ...
0
votes
1answer
13 views

Excel Index/Match Sum

I have 2 worksheets in Excel. Both have data from a 2 different databases. The first tab has part numbers and costs (could be different day to day), the second has how many times that part number ...
1
vote
0answers
6 views

Excel pivot table: Show values instead of summaries

I have a table of data like this: ID |Name |Brand |Model |License ------------------------------------ 1 |Foo |KOM |830 AC |A 1 |Foo |KOM |930 E |B 1 |Foo |CAT |980 H ...
-1
votes
0answers
9 views

Macro - Creates individual workbook based on template on sheet2 and data on sheet2

Option Explicit Sub CreateBooks() Dim rCl As Range, rRng As Range Set rRng = Sheet1.Range("A1").CurrentRegion.Offset(1) Application.ScreenUpdating = False For Each rCl In ...
-1
votes
2answers
49 views

If one number then a different number

I have two columns of numbers on a data page, over 500 pairs. And I need a formula for the working page that will insert the second number in “column B” if the first number is in “column A”. So if my ...
1
vote
1answer
17 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 ...
0
votes
1answer
23 views

Schedule; want to check if everyone is present

We're making a schedule in Google Docs / Excel We want to be sure we've got everyone in the schedule.... So we make an Excel per day we're everyone should be present in a day (row 6/7). I know I ...
0
votes
0answers
27 views

How do I stop excel duplicating values in VBA?

I run a code that groups same products together and total quantities of those products. However It only works if all items are filled in if not it duplicates. For example: Instead of Product 1 ...
0
votes
1answer
27 views

Excel: what makes .xlsx files use less space than .xls files?

I have some xls files without around 12 tabs containing data, links to other excel files, some data validation, and some conditional formatting. Saved as xls, they use around 1.2-1.5 mb each, but if ...
0
votes
1answer
17 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
1answer
15 views

Run a Mail Merge using a Database from Excel [on hold]

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
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
21 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 ...
1
vote
2answers
38 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
24 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
134 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
28k 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
28 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
21 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
24 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
40 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
16 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 ...