The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

1
vote
1answer
13 views

Excel chart: Poor plot of a straight horizontal line, due to settings that use “Major Unit: Fixed” for the vertical axis

I have a table of data that is the source for a chart. I import different data into the table often to plot it in the chart. In the settings for vertical axis, I selected "Major Unit: Fixed (at 1.0)", ...
-3
votes
0answers
10 views

Have data from one worksheet auto populate different tabs

I have a large spreadsheet data twenty columns, hundreds of rows. In column A, I have many sub categories. I sort by sub category and then cut and paste each sub category into a separate tab. The ...
3
votes
1answer
17 views

Freeze multiple columns in excel using macro

Under the Freeze panes, Excel currently offers Freeze panes, Freeze first row and Freeze first column options. I was looking for an option where I can freeze the first N-columns. I did a record macro ...
0
votes
1answer
11 views

Turn off automatic display of properties

In my workplace, any time I open an Excel sheet (Office Professional Plus 2010) the "Document Properties" or "Other Properties - Server" docked dialog appears at the top of the document, dominating a ...
0
votes
1answer
16 views

Date values displayed as numbers instead of dates

Whenever I type a date into one of my worksheets the cell displays the value as a number not a date. The cell's value is a date and the format is date but the text displayed is a number. ? ...
0
votes
0answers
8 views

Show the filtered name from a list in a different cell

I have a table of data. The field headers are: Date, Name, Result, Running Avg. From this data, I have created a graph. I want to filter by 'Name' and the graph will show only that Name's Result ...
-1
votes
0answers
14 views

How can I list the highest repeated pair of numbers from 47 million pair of numbers in MS Office Excel 2010?

How can I list the highest repeated pair of numbers from 47 million pair of numbers in MS Office Excel 2010? The highest repeated pairs will be around 400 000 to 600 000.
1
vote
1answer
34 views

Excel 2010 VBA to Hyperlink Active Cell to itself, so it would lead to it's exact location from when that cell is pasted and sent in Outlook e-mail

Objective: Excel 2010 - VBA to Hyperlink Active Cell to itself, so it would lead to it's exact location on spreadsheet from when that cell is pasted and sent in Outlook e-mail. I need to keep the ...
1
vote
1answer
42 views

Excel : how to put a literal dot into a cell format

Whenever I put a dot character into a custom cell format Excel will interpret it as if I want a decimal separator in that location of the format. The problem being that decimal separator changes with ...
1
vote
1answer
16 views

How do I take the information from 1 spreadsheet and count it on another spreadsheet based on a set range of values?

I have 2 spreadsheets in the same work book. On the first, I have dates names and others values (y/n, amounts). I need to be able to put in a date range on the second spreadsheet and have it take data ...
0
votes
1answer
26 views

Excel issue with =MID()

