**0**

votes

**1**answer

2k views

### Freezing/fixing cells into position?

I have a lookup section to the right of around 6 sheets on my Excel document, all different - I'd like to have them fixed in position, so for example cells L2 to P19 would show up no matter how far I ...

**1**

vote

**1**answer

418 views

### Excel CSV: how to keep 0 before decimal: e.g. 000.11 instead of 11

When I open a CSV exported from sqlite, excel erases the zeros which are codes. How can I keep the leading zeros?

**1**

vote

**0**answers

98 views

### When Calculate is set to Manual, calculation still occurs

If you write in some arithmetic formulae interdependencies across several cells, they still update in responsive real time when an independent variable is changed, even if Formulas!Calculation Options ...

**1**

vote

**1**answer

4k views

### Consistantly insert rows from top of page in Excel

I am trying to setup a workbook that will contain many rows of data. In order to keep things chronological I would like to consistently (or always) insert a new row of data at the top of the ...

**1**

vote

**1**answer

532 views

### Show date format in Excel as the OS default

Is there a way in Excel (2007 and up) to set the date format of a column to the date format of the OS locales. The data entered in this column is a date (imported from a database date field).
For ...

**1**

vote

**0**answers

354 views

### VBA code not refreshing external query

I have a small Excel file with VBA. We use the task scheduler in Windows to open this small file which then runs a macro to open, refresh, and save various reports that we have automated. The file ...

**0**

votes

**2**answers

4k views

### Excel Line Graph with columns and rows transposed

My team has a spreadsheet in which we track counts of incidents of known issues from week to week. The sheet is organized with the issue title in column A and "Week 1" through "Week [N]" in columns B ...

**3**

votes

**1**answer

3k views

### Transferring Conditional Formatting (without the cell value) in Excel

If I have 3 layers of conditional formatting in a cell (B2) is there a way of transferring the format of cell (B2) to another cell (A2) without copying across the value in the original cell (B2).
...

**4**

votes

**3**answers

6k views

### How can I split Excel data from 1 column into 8 columns while keeping the data in a specific order?

I need to maintain the order of the data. So to explain I need to move the data from cell
a1 to b1,
a2 to c1,
a3 to d1,
a4 to e1,
a5 to f1,
a6 to g1,
a7 to h1,
a8 to i1,
a9 to B2
a10 to C2
a11 to ...

**5**

votes

**1**answer

761 views

### Excel open option missing from Context Menu

Whenever I select multiple Excel (2010) files the right mouseclick option 'open' disappears. When I select just one or a few files there is no problem, but from 15 or more files I can't open them at ...

**1**

vote

**1**answer

8k views

### Count the quantity of unique combinations of multiple columns in Excel

I have two columns in a spreadsheet, and I need to write a formula to determine how many times each combination shows up. Example:
A 1
A 1
A 2
A 2
A 2
B 1
B 1
B 2
Should result in:
A 1 2
...

**0**

votes

**2**answers

746 views

### Excel 2010 formula conversion to Excel 2003

I am by no means overly proficient with Excel, I know enough to do the basics.
After much forum and soul searching I had come up with the following formula, which I will discuss what it is supposed ...

**0**

votes

**0**answers

20 views

### How to apply Conditional Formatting to a row of data if a certain cell is blank [duplicate]

Possible Duplicate:
Conditional formatting to highlight the whole row
Here's the problem I am facing:
I want to highlight A1:M1 if L1 is blank, A2:M2 if L2 is blank, A3:M3 if L3 is blank, ...

**4**

votes

**2**answers

3k views

### Excel - Sorting fails to move data validation rules along with data

When sorting a table or range in Excel, the cell values and basic formatting like bold, italic, colours etc. move, but the following things do NOT move:
Borders
Data validation rules
My ...

**7**

votes

**4**answers

40k views

### Dynamically reference a Named Table Column via cell content in Excel

How do I reference an Excel Table column dynamically in Excel 2007?
ie: i wanna reference a named column of a named table and what table it is will vary with the value of a cell.
I have a Table in ...

**3**

votes

**1**answer

818 views

### Strange Excel IF formula evaluation

In a particular strange workbook,
In cell A1, I key the value 0
In cell A2, I key the formula =IF(A1="APPLE", 1, 0)
The result in cell A2 gives 1.
I tried to replicate the same in a new workbook, ...

