The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**2**answers

38 views

### Excel Highlight Duplicates

I have two columns in Excel 2010. Column B has 180,000 positions and column A has 30,000 positions.
I want to find, and highlight, the items that are repeating from column B, in column A. So I need ...

**2**

votes

**1**answer

36 views

### Move every 3 rows into a column in Excel

Please I need your help. I need to move every 3 rows into a new column. Let's suppose I have this:
Ambassade de France
S.E. M. Patrice PAOLI
01-420000-420150
Ambassade de France
Mme. Jamilé Anan
...

**0**

votes

**1**answer

98 views

### How to change Excel Pivot table column to text format for vlookup purposes

I have a column in my data that is ID numbers, basically. Made a pivot table out of the data.
I'm trying to do a vlookup into the pivot that ignores the first number in the data like so:
...

**0**

votes

**1**answer

70 views

### Excel SUM From Different Sheets IF Date Found

I have a workbook with separate sheets for each product (about 20 sheets, adding more on a regular basis). Each product is only available for a certain time frame, and has daily sales data recorded on ...

**0**

votes

**1**answer

44 views

### Set default expand/colapse state on pivot tables

The Setup
I have a pivot table in tabular form pulling data from an Analysis Services Cube.
I want to calculate the number of days between two dates, but the setup will only allow me to pull in all ...

**0**

votes

**1**answer

27 views

### Top 10 percent number filtering in Excel 2010

I'm really confused the Top 10 Percent how works! I also googled it but didn't find an obvious explanation.
For example, in below table, I click on the Top 10 option (of column Percent) and choose the ...

**0**

votes

**1**answer

80 views

### Excel area chart - y axis and major grid does not match 1 of the 2 series values

Using an area chart to show survey responses as two series with four data points in each. The x-axis are the four answer choices, the y axis is the percentage of respondents.
The problem is the data ...

**2**

votes

**1**answer

88 views

### When importing an Access table into Excel, a look-up column is showing all values as numbers