I pull a report, In Column B it has about 125 words, 1100 characters including spaces. I wrote a =mid() Formula which pulls the server name out of the text without an issue. =MID(B2,FIND("Old ...
5
votes
2answers
29 views

How can I add / upload bulk entries to Excel 2010 Autocorrect?

I currently have about 200 entries of autocorrect but it's painful to add one by one manually to "autocorrect" (File > Options > Proofing > AutoCorrect Options > AutoCorrect tab). These entries are ...
0
votes
0answers
4 views

Is it possible to autofit a resized row with wrap text?

I want to autofit a resized row that is wrap text enabled. It is wrapping the text but it is not autofitting. Is it possible to auto-fit a resized row (without VBA)? I resized the row to 30 pixels ...
0
votes
0answers
22 views

Exteremly Slow Microsoft Excel operation in LENOVO G550 series Laptop; Shall I add more RAM?

I am doing complex Macro operations in Excel 2007/2013 which generates random numbers and does many multiplications/divisions in each cell value. It also copies data to multiple worksheets and text ...
1
vote
1answer
28 views

How do I create a cascading drop down link in Excel?

I want to create a cascading drop down link in Excel 2010. My requirement is when we click when we select any color from dropdown list related color fruits will displayed beside.
0
votes
0answers
23 views

Macro to copy distinct values to another sheet, based on value in another cell

I'm using MS Excel 2010. My data set consists of a list of calls performed by employees of three different companies. My workbook has one sheet (let's call it "Sheet1") where each row corresponds to a ...
0
votes
0answers
9 views

How to unhide rows, when Format, Visibility, Unhide doesn't work?

All I did was highlight rows 29,30,31,32 I then right clicked and selected Hide Rows. Now I want to unhide them. But nothing seems to work. I've tried the following: Placing my cursor between ...
0
votes
2answers
36 views

IF statement with multiple criteria and multiple possible results

I have a spreadsheet and I need a formula to give me one of three possible results (good, neutral, bad) based on data from two cells. MTD and YTD on budget would be good, MTD on budget & YTD below ...
0
votes
2answers
24 views

Microsoft Excel 2010 the difference between two times in two different cell

Other answers helped but have a problem with the following Start Time 23:56 End Time 0:32 difference is 36 minutes. Start Time 21:53 End Time 22:05 difference is 12 minutes. What formula can I use ...
0
votes
0answers
21 views

Is it possible to share a hyperlink in en outlook email to a specific excel worksheet?

I have an Excel workbook which I can shared by sending a hyperlink to this file by e-mail. But I do not just want to share the file, but link specifically to a certain worksheet. I know that linking ...
1
vote
1answer
30 views

Grand total of calculated field of pivot table

My pivot table summarizes the total number of items sold and calculates commissions, say: ItemA 15 $150 ItemB 6 $30 ItemC 9 $45 Total 30 $300 I want to calculate commission to salespersons: For ...
0
votes
2answers
31 views

Fill cell with sheet name Microsoft Excel

I have an excel file which has around 100 sheets in it. Each sheet is for a student, and each sheet name is the firstname_lastname e.g Mark_Hope so what I want to do is that in each sheet there are ...
0
votes
1answer
12 views

Export multiple (specific) worksheets to CSV files in a specified directory

I'm new to VBA. I'm trying to do the following but the code isn't quite working as expected. Export/Copy particular sheets in the workbook (any sheet name that contains "Upload") to a particular ...
0
votes
0answers
25 views

Filter Unique values in Columns or Cell Ranges from Multiple Worksheets in an Excel Workbook? [on hold]

Excel 2010: Filter Unique values from Columns or Cell Ranges from Multiple Worksheets in a workbook? Essentially, combining data from the 3 cell ranges/ columns in multiple worksheets Then filtering ...
0
votes
2answers
34 views

Combine Excel tables

I need to combine two excel tables(Table 1 & Table 2) to result as Table 3. New week column will be added every week with new data. The Table 2 could be added to Table 1 or can be combined into a ...
0
votes
1answer
34 views

Need macro to transfer Word data into Excel

I am very new to VBA and need help ! I have VB macro in Excel that grabs the data from a Word document and imports it into Excel worksheet. Currently, the code in macro has expression that clears the ...
0
votes
1answer
37 views

Group values in Excel

I have 500 rows of items. I need to enter these in an application where I can enter a maximum of six items at once by creating a unique Group ID for these six items. The items in a group share the ...
0
votes
2answers
22 views

How do instruct a cell to display a minimum value?

I currently have the following formula in a cell:- =CEILING(E9*0.85, 1.25) I would like the cell containing this formula to display a value no less than 20 but only when the value of E9 causes ...
0
votes
0answers
7 views

getting formulas to update correctly

I have one main spreadsheet (call it A)that imports totals from 2 other spreadsheet (call them B & C) every so often I have to enter new names and delete old names on Spreadsheets A,B,C. How do I ...
0
votes
1answer
20 views

Combining 2 named ranges into a single series line chart in Excel 2010

How do I combine 2 named ranges into a single series. I have months on the X axis and average hours per month YTD on the Y axis. I want to separate the average hours into financial years i.e. the ...
0
votes
1answer
19 views

How to copy range from an unactive workbook

I'm simply trying to copy and paste between workbooks in VBA without first activating each workbook that I want to perform actions on. My code stores the active workbook and sheet in variables before ...
1
vote
1answer
26 views

Compare efficiency of excel formulas

Is there any way to directly compare for calculation efficiency side by side two different formulas for achieving the same goal in excel? Say I want to know which is more processor intensive (or if ...
0
votes
1answer
33 views

How do I set a dropdown in excel to populate different data in cells below based upon the option selected from the dropdown?

I am attempting to clean up a spreadsheet that we have that tells us what permissions to grant for certain roles in our ticketing system. I have used the Data Validation tool to create my dropdown ...
0
votes
2answers
29 views

Excel removing my last significance digit

I am building from external data a table where columns can have one or two decimal numbers. For one decimal number I want 1.0 instead of 1 and for two decimal numbers I want 1.40 instead of 1.4 The ...
0
votes
1answer
14 views

How to create header in MS Excel?

How to create header in MS Excel? So they will not move while I am scrolling the page and will not be affected when I am sorting any column. Till now I use: select row, go to View > Freeze Panes > ...
0
votes
0answers
13 views

Split single spreadsheet into multiple sheets based on highlighted values in three different columns

I am using Excel 2010. I have a single spreadsheet with 10 columns, the last three columns (for instance L, M and N) having conditional formatting, i.e. highlights a minimum value among three. I want ...
0
votes
1answer
34 views

Excel - How to check if and in how many rows a certain value/string is present in range

I have a list A of strings and I want to see if and if yes in how many rows each string is represented in range B. My data looks something like this: List A: aaa bbb ccc Range B: 1 aaa --- --- ...
1
vote
2answers
45 views

Reducing rows in column to match another column in Excel

I have two columns in Excel of the same type of variable called Reduced Store Numbers and Original Store Numbers. Reduced Store Numbers has fewer rows than `Original Store Numbers. I want Original ...
0
votes
0answers
15 views

Save filter options, specifically on a Pivot table, without copying the table

I have a bunch of data summarized in a pivot table that gives me a list with multiple filters. Normally, at this point I would paste the whole list as values, before then selecting other filter ...
4
votes
1answer
371 views

Does Excel always calculate hidden rows?

If I have Excel sheets with long filtered lists, and I recalculate while a filter is applied, when I remove or change filters, can I always guarantee that Excel will have already calculated all hidden ...
0
votes
0answers
30 views

Create unique and similar list among three columns in MS Excel

I have a dataset from three different sources of the same variable that needs to be consolidated. The three columns need to be combined into one based on similar rows. Three more columns need to be ...
0
votes
0answers
15 views

Macro Issue Microsoft Excel 2013 [on hold]

I'm currently having trouble with Excel 2013 (Recently upgraded from 2010) Issue is when running a macro in any sheet it stops me from using any other sheet ie. inputting data into another sheet ...
0
votes
1answer
16 views

Putting certain values at the bottom of sort in excel

I have a table that counts the win percentage of players, looking like this: name games score percentage name1 6 3 50 name2 10 8 80 name3 2 2 100 ⋮ ...
0
votes
2answers
28 views

Adding time in Excel, for a bus timetable

I am constructing a bus timetable. I am starting with a base time of 9am (Cell B2), with irregular intervals: 09:05-Cell B3 09:12-Cell B4 10:14-Cell B5 10:20-Cell B6 When the bus comes back to ...
0
votes
0answers
20 views

Formulas suddenly become text

I've been working on an extensive Excel list with cell references between sheets and it's been working like a charm, up until now. There is this one cell that refuses to acknowledge that I have ...
0
votes
1answer
14 views

graph of computed averages requires data in all cells

I am using Excel 2010 and have created a spreadsheet that allows me to enter questionnaire responses from patients every week and display their average scores for each week on a line graph. Ideally, I ...
1
vote
1answer
31 views

Excel: Checksum-like function to check if table copied correctly

I have the following scenario: I have a spreadsheet A with a large table. I open spreadsheet B and copy the table from A into it. I want to check if I copied the table from A to B correctly. In ...
3
votes
3answers
79 views

How to make Excel chart intelligently select data

I got a set of memory usage that I am trying to plot on Excel. I got time, total RAM, used RAM, used SWAP and free SWAP each with its own column. But if I select all of columns for a line chart the ...
0
votes
2answers
24 views

Excel not to start calculation on Automatic mode if data is put wrong

I want excel to stop calculation if invalid date is put. I tried to use "data Validation" using below formula =AND(ISNUMBER(E3),LEFT(CELL("format",E3),1)="D"). It is working but the calculation don't ...
1
vote
1answer
33 views

How can I write only certain rows of an Excel worksheet to CSV?

I have created an Excel (2010) workbook that takes information from various CSV files and puts them into a format that can be understood by my office's scheduling program. Using a macro I found ...