**1**

vote

**2**answers

5k views

### How to insert a table into a header in Excel 2010?

Is it possible to create a table in the header of Excel 2010?

**1**

vote

**1**answer

3k views

### Finding non blank cell then in same row if another cell is blank then return value of another cell

I have three columns. "Site ID" with a value, "Ready" with date and "Installation Completed" with date.
Now I want that I search whole column B for non-blank cell, if I found then it checks column C ...

**1**

vote

**1**answer

814 views

### Focus last modified cell when opening Excel

When I open an Excel file with a large number of cells, I want it to focus the last modified cell, i.e., the last cell in which I entered/changed data the last time I used Excel.
How can I ...

**1**

vote

**0**answers

192 views

### How do I connect a checkbox to include more than one cell of data?

I'm working on a matrix where you can compare products and their options to one another. I've created a macro linked to a data table in my workbook (titled portables). When you click the check boxes ...

**5**

votes

**3**answers

4k views

### How to calculate a sum of cells based on a certain value in another cell

I'm responsible for creating the monthly metrics for the Helpdesk team that I'm on. I'm using Excel 2007. One report that I'm responsible for creating deals with tickets that we had to return to the ...

**1**

vote

**2**answers

653 views

### Excel formula - Absolute reference to cell

In my excel 2010 worksheet, I have entered a formula =+H8+N8*AA7 where AA7 is a permanent number where as H20 & N20 will change.
But if I copy this formula to the below row, it pastes as ...

**1**

vote

**2**answers

953 views

### Repeat cell content from top to bottom in a sheet

I was wondering if there was, and I bet there is, an easier and faster method for an issue I have when working with a certain kind of Excel sheets.
At my work, I’m working with 2 or 3 different and ...

**0**

votes

**1**answer

773 views

### Is there an easy fix to this copy/paste into Excel error?

When I attempt to paste a large spreadsheet (from a DB, ~90,000 rows) into Excel, I keep getting this error:
Microsoft Excel is waiting for another application to complete an OLE
action
I ...

**1**

vote

**1**answer

320 views

### Search for data in Excel 2010 that can be anywhere in a column

