The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
1answer
4k views

Excel 2010: dynamic update of drop down list based upon datasource validation worksheet changes

I have one worksheet for setting up the data sources of multiple data validation lists. in other words, I'm using this worksheet to provide drop down lists to multiple other worksheets. I need to ...
1
vote
2answers
16 views

Show timestamp when cell is changed

I need to know how to show a timestamp in a cell in column D when a cell changes in that same row in column B. I edited this screenshot in paint to show what I mean more easily: The image I have a ...
0
votes
1answer
18 views

Adding a Scrollable Directory to a website built in Word 2010

First off, yes, I do know that Microsoft Word is not ideal for building a website. But my client is insisting on it since they want to be able to edit it later on their own and this is the software ...
1
vote
2answers
1k 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 ...
2
votes
1answer
32 views

MySQL for EXCEL (2010) - Custom select query

I have the MySQL for Excel (MS E:2010) addin enabled (most current version). I've tested my connection to my server (non-local), and all is great, however I can't see anywhere to write / insert a ...
0
votes
2answers
157 views

Strategy for Incremental Datasource fetchings in Excel

I am in an scenario with a table that is refresh by a third app every week. I need to keep accumulating all data in Excel, using an ODBC connection to the database. I am wondering Approach 1: Is ...
0
votes
1answer
14 views

How to make a Custom List with sheet cross reference?

At the end of the month i get a excel file with a variable number of sheets. Every sheet has a value in the same cell: A1 I want to create a new sheet and display all the values of A1 on every sheet ...
1
vote
1answer
29 views

In Excel, populate array based on table with value (and coordinates for desired array cell). All array cells are populated (default to be zero)

I am reasonably good with Excel but a near novice at VBA. I have a three column table. Column A & B have coordinates for an array, with column C having the value to be placed as defined by the ...
0
votes
2answers
62 views

How to calculate with Microsoft Excel the correct amount of minutes?

64 people receive services 105 minutes per day. How can i use Excel to calculate the total minutes of service per day and then multiply by 7, so i have the total amount of minutes per week, and then ...
0
votes
1answer
95 views

How to have excel paste a value in a specific cell according to another data table

I'm working with excel 2010, I have an excel sheet with two tables. The primary table contains a calender and each calender day has a specific numeric value in the cell below the date. The numeric ...
1
vote
3answers
2k views

Excel File Names not Displayed

Problem: When excel windows are minimised, I can't see the file name, all I get is a rather unhelpful 'Microsoft Excel' proceeded by the file name. I have the taskbar docked on the left, and have ...
-1
votes
1answer
26 views

Excel data validation: restrict to 10, 20 etc

I am trying to use Data Validation in Excel 2010. How can I restrict entry into a cell to numbers divisible by 10?
0
votes
1answer
77 views

Is this possible in Excel? (VBA)

I want to create a VBA macro that will do the following: The Excel file with the Macro should only open when the file is opened from a certain folder in the Windows directory. If it is not opened ...
0
votes
2answers
80 views

Excel If formula

I am trying to run a simple formula in Excel: =IF(V3>419, "Pass", IF(V3>459, "Merit", IF(V3>499, "Dist", IF(V3>519, "Dist*","Fail")))) I have 2 columns; Overall and Grade Overall ...
0
votes
1answer
32 views

Excel assigning different dollar values and adding them

I am creating a spreadsheet and I want to assign different dollar values and add them together. For example I want B to represent 10.00 per hour for each hour I type in then I want C to represent ...
0
votes
3answers
114 views

Saying in Excel: IF this is true, then show me the cell two below

Hy there, i am trying to create an automatic invoice and probably i am making my life much more complicated than i should. here is my problem... i have these tables (short version) Name Street Place ...
-1
votes
2answers
209 views

Simple Line Graph in Excel

How can I make a graph with this data: Club distance club speed 9 iron 85.8 71.7 9 iron 89.8 68.6 9 iron 85.2 69 5 iron 132.5 73.6 5 iron 131.3 ...
1
vote
1answer
31 views

Excel Deleting duplicate entries

