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
2answers
697 views

How to escape & sign in excel footer?

I need to have an excel footer that contains the string "&T". My problem is that when I attempt to do this excel automatically changes it to be "&[Time]". Is there anyway to escape the & ...
1
vote
2answers
886 views

Excel: include formatting in formula of another cell

I have a spreadsheet which contains a hyperlink based on the contents of another cell. I need the hyperlink to be based on the display (formatted) value rather than the data value of the source cell. ...
-1
votes
1answer
1k views

Display a value next to a cell containing a maximum value in a range.. Excel 2007

I have a range of cells (B1:B5) that contain random reading values. I want to find the maximum value in that range, and display 'Max' (or a defined number) in the next column, on the same row that ...
2
votes
1answer
3k views

What changed between Excel 2007 and 2010 that is causing my copied worksheet save to fail?

When I do this in Excel 2010 this fails, but works in Excel 2007: Create a new workbook and insert an image onto a worksheet, or get a preexisting worksheet with an image. Copy the worksheet into a ...
0
votes
1answer
692 views

Why is Edit->Links disabled when I open my sheet?

I want to use the function to see what other spreadsheets a particular file, says MySS.xls, is linking to. But somehow the 'Link...' is disabled. I have unprotected MySS.xls. Why is it so? How can ...
0
votes
1answer
1k views

Excel 2007: Array formula lookup using INDEX and MATCH is only looking at first row

