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.
5
votes
5answers
15k views
Excel Auto-Fill Without Mouse (Keyboard Only)
So when I want to extend a series or something along those lines, I can highlight a group of cells, then click on the bottom right corner of the highlighting box and drag down. Excel will then ...
0
votes
2answers
1k views
Changing Intra-workbook worksheet references W/O using Search-and-Replace
Excel Question: I have formulas in Sheet A linked to Sheet B. I'd like to change the links from Sheet B to Sheet C or to Sheet D by changing the contents of a cell on Sheet A and not having to ...
1
vote
1answer
95 views
EXCEL: Creating graphics controllable by events in spreadsheet?
I am wondering if there is way to create or import graphics in MS Office Excel, and then control its properties by script.
For example imagine a map of world on the right hand side and a spreadsheet ...
1
vote
3answers
1k views
Logarithmic X-axis in Excel puts axis numbers in wrong position
I have a dataset with logarithmic x-values (of concentration being diluted by a factor of 10) and regular (non-logarithmic) y-values. When I format the x-axis to use a logarithmic scale, the y-axis is ...
0
votes
1answer
5k views
Excel 2010 pivot table/chart - how to filter a date range without empty rows
I have an Excel 2010 PivotTable pointed to some data in the workbook that includes a date. I can group the date field into year and month just fine. What I want to do is produce a chart of a filtered ...
1
vote
2answers
290 views
How to get a number from sets of pairs in Excel
In Excel, I want to get the corresponding number for a given value in a set of numbers.
Given values are in disorder.
Example:
1 | 21
2 | 34
3 | 15
4 | 47
5 | 29
Here the minimum value is 15 & ...
0
votes
1answer
196 views
Excel: Using lookup or match to find things in ascending order
In Excel, the functions lookup and match are for descending order.
Are there functions like these which work for ascending order?
0
votes
1answer
52 views
How to list people below the average in Excel/OpenOffice?
I have a spreadsheeet that shows a list of people and how many appointments have been booked for each of them in the past week.
It looks a bit like this:
I want to make a list underneath that ...
0
votes
1answer
60 views
Counting the numbers from letters
I have a worksheet that has these inputs:
0900-1800
0900-1800
DAYOFF
0900-1800
0900-1800
my question is how can I count only the ranges with the time only?
like for example the data above should ...
2
votes
1answer
143 views
excel formula formatting
I have the following formula in Excel:
=IF(A5="File Start","File Creation DateTime = "&MID(C5,113,13),IF(A5="Start","Statement Date = "&MID(C5,65,8)&" | Opening Balance Date = ...
5
votes
2answers
8k views
Why does excel always say “..may contain features that are not compatible with CSV” when saving a CSV file?
Every CSV I've ever tried to save from Excel (2010, anyway) says filename.csv may contain features that are not compatible with CSV (Comma delimited). Do you want to keep the workbook in this format?. ...
0
votes
1answer
709 views
Excel VBA MsgBox handling checking for existing file
I'm not sure how to handle the output from a MsgBox in order to allow my macro to continue processing given differing situations.
This macro creates a daily report file with an output name of ...
0
votes
1answer
836 views
In Excel VBA Macro does ActiveWindow.Scroll change ActiveCell at all
I'm cleaning up and extending some excel VBA macros (written and currently running in Excel 2003), and I have a question about how far I can go in cleaning up without modifying the output.
There are ...
0
votes
2answers
308 views
Scheduling people using excel
I'm currently at work trying to begin scheduling employees to begin work. The details are not important but we have 700 employees that need to be scheduled in specific areas. The past people who held ...
0
votes
1answer
1k views
Excel file needs to open in excel, not excel viewer
I have excel attachments emailed to me daily, but when I open the attachment it opens in excel viewer instead of excel. I have excel installed. This only happens with my excel attachements from ...
2
votes
4answers
4k views
Subscript/Superscript Hotkey for Excel 2010 Macro?
Background
In Excel 2010, for some ridiculous reason, there is no built-in hotkey (or even a button on the toolbar) for subscripting/superscripting text within a text cell.
You can, however, ...
1
vote
1answer
304 views
Disable comma (,) in Excel Field
One of our Web Applications gives the users the ability to add multiple items to our database using a CSV file. To do this, they enter their items into an Excel template and then export to CSV.
...
6
votes
3answers
17k views
How to move columns with drag and drop in Excel 2011?
How to move columns with drag and drop in Excel 2011?
3
votes
1answer
1k views
Excel 2003: open spreadsheet and run macro from command line
The need: run a macro within an excel 2003 file every week, automatically, than save the file.
The approach: add an action to task manager for every week, calling the file with command line ...
0
votes
1answer
1k views
Convert Rows to Columns in Excel 2010
I have like the following set of data in Excel:
Name a
Age 22
Address add1
Name b
Age 23
Address add2
Name c
Age 24
Address add3
City XX
I need to convert this data into columns ...
0
votes
1answer
234 views
SP Alert email cuts off Excel table in Office 2010 but not Office 2003
I have an alert set up for a discussion board. We have been using Office 03 just fine, email comes in, the body is shown fully, everything is great. However, when we use Office 2010, not sure if its ...
0
votes
1answer
710 views
Change numbering language of the Excel context by changing the Windows language
How could we change the numbering language of MS Excel 2010 by changing Windows language
In version 2007 as I can remember we had an option in the advanced options tab that allowed us
to do that with ...
0
votes
2answers
942 views
Let Excel set row height automated for x predetermined no. of rows per A4 sheet?
I'm a European user of MS Excel 2010 and I came up with the weird idea, that I want e.g. 31 rows evenly spread out over the full length of one sheet (here: A4), excluding the page margins of course.
...
1
vote
1answer
166 views
Building diagram in Microsoft Office Excel
Could somebody help me to build this one?
Here's image.
This diagram tells about number of CPU cores during each year (X-axis) in TOP-500 comuters (Y-axis), digits right are number of cores. It ...
3
votes
1answer
1k views
Easiest way to test a list of URLS for 404?
If i have a list of URLS (a column in excel), what is the easiest way to test all of them for 404? Currently, I just have to click each one, look at the page, and close the tab/window, and this is a ...
1
vote
1answer
135 views
Office custom toolbar location
I have created a custom toolbar in my Office package (e.g. Word, Excel, Outlook). My profile got corrupted so I have to create a new profile. Does anyone know where the location of these toolbars is ...
1
vote
1answer
1k views
How can I display only the unique values in one column in Excel?
Is there a way to display the unique values in a column ONLY?
Example:
AAPL
AAPL
AAPL
AAPL
AKAM
AMZN
AMZN
AMZN
AMZN
AMZN
AMZN
Expected result:
AAPL
AKAM
AMZN
I have already done a sort for ...
2
votes
1answer
398 views
Conditional Formatting to highlight cells with highest frequency
I have an Excel table like the following:
1 2 3 4 5 6 7 8
----------------------
3 3 3 3 3 1 1 1
4 4 5 4 4 4 4 3
and I need a conditional style to highlight the items with the ...
0
votes
1answer
124 views
Making a Chart like this?
I'm trying to make a chart like this:
And my data is organized like this:
I'm just not sure how my chart needs to be organized in terms of series to achieve this.
Thanks
0
votes
2answers
5k views
Excel VBA Macro Sub or Function not defined
I used the macro recorder to generate a macro in Excel 2007. When I try to the run the macro, it tells me:
When I click Ok the definition of the macro gets highlighted.
I'm really confused ...
0
votes
1answer
82 views
Microsoft Excel _how to expand values
Hi I have got 2 columns. Column A has got Identities in it, and column B has got a quantity, I want to expand this so that it results in a column with just the identities in it repeated as many times ...
0
votes
1answer
111 views
How can I access a specific spreadsheet cell (from a list of them) using a formula?
Here's the situation: I have a list of numbers in a spreadsheet, all in a column. In another part of the spreadsheet, I'd like to refer back to the list, and get the value of a particular cell, based ...
0
votes
2answers
283 views
Pull up Excel's Sort Dialog
I have to sort a protected sheet and need to perform the unprotect-sort-protect dance.
The problem is this way I'm duplicating (less than perfectly) Excel's own sorting functionality, with the ...
0
votes
1answer
411 views
How to cut certain rows and insert before a certain row in excel
How to cut certain rows and insert before a certain row in excel, I am unable to do this in a reliable fashion.
Note: I should be able to remove the lines from which it was cut originally, currently ...
0
votes
4answers
11k views
How do you delete multiple rows in excel
How do you delete multiple rows in excel, if I mark everything and try to delete it just deletes a single row.
2
votes
2answers
252 views
Duplicating formula in Excel 2010
I have a bunch of formulas in a column that I wish to duplicate exactly into another column, where I will go through and tweak them so that a different function is run on the same parameters. When I ...
1
vote
2answers
1k views
How do I show the average by month in a pivot table?
Is there a possibility I can find the average per month (30 days) of a count sum column in a pivot table? If I use the average as summing value I get number one only
What I get is this:
Month ...
1
vote
1answer
861 views
How do I make Excel 2011 to highlight cells with formulas?
I remember that I was able to make Excel highlight cells containing formulas with a different color, making easier to distinguish between calculated cells and cells where I manually entered data.
I ...
2
votes
1answer
2k views
Excel, cut-n-paste ERROR-MESSAGE: “The picture is too large and will be truncated.”
ISSUE: Possible it's not related, but I just installed IE9, and now I'm getting this an error when I try to copy-n-paste a relatively small amount of text:
Excel Error Message:
"The picture is too ...
1
vote
2answers
818 views
Excel two columns with word list - find differences
Hi I'm not sure whether this is even possible, I have excel with two columns filled with words. In each column there is a word that is not in the other column and there are words which are in both. To ...
2
votes
1answer
2k views
Export data from MS Project to Excel
We are using MS Project 2003 and MS Excel 2007.
We would like to export task data from Project to Excel. Anyone know how to do this?
0
votes
3answers
877 views
How to stop VBA code from within excel converting Text to Time?
I have tried formatting the input fields as text but to no avail. When I step through it in the debugger it shows a double number which I presume is date conversion. I just want it to treat it as text ...
1
vote
1answer
2k views
Need a formula that looks at the first digit or letter in a cell
I have a column of numbers. Some begin with the digit 8 and the rest begin with other digits. I want to write a formula that will return "2" if the number in column A starts with 8, and "1" if the ...
0
votes
1answer
541 views
Excel 2007 Crash on “Page Layout” tab click
The title pretty much say says it all; when I click on the Page Layout tab in the ribbon bar at the top, Excel freezes and then crashes. How can I solve this?
All the other tabs work fine...
EDIT
I ...
2
votes
1answer
430 views
Pasting unfiltered data next to filtered data in Excel
I know there must be a way of achieving this without writing a macro, and just doing a straight paste.
I have two columns (Column A and Column B) that contain 10 records. 5 records are filtered out; ...
4
votes
2answers
701 views
What can cause an Excel status bar quick sum calculation to be wrong?
I have selected a 5 column by 20 row block in an Excel 2003 SP3 spreadsheet. I have selected Sum from the quick calc options in the status bar. However, the status bar shows a total of £24,000 when ...
0
votes
3answers
604 views
Do multiple e-mail addresses need to be separated by a comma?
In CSV format, in an Excel spreadsheet or in a Word document, both having multiple email addresses with each address being in its own row and in a single column, is a comma REQUIRED after each ...
1
vote
1answer
589 views
VBA Create Matrix from Multiple ListBox containing headers
I have a ListBox where are some columns names, and I'd like to build a matrix with only the selected columns in it. Is there a simple way to do that?
I'm actually trying with :
Dim Matrix_a() As ...
0
votes
1answer
151 views
Changing Text (pre-defined) in seperate column if previous colums cell is bolded
Doing some high quantity spreadsheet validations. Wondering if there is a way to populate a cell in column D with a predefined text ("Enabled") if the cell next to it is bolded. I went through and ...
3
votes
1answer
422 views
Excel hyperlinks can be attached to a range of cells — What would be a plausible use of this feature?
Background: I'm the author/maintainer of xlrd, a Python package for reading Excel 97-2003 XLS files. I'm in the process of enhancing to extract information about hyperlinks. My reason for asking this ...