I want to delete duplicate entries in the following table: The problem is that I only want to delete the duplicates in the left hand column, and the right hand column entries must stay with their ...
1
vote
2answers
207 views

Excel Spreadsheets vs Dual Monitor [duplicate]

I am working with two separate spreadsheets and i have dual monitors. I'm using MS Office 2010. How can I get one SS to open on the primary monitor and the second SS to display on the secondary ...
1
vote
1answer
269 views

How can I reference Excel cells by searching/ matching a cell value on their row?

I've trying to make a simple task list in Microsoft Excel 2012: Task# Parent Task# Task Description Days Due Date 1 Catch the llama 1 2 1 Shave the llama 1 ...
0
votes
1answer
21 views

How do I get URLs from hyperlinks in Excel 2010?

I have a column of cells with hyperlinks (to web addresses) and I need their URLs to be regular text. Is there a way to extract the URLs from hyperlinks? Example: Cell says: "CLICKME" Links to: ...
1
vote
1answer
347 views

Deleting entire row using macro in excel

I have and excel spreadsheet and I need to make a button that deletes the entire row in which the button is located. Lets say I have a button on cell G7. When I press it, I want the entirety of row 7 ...
1
vote
1answer
37 views

How to have a cell that displays the cumulative value of all values entered in another cell?

I want to have a cell on my spreadsheet that updates in a cumulative manner, in response to values being changed in another cell. What would the code for this cell be? For example the original value ...
1
vote
2answers
4k views

How to permanently add macros to Excel as part of the program? [duplicate]

I have a macro where I'm not sure when I will need to use it. I need them built into Excel to be able use them at every start of the program – like you would install some add-on (e.g. Kutools). ...
1
vote
2answers
19k views

Excel Formula To Get First Non-Zero Value in Row and Return Column Header

I am attempting to find a formula where I can look at a column range within a row and return the column header in that row where the first non-zero value occurs, moving left to right. Below is a ...
2
votes
3answers
11k views

Cell colors change when copy&paste in Excel 2010

We have a 3rd party tool that creates an Excel file (xls, 97/2003 format) and formats some cells in different colours. When I copy a range of cells into a newly created file (xlsx, 2007/2010 format) ...
0
votes
1answer
18 views

Excel Dates Transformation

How do I change the dates in Excel for the below scenario: Existing dates: 2/2/2014 3/12/2014 1/1/2015 2/1/2015 Target converted dates: 3/31/2016 3/31/2016 1/1/2016 2/1/2016 I want all the dates ...
-3
votes
3answers
31 views

How do I get a cell on Sheet 2 to reference a cell on Sheet 1? [on hold]

I have an Employee database in Excel 10 with several sheets. I want to change one column in sheet 1 based on another column in sheet 2. sheet 1 Sheet 2 Column A, Column B ...
2
votes
1answer
2k views

Excel 2010 macro to separate a large data file into workbooks

I found some code which works perfectly to separate a file based on a column (line 31) into separate tabs within a worksheet. I just need it to separate the files based on a column into a separate ...
0
votes
0answers
12 views

Formulas speed when opening/save the file

I have a file with many formulas, when i open the file or save it takes a lot of time before of the formulas, is thee a way to avoid that?
1
vote
1answer
16 views

Excel table not formatting new rows appropriately - where does formatting come from?

I have an excel table and all rows are formatted the same. When I add a new row, the formatting does not match the rows above - so every time I add a row I have to select the above row and copy/paste ...
-2
votes
1answer
38 views

try to fix my Excel formula

I have similar tables in sheet1 and sheet2. I want rows, with new names, to be added automatically to table in sheet2 if I manually add them to sheet1. Example: If I add a row with the name "Jane" in ...
0
votes
1answer
2k views

Relocate filters on an Excel worksheet with a Pivot Table

In my worksheet where I have my pivot table I have many different filters to chose between. To the eye it doesn't really look nice and I want to be able to maybe split that long list of filters into ...
3
votes
2answers
4k views

Split Text into Columns Function in Excel

I have an excel spreadsheet with rows of data as shown below. There is a code with the product name and then a number. QA32 Product One (Large) 23 AZ63 Product Two 96 PR65 Product Three 149 How do ...
1
vote
3answers
544 views