I have a basic Access to Excel question that has me frustrated.
I have two Access 2010 data tables. One is a list of managers. The primary key is a manager ID (which is an autonumber because managers ...

**0**

votes

**1**answer

37 views

### “save the changes” message after removing the protection from workbook Excel 2010 [duplicate]

Some time ago I protected the Excel 2010 file from the path File > Protect workbook > Encrypt with password and gave it a password. Now that I removed that password via below method:
Open the ...

**1**

vote

**0**answers

36 views

### Weird Excel 2010 VBA Window Behaviour

If I open Excel and then open the VBA window then close it, every time I RDP to my computer, the VBA window is open again, even if I closed it before disconnecting.
The next time I am sat locally to ...

**0**

votes

**2**answers

21 views

### Copying filtered table doesn't work as it is expected in Excel 2010

I have a small table and want to copy it after filtering. The image is in below,
and I have filtered it to shows only the red font color of the column "Days" as follows:
Now everything is ready ...

**1**

vote

**1**answer

39 views

### How can I split Excel data from one row into multiple rows

Good afternoon,
Is there a way to split data from one row and store to separate rows?
I have a large file that contains scheduling information and I'm trying to develop a list that comprises each ...

**1**

vote

**1**answer

39 views

### How to reference a row except some cells(to find maximum value from rest of the row)

This (Excel: How do I reference an entire row except for a couple of cells?) question has title of what I want. However text and answers are about finding range in a column..
Detailed question.
I ...

**0**

votes

**1**answer

79 views

### VBA Solution to VLOOKUP with Hyperlinks

I am looking for some help with a VBA solution for preserving hyperlinks when using VLOOKUP on Excel (2010).
I have a load of data on Sheet 1 for internal use only, and a cut-down version of this ...

**0**

votes

**1**answer

144 views

### Excel 2010 Move data from multiple columns/rows to single row

So frustrating! I get data sent to me and it looks like this:
a 1
a --2 2
a-------3 3
b 1
b-- 2 2
b ------ 3 3
b------------ 4 4
b-------------------5 5
...

**0**

votes

**1**answer

21 views

### excel if statement error words + formula

Excel is giving me an error for the third part of my if statement:
=IF(B37>=(2*B36),(C37/(B37/B36)),"take from tube 1" (C37/(B37/B35))
It seems to dislike the combination of words plus a ...

**0**

votes

**2**answers

36 views

### My questions about custom sort window in Excel 2010

I use MS Excel 2010 on my Win 7 machine.
In my table, when I use custom sort there are some odd thinks for me.
1- The "My data has headers" is always gray and when table has header it's checked ...

**0**

votes

**1**answer

26 views

### Windows 7 Enterprise, Service Pack 1. Software MS Office Excel 2010

In Excel I understand there is no mechanism to customise & re-label the Rows & Columns (i.e. Renaming Col. A to some text like "Item Number" and so on.
My question is regarding if it's ...

**0**

votes

**3**answers

44 views

### Fill rows down quickly (column or matrix of zeros)

I have an extremely basic question, but I have never found the answer by searching the internet. I simply want to create a large column of zeros with Excel.
Sometimes I want to create a huge ...

**5**

votes

**0**answers

111 views

### Excel spreadsheet undoes/reverts to previously saved state

A very unusual problem hunts my colleague
From time to time when she works with Excel 2010 (numerous workbooks, some of them quite large), the computer "decides" to undo everything that was done since ...

**1**

vote

**1**answer

79 views

### Hide/Unhide rows based on more than one cell value

Please help me
I am using the following code to hide rows if cell values are 0:
Private Sub Worksheet_Calculate()
Dim LastRow As Long, c As Range
Application.EnableEvents = False
LastRow = ...

**0**

votes

**3**answers

33 views

### How to best do foreach together with count in excel

I have been trying to do some work in excel, but i seem to be stuck on one point
in colum "A" i have: a, b, c, d, e
in colum "B" i have: done, started, completed
in colum "C" to colum "S" i have: ...

**3**

votes

**2**answers

116 views

### Highlighting Cells in Excel based on the Value Associated with the Cell

I have two sheets:
Users in their respective groups and
A compilation of those same users with an expiration date.
I'd like to highlight any cell in the the first sheet if their respective date ...

**0**

votes

**1**answer

10 views

### Set Excel 2010 save location to most recently used (“saved to”) folder

I'd like to save related excel 2010 documents to the most recently used folder. Is this possible? Excel 2010 defaults to a libraries folder, and extra searching is required to save to the desired ...

**1**

vote

**2**answers

76 views

### Importing an XML file into excel

I have a multilevel XML file. When I import the XML into excel, it creates multiple columns for the multilevel data. However, I need the multilevel data as additional rows.
Is there any way I can ...

**0**

votes

**1**answer

76 views

### How to re-arrange Excel database from 1 long row, into 3 short rows and automatically repeat the process?

I would appreciate help on the above-mentioned topic.
I am unfamiliar with Visual Basic for Excel, so will need step-by-step guidance (if solution is via Visual Basic).
For example :-
Row 1, Sheet A:
...

**1**

vote

**1**answer

141 views

### Data Validation of a Comma Delimited List

I need a simple way of taking a comma seperated list in a cell, and providing a drop down box to select one of them.
For Example, the cell could contain:
24, 32, 40, 48, 56, 64
And in a further ...

**1**

vote

**1**answer

63 views

### Excel 2007 or 2010 copy/paste without merging cells & with shift all down

Let say I have an excel sheet with structure like
I select a few cells (at one column) and click Ctrl+C. After that I want to paste it. I select one cell(B116):
And click Ctrl+V. It gives me ...

**0**

votes

**1**answer

54 views

### Excel: formula to fill text data from sheet based on condition?

So, here's the situation. I have a workbook with several sheets. I've got one with a list of companies and their data (Tax ID, address, city, etc.) and another - working one. I have a cell with a ...

**0**

votes

**2**answers

44 views

### Form controls change position and size even when locked

I'm having an issue with a spreadsheet in Excel 2010 where I'm experiencing that the form controls sometimes change position and/or size. This happens even though the controls are "Locked" and the ...

**0**

votes

**1**answer

63 views

### How to add space inside multiple cells in Excel 2010

I would like quickly insert or add space to the beginning of text in multiple cells (rows) simultaneously. Is there any formula to do so?

**2**

votes

**1**answer

19 views

### How do i add a running total in A1 to B2 if there is a value OR subtract from C2 if there is a value

What I am trying to accomplish is that when I enter a number in B2 it will only subtract,
A1-B2= A2 but if i put a number in C2 and nothing is in B2 I want it to add A1+C2=A2. I really tried looking ...

**1**

vote

**1**answer

29 views

### Total row doesn't work properly, Excel 2010

In my Excel 2010 file and in one of its sheets I have a small table. As following, when I checked the Total Row option in Table tools > Design > Table style options > Total Row the tabled appeared as ...

**3**

votes

**1**answer

187 views

### Add/Subtract button Excel VBA

Here is an example of my project in this picture
I like collecting, so I am making an inventory sheet in Excel.
I want to make a way that I can click a button and it affects the next, or previous ...

**0**

votes

**2**answers

141 views

### Print preview doesn't work properly in Excel 2010

First I made some contents and drew a border from Home > Font > all Borders on an Excel 2010 file. So it became like below image (capture1). After that I wanted to print it so went to File > Print to ...

**0**

votes

**1**answer

33 views

### First column stripe doesn't work in excel 2010

I have below table in an Excel 2010 file. I want to design a new table design for that from path: Design > Table Styles > New table style. Then I create one, named "Table Style 1". Then I choose ...

**0**

votes

**1**answer

26 views

### Using Parallels, Win 7 and Excel 2010— Excel restores itself immediately after being minimized

I'm using Excel 2010 in Windows 7, through Parallels on Mac OS X. Some times, when I go to minimize Excel, after the minimization animation, Excel immediately restores itself.
How can I fix this ...

**0**

votes

**2**answers

369 views

### Searching for a value in Excel, returning yes or no

I have one workbook, with two separate worksheets. I want to know if the values that appear in worksheet B also appear in worksheet A, if so, I want to return a "YES". If not, I want to return a "NO". ...

**0**

votes

**1**answer

56 views

### Excel - Sum certain range from pivot table

I have an excel pivot table that looks like the following:
Is there any way I can create a formula that will calculate the sales$ for a particular product at a particular store for a particular ...

**0**

votes

**1**answer

51 views

### Delete extra slashes in Excel worksheet?

I have a very long spreadsheet with thousands of lines like this:
new-dept/Tax/Affiliate/logs/Final//////
Due to some Text to Columns, I ended up with multiple slashes at the end of every line, ...

**0**

votes

**0**answers

80 views

### Listing/grouping variables in pivot table field list

I have data with 60+ variables and I would like to group the variables into different collapsible fields in pivot table similar to having different tables in the pivot field list instead of having all ...

**0**

votes

**1**answer

26 views

### Creating a list (B) in Excel based on whether there are quantities in a cell next to an item in list (A)

How can I create a summary list of items and quantities based on whether or not there is a value (quantity) in a cell? If I have a column A with a Master List of 500 items and there is a neighboring ...

**0**

votes

**0**answers

50 views

### Use Excel to query Sybase database

Excel offers the ability to connect to external data sources. I am told I can connect to a Sybase database to import some data into excel from a query.
How do I do this? I have the following:
Query
...

**1**

vote

**1**answer

58 views

### Minimum and maximum speeds in Excel

I have a sheet that contains the distance driven and the time. These are in columns B (distance) and C (time). Calculating the average speed is simple. Sum the distance and the time and divide the ...

**0**

votes

**0**answers

30 views

### Copy Excel workbook with a pre-configured DSN to other computers

I am working on one Excel 2010 report using one workbook with a few worksheets. The first sheet has a field to enter a number and upon update it passes that number to a stored procedure in SQL server, ...

**0**

votes

**1**answer

24 views

### Define names in workbook scope

I use MS Excel 2010. In this app, I know that using Formulas > Define names > define name it is possible to name a cell (or range).
At that dialog box there is a scope rectangle which if I choose the ...

**1**

vote

**2**answers

47 views

### Copy selected items in Excel filter

I have been strugling for past several day trying to resolve this issue. Here is what I have and what's needed:
I've got about 20 Excel sheets that contain massive data (around 50K rows/sheet) that ...

**0**

votes

**1**answer

30 views

### How to change the themes of a specific range in an Excel file

I know how to change the themes of the entire worksheet in an Excel file: Page Layout > Themes > Themes. But how to change the theme of a specific range (not all the worksheets/workbook) in a ...

**0**

votes

**0**answers

34 views

### Why does one Excel file respond to changes slower than others?

I have a Excel 2010 file with 5 worksheets. Each one has very little information with little formatting. At the beginning, it was very fast when saving data (e.g., when inputting a number or text into ...

**0**

votes

**0**answers

35 views

### Why can't I change the table size in Excel (large data set)?

I have an Excel 2010 file with multiple sheets. The first two sheets work as data source for many pivot tables which contain calculated fields.
The problem is the first sheet of my workbook is a ...