Microsoft Office Excel is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables and a macro programming language called VBA (Visual Basic for Applications). Features and usage The latest versions ...
0
votes
1answer
17 views
Excel - Comment a remarquable point in a graphic
I have a graphic like this one, based on dates/values :
Some points on the graphic represent special events, and I'd like to associate them with a comment, like : "Called the manager", "Strike", ...
3
votes
1answer
34 views
Why does pasting into an unprotected cell in Excel protect it?
While researching the answer to this question, I stumbled across a rather odd behavior in Excel related to unprotected cells in protected worksheets.
To see what I mean, create a new workbook, ...
1
vote
0answers
20 views
Excel Column Graph with Varying Witdths
I am looking for a Microsoft add-in or application in which I can create column graphs with varying widths.
Id' like something similar to the ones used on informine.com
or alterenergystocks.com
Any ...
0
votes
1answer
59 views
How to return first non-blank cell and if it's already a value before it, return the third non-blank and so on?
How to make a function which would return the first non-blank cell value but if it's defined in the left cells next to it, it would jump 2 cells and look for the next value.
Table:
1 | 2 | 3 | 4 | ...
1
vote
2answers
34 views
View linked Excel 'Windows' on separate screens
A colleague had a problem where he couldn't link a cell in his destination workbook with a series of cells in a source workbook. The problem was that in order to link workbooks, he had to open them ...
1
vote
1answer
19 views
OpenOffice: Replace text with new-line
In my OpenOffice spreadsheet, there are cells containing "\n" text.
Each "\n" occurrence needs to be replaced with a new line or line break.
The Find-and-Replace dialog does offer regular ...
2
votes
3answers
49 views
Convert Excel data
I've made a survey in Sharepoint and want to convert the results into something useful in Excel 2003. My problem is the format the responses are in for some questions.
An example of two responses ...
-1
votes
1answer
43 views
how do I create an equation in microsoft excel worksheet?
I need to create an equation that calculates the amount of native currency using an absolute cell reference formula. I am doing an assignment and it requires me to find the native currency of $1 ...
0
votes
1answer
26 views
How do I sort in Excel 2007 but do not go to the top of the list?
How do I sort in Excel 2007 but do not go to the top of the list? I have a filtered set of data many rows long. However, when I am deep in the list, and select to change the sort by method on one of ...
0
votes
1answer
12 views
CSV - Microsoft office for mac 2008 doesn't add all the commas?
Let's say I have 5 column headings and I only complete the first 2 values. I then save the file as CSV (Windows). It ends up looking like this:
ID,Product,Name,Value,Interest
1,PC
Which is no good ...
2
votes
1answer
37 views
Can I use 2 different Columns of Data for the same axis & same series in Excel
I have a simple dataset in Excel showing Players, Win Count & Win %
I'd like on my Bar Chart to keep the % on the Vertical Axis like it currently...
But I'd also like to put the Win Count on ...
0
votes
1answer
27 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 ...
2
votes
3answers
30 views
Update a summary sheet in Excel
I have a spreadsheet that will eventually contain 52 sheets(one for each week) On each sheet there is a cell with a percentage in it. I would like to copy this cell to a summary sheet so that it can ...
1
vote
1answer
30 views
Excel trendline intercept
I have an excel graph with a linear trendline, like the one shown at Graph Screenshot to keep track of users who are updated with a newer version of software.
I have 660 users, and the trendline ...
0
votes
2answers
46 views
Freeware option for conducting surveys on the intranet [closed]
I am looking for a way to conduct online surveys within my organization. I am looking for a tool that is
Free or Open Source.
Accumulates responses automatically in a
Microsoft Excel or CSV file.
...
1
vote
1answer
34 views
Create reusable custom shapes in Microsoft Excel or even Office in general
In Microsoft Excel 2007/2010, or even Microsoft Office in general,
Say I use the use Insert > Shapes to create a drawing in Excel, is it possible to save this drawing in as a new Shape itself in the ...
-1
votes
2answers
74 views
Count if two criteria match while ignoring duplicates
I have a simple Sheet with 2 cells that I need to countif 2 conditions match and treat
duplicates as 1.
Column A Column B
Male closed
Female invalid #
Male exception
Male ...
0
votes
0answers
16 views
Is there anyway to co-author with the Excel 2010 Desktop App?
I'm wondering if there is clean way to co-author with the Excel 2010 desktop App? Now, or possibly this could be a placeholder for the future. The current answer seems to be no with Excel 2010 desktop ...
1
vote
2answers
40 views
Downsides to Microsoft Excel 2007 XLSB binary format?
Excel 2007/2010 offers an option to save my files in an "Excel Binary Workbook" format that seems to be smaller (50% of the size in some cases) and load more quickly. Is there a downside to this ...
1
vote
1answer
34 views
Create a rotating list of responsibilities
I'm in Toastmasters and a club meeting consists of members fulfilling different roles. Each meeting has different people serving in different positions. We currently rotate those positions and list ...
0
votes
1answer
34 views
Opening Excel Files From Sharepoint using Google Chrome
When I attempt to open an excel file from Sharepoint using Google Chrome, I get an error message: that there is an unsupported feature and would I like to open in Excel. If you say yes, then I get ...
1
vote
2answers
49 views
“Fill Weekdays” in excel 2010 fills sunday to friday
I have an excel sheet, in which I filled the date 01/03/2013.
I used the autofill feature to fill in the weekdays only, but excel filled Sunday to Friday, instead of Sunday to Thursday.
Any way to ...
0
votes
2answers
46 views
Get all linked files to an Excel 2003 document
I want to get a list of all the linked files in an Excel 2003 document, or, better still, automatically retrieve all the files linked to the document and zip them. Is such an operation possible? I am ...
0
votes
2answers
25 views
Excel protection options - when different areas need to be updated by different staff
When using password protection in Excel 7 - what options do you have that don't require you to re-enter the password again before saving/closing the file - ie to keep it protected if you happen to ...
0
votes
2answers
33 views
MS Excell: make a total of all cells in a row minus ones with letters
I am struggling with Microsoft Excell. I am using it to keep track of averages and totals.Example: ROW 1 7,5,9,4,10,A,D,0,2 Sum:37 AVG 3.9 How can I create a sum of all numbers divided by the total ...
0
votes
0answers
32 views
How to configure openoffice to properly open UTF-8 *.xls file with html table?
I have HTML document which is written with c#(asp.net) as HTML table in UTF-8 encoding into *.xls file.
This is done with purpose, that MS Excel and OpenOffice opens it as sheet, not as plain text.
...
0
votes
4answers
44 views
How to write null into csv from Excel for blank fields
How do I write null for blank fields when I export a csv file from Excel 2007? Is there a feature to do that.
3
votes
2answers
74 views
How to make Excel's “Auto Fit Row Height” feature actually auto fit the row height?
For every generation of Excel I can remember (including 2010, which I'm using now), Excel's "Auto Size Row" features sometimes fails to actually auto size a row when the cell contains wrapped text. ...
1
vote
1answer
30 views
Can I do a Multiple Regression with Excel?
I have performance data for 3 years for about 50K employees. Each employee has 3 ratings associated with them. I would like to create an equation that will predict (or try to predict) the future ...
-1
votes
1answer
23 views
How do I get Excel to update a string value as I drag the cell?
I have a link http://example.com/file01 and I would like to duplicate the link but with the "file01" part increment like "file02", "file03" etc. So I thought about Excel could do this on an integer ...
2
votes
2answers
63 views
Rearranging a 15 X 25 Excel matrix into three columns
In Excel I have data in cells from A1 to O5 (15 X 25).
I wish to rearrange things such that I have the following
[A1][B1][C1]
[D1][E1][F1]
[G1][H1][I1]
[J1][K1][L1]
...
2
votes
1answer
25 views
Microsoft Excel validation based on adjacent cell
I have a two adjacent columns named Country and Rating. The Country column has a dropdown to select which country a DVD is being delivered to. It is using a list validation to create the dropdown:
...
0
votes
0answers
24 views
Opening Excel links from IE 9 on Windows 7
Similar to this question: Opening Word documents from IE LAG Windows 7 IE8
Users on our intranet are experiencing large amounts of latency/lag when opening MS Office documents from within webpages in ...
1
vote
1answer
40 views
Filtering by currency in Excel
I have this situation in Microsoft Excel:
Cells are formatted by using "Format Cells" and setting the Currency manually for each cell. So, they are not simple strings. I would to sum filtering by ...
0
votes
3answers
81 views
Getting an interval of medians in Excel, from a single column of data?
I have a quite a large number of rows of of data in the 'A' column in Excel.
What I'd like to do is get the median in intervals of 8 answers (=MEDIAN(A1:A8), then the median of the next 8 answers ...
2
votes
1answer
26 views
How can I save my excel spreadsheet in DBF format? [closed]
Possible Duplicate:
Is Workbook.FileFormat available to the Excel UI (specifically when the file type can't be saved)
How can I save my excel spreadsheet in DBF format? I used to be ...
0
votes
1answer
26 views
How do I use Excel 2010 Personal Macro Workbook?
I want all of my macros that I've written to always be available to me when I'm using MicroSoft Excel 2010. How can I do this?
1
vote
1answer
43 views
Excel VB Convert sheet text to unicode chars
I need to enter a function in an excel sheet that converts all cells values, that are texts, to it Unicode values.
For example I want ü to be ü and so on.
How can I achieve this, is it ...
1
vote
1answer
48 views
How do I auto-refresh an Excel auto-filter by colour when the colour of cells is changed?
How do i auto-update an Excel auto-filter (filter by colour) when the colour of cells is changed?
Use case: I change the colour of one cell to the colour that was filtered. I want to see the current ...
0
votes
3answers
45 views
Excel: Find rows with first column empty
My company uses a giant excel spreadsheet that shows which IP Addresses are being used by which computers (among other information). IP Addresses that are not in use still have a row, but the ...
0
votes
2answers
47 views
How do I get the last value of a column in an Excel spreadsheet?
In column A, I have dates. In column B, I have my body weight logged for the day. I add one row to each every day when I weigh myself, so this means the data is sorted by date ascending. The weights, ...
0
votes
3answers
55 views
Excel table - delete rows not in filter
i have a very large table in excel (1000's of rows) and i filter it to only show 10 rows. I wonder if there is a way to delete the rows not shown [ ie dont meet filter conditions]? this would enable ...
2
votes
2answers
59 views
Merging columns in Excel with “;” separator
I'm new here and I hope to seek for your assistance on converting data format of my excel to csv.
This is my raw data in excel in different row and cells:
A B C D E F
1 2 3 4 5 6
...
1
vote
2answers
75 views
Excel 2007 opens with only one worksheet
In Excel 2007, when User A creates a new workbook, there is only 1 worksheet for the book. When user B creates a new workbook, there is the standard 3 worksheets for the book. How do I get this back ...
1
vote
5answers
92 views
How to prevent Excel rounding numbers or adding redundant 0's?
I have a column of numbers that appear like this:
but the actual value of the shown cell is 20130.153334
Other values have a different number of decimal places. I don't want to add redundant 0's, ...
1
vote
2answers
39 views
Excel - Create text file named after a cell containing other cell data
I'm looking to create a .txt file for each value in column A containing the corresponding values in columns B and C
0
votes
1answer
41 views
Concatenating # with leading 0's in Excel [closed]
I am trying to concatenate 3 fields together but some of the fields have leading 0's. Does anyone know of a way to use this formula and still be successful?
1
vote
1answer
55 views
merge cells with formula skip duplicates
Our Goal is to merge the names (B) when the data in A is equal. The formula below looks at the next line (A), if it's the same, it merges data (name) from B. The formula is in C, so the result of the ...
0
votes
1answer
28 views
Prompt to select excel spreadsheets in Access?
I have a Microsoft Access 2007 database that uses excel spreadsheets to track changes between the two. A new file is generated every week. I then do a compare against the two of them with some custom ...
0
votes
1answer
39 views
Horizontal hierarchy chart in Visio from Excel
I can create a vertical hierarchy chart in Visio from Excel data. Thing is, I need a horizontal (left to right) chart. Is it possible to create?
If not, as a workaround, I rotated the chart, but now I ...