Excel formats a String to Date in a CSV file. How can I retain the original string value?

I'm encountering a problem in Microsoft Excel 2010 regarding auto-formatting a String into a Date, and it seems to lose the cell's original value. Steps to reproduce: 1 Create the following CSV ...
1
vote
4answers
3k views

Preserve conditional formatting on cut-paste

I have some data from different sources that I'm trying to line up to get a good handle on which fields they have in common and which they don't. To make it easier to see rows, I set up a conditional ...
0
votes
0answers
20 views

How to insert a row into an Excel sheet1 and automatically insert the row into sheet2 [duplicate]

I have the following table in sheet-1 (master table) from an excel workbook. I want an excel formula that can allow me to automatically add a row to similar table in sheet-2 if I add it to the main ...
0
votes
1answer
48 views

Automatically add a row to similar table in sheet-2 if I add it to the main table in sheet-1

I have the following table in sheet-1 from an excel workbook. I want an excel formula that can allow me to automatically add a row to similar table in sheet-2 if I add it to the main table in sheet-1. ...
1
vote
1answer
6k views

How do I change language (not dictionary!) in Excel 2011 for Mac?

How do I change language in Excel 2011 for Mac? I'm not asking about the dictionary, I'm asking about the language of the program itself, i.e. the one of the menus. (in case this matters, I'm using ...
-1
votes
0answers
21 views

Modify Excel data connection without disconnecting the connection file

When I link a data connection file to a workbook, and then edit the SQL query (to include dynamic parameters), Excel says: The connection in this workbook will no longer be identical to the ...
0
votes
2answers
30 views

Text to columns in Excel - break into columns selectively

I'm trying to separate a single cell into columns but I just need the last 3 values (separated by "space") to be in the separated cells. I have this (in one single column): Column A ...
4
votes
3answers
8k views

Excel 2010 -Excel cannot complete this task with available resources

Getting this error when trying to sort a document (Excel cannot complete this task with available resources). Document isn't particularly large, about 4,000 lines. Can't seem to figure out why this ...
0
votes
1answer
18 views

Highlight Data Points in a line graph on excel 2010 or 2013

I have a line chart (two series of data) and I need to highlight a specific point in the data. Is it similar to the bar chart where you can just change the color or is there something different? ...
0
votes
1answer
30 views

How can Excel open a .txt file and keep 0x0D chars and foreign chars ß ä? [duplicate]

How can Excel open a .txt file and keep 0x0D chars and foreign chars ß ä? The file is tab delimited. Windows 7, Excel 2010 Edited ten minutes later. I drag and drop one .txt file and it works ...
0
votes
1answer
4k views

Excel data validation to whole column

I want apply data validation list to a whole column in excel 2010. How can I do that with out copying the validation rule
0
votes
2answers
5k views

How to troubleshoot “Automatic update of links has been disabled”

When I open some spreadsheets I get the error "Security Warning Automatic update of links has been disabled". I can only imagine this might be in reference to formulas or other content in the workbook ...
0
votes
0answers
8 views

i want to copy paste a mobile number from excel to true caller search bar [closed]

hi someone could please help me out with a macro in excel : I want to copy paste a mobile number from cell in excel to web page of truecaller's "search" area http://www.truecaller.com/in/&cell ...
0
votes
2answers
44 views

Using COUNTIFS for a series of values at once

Working a step higher then COUNTIFS, I appose a challenge to write a formula without VBA code. The basic data is combined from 1000s of rows with: Column A: rows with values from 1 to 3 Column B: ...
0
votes
2answers
27 views

Export excel chart to png with certain dimensions

How do i export an Excel chart to a PNG image, defining the exact size of the resulting image file? I need to export some excel charts to PNG to put them on a html page. Due to design restrictions, ...
1
vote
2answers
2k views

Multi-row headers and excel 2010 sort/filtering

I have a spreadsheet which uses 2 rows for header information and some of the columns have the 2 rows merged together as one cell. I a multiple columns merged together in the first row, but the second ...