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.
0
votes
1answer
16 views
Excel 2010 - Data Validation not accepting the decimal “0”
I have a range in my spreadsheet with custom type formatting:
##":"##
on the range I have also setup data validation:
Validation criteria
Allow: Text length (Ignore blank is unchecked)
Data: ...
1
vote
2answers
15 views
How to avoid hidden Excel rows/columns being read?
I have an Excel file with a big worksheet, frequently updated and submitted.
Quite a number of rows and columns are hidden in order to make the calculation details and raw data invisible to people ...
1
vote
0answers
22 views
Dynamic Print Ranges become Static in Excel 2010
I have a spreadsheet that I created in Excel 2011 for the Mac. In it, I am able to create a dynamic print range and it works well.
However when I open the spreadsheet in Excel 2010 for Windows, I ...
0
votes
0answers
12 views
in Excel Range copy, How can I copy without changing the active sheet
There're several tabs in a workbook(Excel file).
I want to get a copy from other tabs not in active.
When I try this, the control changes from current tab to source tab, so the monitor blinks shortly ...
0
votes
0answers
15 views
In MS Excel cell format, How to change the default time duration from “number of days” to “number of minutes”?
In MS excel if I set a cell format as time (e.g. [h]:mm:ss) and then if I type any number N in that cell, MS excel assume that number as number of days since 1st Jan 1900 00:00:00. Is it possible to ...
0
votes
1answer
8 views
Excel 2010 chart does not show x axis value
In Excel 2010, chart data series don't seem to show the X axis value. When you put your cursor on a certain data point, it shows "Series(Y axis value)"/ "Point(X axis value)"/ and "Value". The X axis ...
15
votes
5answers
30k views
How can I “group by” and sum a column in excel?
I'm trying to figure out how to "group by" values in an Excel spreadsheet.
Given the following example (this is an inventory sheet I use at my restaurant:)
At the far right of the spreadsheet ...
2
votes
1answer
25 views
Excel: How do I calculate net workdays for an array of date ranges?
I have a list of date ranges, let's say:
A B
1 April 25, 2013 May 31, 2013
2 September 30, 2013 October 18, 2013
I need to calculate a sum of net working days of all ...
0
votes
0answers
8 views
using hyperlink function with pathname to excel file LOCKS keyboard
I want to link to other files by referring to their pathname in a hyperlink function. This used to work fine for all file types including linking to other Excel files. Now, when I try to hyperlink to ...
1
vote
1answer
199 views
Excel 2007: Intermittent 0xc0000005 crashes
Hello there SuperUser Hive Mind.
We are having an issue at the office I work. One of our users who has a workflow which consists mostly of Excel documents with dynamic formatting and macros which she ...
2
votes
1answer
57 views
Background colors in Excel 2010
I have an Excel 2010 spreadsheet. Right now, the entire background is at 40% gray, and need to be white/transparent.
There's no conditional formatting set.
The worksheet is not locked.
The ...
1
vote
1answer
26 views
Trouble opening CSV files in Excel and keeping rows distinct
I have an Excel .csv file that is semicolon separated, but it won't open properly. So I tried a few things: changing language/regional settings, changing the list separator from a comma to semicolon, ...
2
votes
2answers
33 views
How do I count the number of sequential recurrences?
I have an excel file which I have performed an operation on. I now have a column that is populated by either the value 1 or 0.
What do I need to do to count the number of "1's" that appear in a ...
3
votes
3answers
8 views
How to transform string to “d-m-y (h)h:mm” format in Excel?
I want to transform a bunch of string cells into date (and time) cells, in order to calculate the difference between the current date and time, and the initial date.
Currently the string cells look ...
1
vote
3answers
56 views
Reformatting data in excel
This is a complex question with multiple steps.
I have a client who has information that needs to be imported into Salesforce as a note.
They're relatively open on how this is formatted. As long as ...
2
votes
2answers
58 views
How to get the reference of the result of an array formula in a list?
I've got two arrays, each one includes shop ids, x coordinates and y coordinates for us and the competition.
I'm looking to get for each shop of ABC corp, its closest competitor in list XYZ corp.
...
1
vote
1answer
20 views
Grouping Rows Together
I have a column with 14-character alpha/numeric data. I want to group rows together based on the first 7 characters. Is this possible, in particular without VBA?
For example, if I have this data, ...
2
votes
3answers
4k 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
2answers
3k views
How to sum within a date range, Microsoft Excel
I am very conversant with pivot analysis but I do not want to use it for this for my table.
I want to be able to make calculations between a date range. For instance, sales of a particular product ...
0
votes
0answers
14 views
Horizontal Scroll in Excel Won't Let Me Go Past Columns Visible on Screen
Excel was working just fine. Now the horizontal scroll is long. If I try to move it to the right, it automatically goes back to the left. I can use the arrow key and go to cells beyond what is ...
0
votes
1answer
19 views
Excel 2013 collaboration with Excel 2003
We have a Excel 2003 document that is saved as a shared workbook which works for Excel 2003, however it it also used by Excel 2013, I don't think Excel 2013 is working properly with the shared ...
2
votes
1answer
26 views
WHERE in vlookup?
I'll try my best to explain this - I know exactly how to do this in SQL but not in Excel. I have two worksheets (let's call them ws1 and ws2). In WS1 we have a 'product code' column and in WS2 we have ...
3
votes
1answer
4k views
Excel: #NAME? appearing when linking/referencing other spreadsheets/workbook cells
I'm updating a spreadsheet that refers to data in another worksheet =NameofWorksheet for some reason I get #NAME? in some of the cells, even when the actual path is correct.
The only way to overcome ...
0
votes
0answers
17 views
How can I get this subroutine run when “yes” is selected?
Below is a code that I now have working, It takes the sheet "INITIATING DEVICES" and searches for column "G" if column "G" has a value of "Yes" then it will copy that row, only columns "A, B, C" to ...
0
votes
1answer
18 views
Cross check email addresses and delete the entire row of duplicates?
I need to merge 2 files into 1 and would like to crosscheck the email addresses to find duplicates and delete the entire row that it's contained in. Is this possible?
So far I just copy pasted all ...
1
vote
1answer
30 views
How to set a password to open an Excel 2007 document
How to set an Excel password to protect a workbook from unauthorized access by setting a password on it?
I once saw an Excel document with a password required to open it. I found out how to do it and ...
-1
votes
1answer
30 views
How can I draw the data in Microsoft Excel?
I have the following date in Microsoft Excel.
What I want to do is make the threshold as the x-axis, and each value corresponding to the threshold (i.e; H1, H2, ...etc) be on the y-axis.
So, for ...
2
votes
1answer
22 views
Adding foreign keys from existing Access tables to imported Excel sheet
I have an existing list of personnel that I am trying to associate with an imported list of computers. Specifically, I want to replace the current columns listing the names of the personnel assigned ...
-1
votes
3answers
3k views
How do you save an Excel document as a Word document?
I was hoping someone could tell me how to save a Microsoft Office Excel document to the Microsoft Office Word document format?
4
votes
3answers
58 views
Excel Formula to Calculate the Third Point in a Triangle
I need an Excel formula that can help me find the third point in a triangle, given most other information. This is not homework, meaning I do not need to do this just once. I need a consistent way to ...
1
vote
1answer
2k views
How do I assign hyperlinks to drop down menus in Excel?
I'm using the HYPERLINK function and finding it reliably useful. I'd value being able to assign hyperlinks (somehow) to individual menu drop downs.
4
votes
5answers
16k views
How to write multi lines in one Excel cell?
I want to write multi-lines in one MS Excel cell.
But whenever I press the Enter key, the cell editing ends and the cursor moves to next cell. How can I avoid this?
-1
votes
0answers
24 views
Function WhatIsThis(Text As String) As String [duplicate]
Function reverses(Text As String) As String
Dim StrNew As String
Dim strOld As String
strOld = Trim(Text)
For i = 1 To Len(strOld)
StrNew = ...
13
votes
9answers
17k views
How can I set Excel to always import all columns of CSV files as Text?
Though I try to avoid it, I occasionally have to open a CSV file in Excel. When I do, it formats columns containing numbers, which makes them useless for my purposes. As far as I can tell, the only ...
1
vote
4answers
10k views
Excel 2007 | Remove blank fields from pivot tables
Every time I create a pivot table (available for all Excel versions) I get one or several blank fields. How can I get rid of them?
One workaround I used was to select the blank field, right click | ...
1
vote
5answers
2k views
Microsoft Excel 2007 - Cannot Fit All Text Into Cell
Is it possible to fit a large amount of text within a cell in Excel 2007?
I have 1,890 words - consisting of 10,110 characters (without spaces) - that I need to put into a single cell in Excel. I ...
1
vote
2answers
784 views
Plotting discontinuous graph in Excel - Mac 2008
have some data that has gaps in it and Im not able to plot it in excel. I know I want to uncheck the "Leave Gaps" item in the Tools / Chart / Options panel. Plenty of googling has showed that that's ...
-1
votes
1answer
23 views
How to find that are there any duplicates AND already checked?
I would like to know if there is a duplicate value in my sheet and if it as been already checked.
Example:
Error ID
001
1 002
1 001
003
002
In ...
-1
votes
0answers
31 views
Transport values from another excel document automatically with button
I want to transport an some values copy (B3 in Product.xls) to another excel document (B18 in BI-Sales.csv) in the different cell at a click of a update button.
I don't have any idea about excel Vba. ...
2
votes
1answer
26 views
How to make rages in named tables fixed in Excel 2010
In MS Excel, if "format as a table" is used the links do not look like A1 or B15 anymore but like Table1[[#this row];[column1]]
The problem is when copying these expressions to other cells they do ...
1
vote
1answer
18 views
Opening XML+XSD files in Microsoft Excel 2013
I have found Excel 2013 supports opening, editing and saving XML files. I have created an XML file + XSD which Excel opens without complaints and errors. (I.e. it does not state it has to create ...
0
votes
1answer
19 views
Excel Dual Axis on same side
Is it possible in excel charting to present in a way such that instead of have a secondary axis, both axis reside on the same side?
Like this:
...
1
vote
2answers
26 views
Merge CSV files to one Excel file in different sheets
I want to merge CSV files to one Excel workbook in different sheets.
I want each file in one sheet with the CSV file name as sheet name.
1
vote
2answers
4k views
How to compare data in 2 columns in Excel and then in one cell, determine if there are similar data in both columns
I have 2 columns in Excel: the first contains a list of employee names who perform function A, and the second contains a list of employee names who perform function B.
What I want is to identify, in ...
30
votes
7answers
19k views
How can I stop Excel from eating my delicious CSV files and excreting useless data?
I have a database which tracks sales of widgets by serial number. Users enter purchaser data and quantity, and scan each widget into a custom client program. They then finalize the order. This all ...
1
vote
1answer
1k views
“Windows cannot find” file when opening Excel spreadsheet
For all of my Excel spreadsheets when I attempt to open them (by double-clicking in explorer) I get the message "Windows cannot find C:...". The files are there, and are valid zip files as seen by ...
-1
votes
0answers
13 views
Excel change connection path to prompt user
I recorded this macro and it works great. But I need to prompt selection of the file path as it will not always be same name or same place.
Sub Macro7()
'
' Macro7 Macro
'
' Keyboard Shortcut: ...
0
votes
1answer
16 views
Organizing Sales Data Using Excel Macros
I am writing a macro function in Excel to organize a set of monthly sales data. The original format uses 6 rows per entry, and the organized table uses only 1. The number of sales changes every ...
1
vote
1answer
54 views
Split excel file as per cell value
I have file of more than 100000 recodes. I want to split the file as per the cell value. For e.g. in column A I have SOLID, I want to split the file as per the SOLID and save in the name of SOLID. ...
0
votes
1answer
27 views
Extracting Mac Addresses from Imported List
I need to track down a bunch of MAC address based on the IEEE list. I have a list in separate sheets in an excel workbook. I also have a list of partial mac addresses in the last sheet from the IEEE ...
