**0**

votes

**2**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**2**answers

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

**1**answer

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

**4**answers

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

**1**answer

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

**2**answers

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

**3**answers

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

**3**answers

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

**1**answer

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

**3**answers

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

**6**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

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

**3**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**4**answers

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

**1**answer

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

**2**answers

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

**4**answers

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

**6**answers

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

**2**answers

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:
...