I am attempting to search for data anywhere in a column. I have the following formula but I think I need a wild card. My data may be in cell J2012 instead of J2. Suggestions?
=IF( ...

**4**

votes

**1**answer

3k views

### Excel 2010 conditional formatting: selectively highlighting duplicates

I'm using Excel 2010 and would like to know if there's any way I can choose conditional formatting to highlight only instances of duplicates when it's found in ALL the columns I chose?
For instance, ...

**0**

votes

**1**answer

743 views

### Excel - multiple workbooks, same data to edit

I have 2 workbooks in Excel, each containing a worksheet with a list of board members. I want to be able to link these two lists somehow, such that if I edit the list in one workbook's worksheet ...

**1**

vote

**1**answer

953 views

### Referencing a single row to multiple rows in Excel

I have a worksheet with a list of sales, one sale per row. In order to import this data into my accounting software, I need to create a separate worksheet that formats the data differently. Each row ...

**3**

votes

**1**answer

4k views

### Importing specific date format to Excel from Microsoft SQL Server

I've already asked the question at: StackOverFlow and got sent to this place here.
I'm importing dates from a German SQL Server table into a German Excel file via the built-in Excel connection tool.
...

**2**

votes

**2**answers

15k views

### Excel 2010: Colour cells in a column based on values in another column

I need to do the following in Excel 2010
Colour a column based on another columns value
For example,
Status Balance
Green 0
Red 25
Red 60
Green 0
The 'Balance' is ...

**1**

vote

**1**answer

640 views

### Automation on Opening CSV file in Excel

I have often to open CSV files in Excel (14.0.6112.5000; Office 2010). The data is filled well in the columns, but the DateTime values exceed the default column with and are display as ######. So I ...

**1**

vote

**1**answer

2k views

### Excel array formula for max with multiple/ variable criteria

G'day there,
I have a sheet that contains 365 rows, representing dates from a referred Start Date (for the following year). There are about 30 columns each of which has an agency name.
The cells in ...

**1**

vote

**6**answers

17k views

### duplicating a row in excel

i have a large financial spreadsheet with a ton of formulae. i'd like to duplicate a row such that it retains the same formula and coordinates as the source row (basically duplicate a summary row and ...

**2**

votes

**0**answers

305 views

### How to setup a CSV web datasource

In Excel, I can import a CSV from the web as text by simply pasting in the URL as a file name, but when I ask Excel to update, it has stripped the URL and tries to find a file on the local hard drive ...

**3**

votes

**2**answers

91 views

### Sending Excel data

I would like to send an e-mail message to a lot of users attaching on it some personal data, like passwords, that cannot be sent to others.
The users and personal data are organized on columns on an ...

**32**

votes

**2**answers

45k views

### How to search for ? (question mark) in Excel

When I try to find the question mark character (?) in an Excel sheet, Excel cannot locate the cells containing them. How can I search for ? in Excel?

**1**

vote

**1**answer

9k views

### Starting and ending dates from week number

Can anyone teach me how to use formula in Excel 2007 to find out the starting (beginning from Monday) and ending (ending on Saturday) dates based on week number? eg. week 32 of 2012 is from 06th ...

**1**

vote

**4**answers

40 views

### How to input `---++` in cell

I want input ++-- in cell excel but error
How to input the ++-- or ---- as shown above.
Thanks

**1**

vote

**1**answer

56 views

### Excel working with mouse

I am using excel 2007. When I have put dates in the "A" column, I have to write all the dates way down to 31st of the month. While using the mouse, one can write the first date of the month & then ...

**1**

vote

**2**answers

558 views

### How do I highlight rows based on latest time stamp in Excel?

I have 4 columns, A B C D.
Column A has a designed value.
Column B has a reviewed value.
Column C is empty.
Column D has a formula which returns false if value in column A does not match value in ...

**1**

vote

**1**answer

88 views

### Excel - generate from pattern?

Is there some sort of mechanism in Excel that lets you create data using a specific pattern? Something like a regex that does all the possibilities.
For example:
NET[0:31]_[P/N]
Would generate
...

**1**

vote

**1**answer

590 views

### Automatic sort for excel worksheet

I want to create a to-do list in Excel that automatically sorts the to-do entries in a list, in order of ones to do first (closest deadlines). I would also like a section that shows the tasks for ...

**2**

votes

**1**answer

191 views

### Custom area graph in Excel (or google spreadsheet)

I am trying to visualize my loans with area graph and have some additional needs/wishes.
For example - this is my data (made up):
house car mower vacation
diners ...

**2**

votes

**1**answer

2k views

### Word 2010 - Mail Merge with Superscript Formatting

I have a user with a letter in Word 2010, built for a mail merge. The source document for the addresses is another Word document. The source document includes addresses that have super-scripted ...

**0**

votes

**1**answer

648 views

### importing data from one excel sheet to another?

I am having 2 datasheets in one excel file. i want to import complete columns from one datasheet to another.
Remember i have to import complete columns like column a, b, c etc.
Is there any way to ...

**0**

votes

**3**answers

3k views

### Create a hyperlink from URL and title in Excel

I'm trying to construct a hyperlink from a URL and a name in different cells.
a1 = http://www.example.com/
b1 = example
c1 = <a href="http://www.example.com/">example</a>
What I want ...

**0**

votes

**2**answers

223 views

### How do I add a value to a cell in Excel if it's an int?

I have an Excel table with some cells that are numbers and some cells that are strings. I want a function that can add search through the table, and if the cell is a number, add it(+) and if it's a ...

**1**

vote

**1**answer

301 views

### fill values in excel according with dates

I have a challenge in Excel 2010. I have a list of IDs with the following variables: issue_date, cumulative value, maturity date. Each ID has different issue date and maturity date, but all of them ...

**2**

votes

**0**answers

532 views

### Excel Pivot Table with external Data Source parameter is not saved with workbook

I have a pivot table in an excel 2007 workbook that links to an external data source. The query is along the lines of "exec procedure @param=?" (using an ODBC connection to sql server 2005). I am ...

**1**

vote

**3**answers

2k views

### Automating data from an Excel file and interacting with browser

How can I automate copying records from an Excel file or CSV and interacting with a browser?
Example Task:
Extract or Copy record(s) from an Excel file row
Go to a URL (probably using Google ...