The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
3answers
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
0answers
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
1answer
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
3answers
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
2answers
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
2answers
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
1answer
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
0answers
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
0answers
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 ...