I have a worksheet, "2011-11", with a series of numbers in column C. The numbers are each in a given currency, identified by a code in column B. What I want to do is write a single formula (in cell ...
3
votes
2answers
15k views

How to break a spreadsheet containing CSV into multiple columns?

I'm working on preparing data for export, and the client has put all of the data into a spreadsheet. Each field of data should be its own column. The problem is that the client erroneously put ...
0
votes
1answer
1k views

How to replace letters in a cell with defined numbers from a separate table

I have a cell which is has mixed numbers and letters(ex. AA12CC45WR) and they are random. On another sheet, I have a table which has the equivalent for each letter like (cells A1, B1) A=1 C=25 W=66 ...
0
votes
2answers
2k views

How do I get Excel to automatically replicate functions across the spreadsheet?

I have a spreadsheet where I'm doing a whole table of calculations. I'm playing with the calculations and seeing what it does to the data. I expect to change the calculations dozens of times (at ...
4
votes
2answers
16k views

AutoFill Large Number of Cells in Excel?

I have a formula in Excel that I would like to autofill to 999,999 other cells. How can I do this without dragging the autofill handle down the entire sheet?
0
votes
1answer
1k views

how to find cells that have a certain text in open office's calc (excel might work also)

I need to calculate averages on my expenses spreadsheet, so I figured out I could do something like this: - get all cells that have the text "electric bill" - get the cell at the right of that one, ...
0
votes
1answer
3k views

Large Number, Abbreviated Formatting

Consider the following scenario. I have a data column that contains a large list of numeric, whole number values. Some of these values are comparatively small (i.e. 1,000) while others are very ...
1
vote
1answer
1k views

Tell Excel to parse cells with units of measurement as numbers, including multiplier

I have some Excel files containing cells with values like "20 mA", "3.13 µA" , "1.66 mV" and similar. Would it be possible to somehow ignore the last character ('A' or 'V') and then multiply the ...
2
votes
2answers
2k views

Change excel encoding

Some ill-written program has exported an Excel file with the wrong Hebrew encoding, with cryptic strings like: ãåç ì÷åçåú äåãòåú åéîé äåìãú Using an encoding-solver site, I found out that the ...
2
votes
1answer
184 views

Testing cell protection for condtional formatting in Excel

In Excel 2010, I want to use conditional formatting (to color the cell) if the cell is protected. Can you suggest the appropriate formula? I think it is IF(CELL("PROTECT").... something, but what?
4
votes
1answer
6k views

Using INDIRECT and AND/IF for conditional formatting

I am having some issues with using INDIRECT to apply conditional formatting. I have column G which carries a percentage. I want to conditionally format column H based on the percentage being greater ...
4
votes
1answer
586 views

Read mail attached excel files

Is there an easy way to data read excel files that are attached in emails in Outlook? Im sure this is scriptable, but I dont particularly want to write it. Is there a program out there that can ...
0
votes
1answer
2k views

Excel x-axis scale [duplicate]

Possible Duplicate: Excel axis problem I jumped from an older version of Excel to the new ribbon interface and am stumped trying to make a simple graph. I have a set of pair values that go ...
0
votes
2answers
261 views

MS Excel percentage of change function

Does Excel have a built-in percentage of change function like (A1-B1)/B1 %? I seem can't find it in built-in function list. Example: A1=1.0123 B1=1.0 I want to get the ratio (1.0123-1.0)/1.0 % = ...
1
vote
2answers
1k views

How to reference Pivot Table's summary field from outside this table?

i.e. I need to make a cell in worksheet show the same value, as summary of my Pivot Table?
0
votes
2answers
218 views

Sorting numbers in Excel 2003 between B1234 and B12345 by inserting a leading zero

I have two series of numbers in the format B1234 and B12345. When I sort in ascending order, I get all the numbers starting with B12345 and then all of those from B1234 on. To counteract this ...
2
votes
1answer
98 views

Using Excel to create a record of my paychecks

Forgive me if this is newbie question, but I am creating a excel document that records the information on my pay stubs. I am trying to calculate the dollar amount for the hours worked during that pay ...
0
votes
4answers
424 views

What is the best way to manually edit and update data within a large table in MS SQL Server?

I have a table in MS SQL server which currently has around 800 records and 20 columns. I want to manually update and add to the information within this table on a frequent basis. Would exporting the ...
5
votes
1answer
345 views

Excel formula needed

I'm not so good in excel but i "think" my problem can be solved using excel.. I've got a column with numbers and i'd like to find the best combination of using these numbers. In our case the best ...
1
vote
2answers
657 views

Filter and reorder columns in Excel

I've got a service (phplist, a newsletter manager) that exports a user list with several fields. At the end of it, each user has one or more lists to which he has subscribed. The problem is, that ...
2
votes
3answers
6k views

Move the Worksheet Tabs in Excel 2010 to the top of the Window

It is standard that when you open MS Excel, the tabs for each worksheet appear along the bottom of the window (as "Sheet1", "Sheet2", "Sheet3", etc). I would prefer those tabs to be on top of the ...
1
vote
3answers
15k views

How do i delete spaces in a cell?

I have a column which is very likely to have 0 or 1 space in the middle of it. I would like to remove it. A1 is the column while these forumulas are in A2, A3 =UPPER(TRIM(A1)) =REPLACE(A2,FIND(" ...
2
votes
1answer
5k views

Export Excel settings to a file

I have customized Ms Excel to my needs, for example I have written small macros and attached them as buttons to the quick access toolbar, made the Developer tab visible etc.) Is there any way to ...
2
votes
3answers
6k views

Right Click on Column or Row does not show Context Menu

I have the following issue: When right clicking in a row or column in Excel 2010 no menu is appearing. In Excel 2003 right clicking in a row lets you insert/delete rows. Do you know if this ...
8
votes
6answers
17k views

How to tell if an Excel cell has a formula or is hardcoded?

Does anyone have a special tip (non-VBA strongly preferred) to tell systematically if a cell has a hardcoded value or is a derived formula? Am dealing with some data that has messy subtotals embedded ...
2
votes
1answer
4k views

How can I turn off calculated columns in an Excel table from a macro using VBA?

I am working on a macro that inserts formulas into a cell in an Excel table. The Excel table does the automatic filling of columns and fills all the cells in that column with the formula, but all I ...
1
vote
2answers
5k views

Is it possible for a macro to open another program?

I am working with a list of 10,000 names, and need to copy info from Excel, paste it into a billing data system, and then paste it into a company data base type system. Next I need to grab some info ...
0
votes
1answer
904 views

Drag down autocomplete date in excel. With AM and PM

Can I drag down dates with AM and PM? 22/11/2011 AM 22/11/2011 PM 23/11/2011 AM 23/11/2011 PM like that?
1
vote
1answer
443 views

Need an event to hook up to for Excel CubeValue refresh

Is there a VBA event I can hook into for cubevalue refresh or update? I'm trying to reconfigure a custom chart axis when the value is returned. I've tried the chart calculate but that doesn't work.
6
votes
2answers
2k views

How to sum cells depending on the content of a neighbor cell

I have an Excel document with the following columns; Date | Reference | Amount 23/01/11 | 111111111 | £20.00 25/09/11 | 222222222 | £30.00 11/11/11 | 111111111 | ...
1
vote
1answer
1k views

How do Excel file ownership and permissions work on a shared network folder?

There is an Excel file on the server, 4 people are accessing it and editing it. At times if the file is already in use, there is weird message that it has been locked by 'user123' and user123 has ...
1
vote
2answers
6k views

Using DSN + 32 bit drivers

I need some advice as I'm running into a problem and so far I have been unable to find a solution. We have a set of reports developed in MS Excel that use a DSN file to connect to data sources to ...
1
vote
3answers
4k views

Convert one column into multiple rows

I simply want to take data from Column A and put it into Column B, Row 1; Column C, row 1 and Column D, row 1. I want to put it into groups of three from top to bottom. For example: Column A 1 2 3 ...
4
votes
1answer
11k views

What excel formula can I use to calculate the 2nd Monday of a given month?

What excel formula can I use to calculate the second Monday of a given month? You can assume I have a cell containing the first day of the month to work with. In the interests of other users, can ...
0
votes
1answer
39 views

Double-Click URL to Follow in Microsoft Excel 2003?

I want to automatically follow a hyperlinked cell when double-clicked, not single-clicked. Can I configure this?
3
votes
1answer
1k views

Random Sampling in Excel

I have an Excel sheet as follows: NO NAME AMOUNT 1 A 50 1 B 50 2 A 100 2 C 100 3 D 70 3 B 70 4 A ...
3
votes
1answer
1k views

Populating cells with data from another spreadsheet after just keying in a few letters

I have 1 workbook with 2 spreadsheets. Spreadsheet 2 column A contains a long list of company names, Columns B - H contain critical information about the company. Spreadsheet 1 contains all of the ...
1
vote
2answers
405 views

How do you add the “local open” button to the quick access toolbar in Excel 2010?

How do you add the "local open" button to the quick access toolbar in Excel 2010? I can see the local open option in the file tab, but I can't find a way to add it to the Ribbon or quick access ...
1
vote
1answer
2k views

autosize excel 2010 comment box when add a lot of text

I'm finding some way to make Excel comment box auto-size when I add a lot of text into it. Some tries with Google and I've got this from Ozgrid but it doesn't work on my Excel 2010. Please help me ...
6
votes
4answers
66k views

Excel extract substring from string

I am looking for a way to extract a variable length substring from a string. My cells will look something like: ABC - DEF ABCDE - DEF ABCD - ABC I want to split the string at the - character, so ...
0
votes
1answer
55 views

How to filter a cell which containing data by other list

Good day all I have a table on a worksheet with two columns (name/ID). each column has a drop downlist data. I want to filter one column by using other drop down list. for example when I choose a ...
0
votes
2answers
301 views

How to send e-mail to customers using quick campaing?

I have a question/problem. I want sent email to my clients using quick campaing. But in those emails I want to put some information for only this customer. For example: First customer - A - have a ...
2
votes
4answers
15k views

Changing data series line weights in Excel chart (many at once)

Is there a way to edit the weight of all lines at once on an Excel line chart? I have a graph with about 50 data series on it, and it's too much to go through all of them and change the weights ...
5
votes
6answers
34k views

How to toggle Scroll Lock in Excel 2010 without a Scroll Lock key in the keyboard

I have a notebook with no Scroll Lock key (or any shortcut using the 'Fn' key). Somehow Excel 2010 got the Scroll Lock on. I see it left down in the status bar and now I can't navigate through cells ...
1
vote
2answers
1k views

How to transpose multiple cells at once in Excel

I have an Excel document such as this, with many listings: Name Address City, State ZIP Name Address City, State ZIP In between each, there is a blank line. How can I convert it to something like: ...