The 2010 version of Microsoft's spreadsheet application.
2
votes
1answer
63 views
Working with dates in Excel older than 1900
Are there any workarounds for working with time and date data prior to January 1, 1900? Excel seems to just assign my values dates in 1900 rather than keeping them intact.
0
votes
1answer
144 views
Unable to create Hyperlink from Excel 2010 to a Bookmark in Word 2010 document
I have tried but am not able to create Hyperlink from Excel 2010 to a Bookmark in Word 2010 document.
The bookmark is in place in word document. But while clicking on Bookmarks button after browsing ...
0
votes
1answer
137 views
Compare two excel sheets with almost identical data and come out with matched and mismatched data
There are two excel sheets with almost similar data. One sheet is huge with around 1800 rows. and the second one is a small with around 100 rows. And these 100 rows may be present or not , if present ...
1
vote
1answer
75 views
Why is the transpose check box in the Paste/Special dialog greyed out?
In Excel, you are supposed to be able to change the rows to columns and the columns to rows (in effect, rotating the sheet through a diagonal axis), by selecting the area to be transposed, and doing a ...
0
votes
1answer
64 views
In Excel VBA, how can I test if the active cell is in a certain row or column?
I need to prevent a macro from running if the user hasn't selected a cell in a certain column or row. How can I detect which row/column the selected cell is in to do this?
Thanks
0
votes
1answer
97 views
How to select all empty cells below current selected until first non-empty cell in VBA
I am trying to write a macro that copies the current cell and pastes the text into every empty cell below it until it reaches the first non-empty cell.
So if I had "Apple" in cell B2 and "Orange" in ...
3
votes
1answer
125 views
Open Worksheets In New Window In Excel 2010 Without Administrative Access
Software configuration:
Microsoft Office 2010 Professional (Excel 2010)
Windows 7 Enterprise SP1
Logged into the computer as a Standard User (not Administrator or Power User)
Problem:
Want to ...
1
vote
1answer
33 views
Remove third-party Excel Add-ins
I added some third-party add-ins to MS Excel 2010 and want to remove them now.
How is this done?
-2
votes
1answer
69 views
How to use “=IF” in Excel
How do I write this formula in Excel?
=if(700>=700;"Saving";IF(700<>700-400;"average saving";If(700<=400;"Spender")))
0
votes
1answer
99 views
Is there a way to add multilevel list to excel
Is there a way to implement a multilevel list in excel?
Something like this
1. XXXX
1.1. XXXX
1.1.1. XXXXX
1.1.2. XXXXX
1.2. XXXX
1.3. XXXX
2. XXXX
Thanks.
0
votes
0answers
88 views
How to graph events per time in excel (from log file)
I have a log file in the following format:
A | B | C | D
DD.MM.YYYY|HH:MM:SS|DEVICE|EVENT DESCRIPTION
what I want to do is, create a graph with the time on the x-axis and the events ...
1
vote
1answer
130 views
Excel 2010: Formatting Header through VBA Script
I have a VBA script that I've culled from the internet. It takes the contents of a cell and puts it into the appropriate header. This works exactly how I need it.
Sub InsertHeaderFooter()
' inserts ...
0
votes
2answers
74 views
Remove duplicate entries, keeping latest only
I have several spreadsheets with information I need to consolidate, each with different (and sometimes overlapping) portions of the final data set I'm hoping to create. Typically, combining ...
1
vote
2answers
109 views
Increment numbers inside a string
I'm putting together a long list of users where the user names have the format user001, user002 etc. To each user there is an e-mail address with the format user.001@localdomain.com, ...
1
vote
3answers
142 views
how can I split data into multiple columns seperating only after the first colon in excel
I have a huge excel list (20k+ rows) and want to split that one column list into multiple columns.
Previously I used the Data|Text-to-Columns Wizard but it appears to have a limitation: I cannot ...
0
votes
0answers
84 views
Is there Windows 7 Run as Administrator fix for Outlook?
I have excel 2010 report which has a script that runs automatically emails report via outlook 2010 but it will only work if I have Outlook open via right click and Run as Administrator.
Is there a ...
-1
votes
2answers
80 views
How to append number of 0 in the end of number in cell
I want make a Number Custom Format Pattern in Microsoft Excel 2010.
It looks like multiply with 1000.
Please read following example below:
1 would turn 1,000
12.3 would turn 12,300
...
2
votes
1answer
135 views
Opening 1GB+ XML file for editing [duplicate]
Running Windows 7 64-Bit w/6GB RAM. Attempting to open a 1GB XML file in an attempt to repair an Excel Spreadsheet. I have tried other tools but all caused memory errors. I even tried sed (Windows ...
0
votes
2answers
84 views
Show All Shortcut in Excel 2010?
In Excel 2003, I had a shortcut on the taskbar for "show all". When I clicked on this button, all the filtered items would open up. Can someone help me find this shortcut on Excel 2010 so I can add ...
0
votes
1answer
83 views
Conditional Formatting to highlight dates past due
I have a spreadsheet which indicates when dates listed in Column N are coming up within the next 30 days (red, italic text) or are overdue (red, italic text and yellow cell fill).
I have achieved ...
1
vote
1answer
139 views
How to assign a numerical value to multiple cells and then add those values in a separate cell
I'd like to assign a value of $20 to a cell if 'Yes' is the text in the cell. I'd like to have a row of cells with this, each with the same value and I'd like then to be able to sum the total value of ...
1
vote
2answers
104 views
Excel formula to get time difference as a decimal number
I have a table like this (the C column is blank):
A B C
1 19:30 23:00 (3.50)
2 14:15 18:30 (4.25)
I need to calculate the time difference in each ...
0
votes
2answers
244 views
Automatically import a macro to Excel and run it
I have made a module i.e. a .bas file which does the work I want to do in Excel. I have to work with this same module in four different files everyday.
Now I want, let's say, a script which ...
0
votes
0answers
40 views
Excel creating weird diagrams
I have a list of times in one column. They are formatted as Time cells. When I simply select the values and click Insert -> Line (diagram), I can't seem to get the right kind of diagram.
What ...
1
vote
1answer
84 views
Can I filter multiple column headers to display subheadings of each in Excel?
I can't seem to find this anywhere... it may not even be possible without coding?
I have a spreadsheet containing more than one heading in a single column. These headings are identified with blue ...
1
vote
0answers
84 views
Copying Excel Spreadsheet with Absolute Hyperlinks to Documents (change to relative?)
I have a large spreadsheet created in Excel 2010 with nearly 100 pdf and word documents hyperlinked in hundreds of cells.
I had planned to copy the folder the spreadsheet is in - which contains the ...
1
vote
0answers
90 views
Excel: Why is VLOOKUP returning inconsistent and unexpected results?
I'm automating an Excel column to assign account values based on the vendor paid. For instance, if AT&T gets paid, the account value is Utilities:Telephone, and when the post office is paid, the ...
0
votes
1answer
127 views
Best way to insert big amount of data in excel sheet
I have to simulate a sheet with more or less 200 columns x 200 rows.
When I add the data manually, Excel shows the message "not responding" and I have to wait about 20 minutes till it fills all the ...
0
votes
2answers
59 views
In Excel 2010, how can I convert cells containing “1 day”, “2 days” etc to just “1”, “2” etc
In order to treat them as numbers?
I copied the column from another program which has a list of durations. Unfortunately Excel will not treat these cells as numbers at all so I can't use them in ...
0
votes
0answers
93 views
ODBC connection from Excel to Native Dynamics NAV 5.0SP1
First off, I was unsure whether to post my questions here or on Stack Exchange, but since it’s not directly programming related (I think) I’ll try here.
We recently upgraded from Navision 3.70B to ...
1
vote
3answers
170 views
Excel 2010 - Freeze column to both horizontal and vertical scroll
I'm familiar with basic freeze pane functionality. If I freeze the first column by Freeze Pane > Freeze First Column, it works against a horizontal scroll, but not a vertical scroll.
I'd like for ...
0
votes
0answers
89 views
Can't Activate Disabled Foxit Phantom Add-in
Win 8
Excel 2010
Everything is running x86.
Foxit Phantom (a PDF Creator) originally gave me a tab at the top of Excel that allowed me to create a PDF right away . . . that tab is now gone.
When I ...
0
votes
1answer
85 views
Excel: Accept only unique values in coloumn
In Microsoft Excel, I want to filter entries so that only unique domain names appear. Suppose I have 10 records:
1. www.manish.com
2. joo.mj.com
3. ko.kiop.eu
4. mail.manish.com
5. ...
0
votes
0answers
27 views
How insert rows in Excel 2010 without pasting data from clipboard? [duplicate]
I often find myself copying a cell's contents from a spreadsheet in order to paste it into another spreadsheet. But when I get to the target spreadsheet, I haven’t yet made room for the new data, so ...
1
vote
1answer
75 views
Excel Formula / Concatenate inconsistency [closed]
I was making a histogram today, and this pc doesn't have the Analysis Toolkit and for whatever reason I didn't feel like tracking it down and installing it.
So I found myself with a column of raw ...
2
votes
2answers
417 views
Alternate grid background color in excel when a value of a single column changes?
I need a formula for conditional formatting to make an Excel 2010 spreadsheet alternate highlighting when a single column changes. This question, "How can I alternate grid background color in excel ...
0
votes
2answers
97 views
If / Else logic involving text i Excel
I want to perform the following logic in a Microsoft Excel 2010 worksheet:
In cell E3: if C3 = Off or off then VALUE=0, else Value=C3*D3
Where cell C3 will contain either a number or the word 'off' ...
2
votes
1answer
110 views
Word 2010 - Paste as Excel “Paste Link” - have table objects which are linked together
I don't know if this can be done or if my one line heading is correct for my question.
I sometimes have elements such as a table that I reuse by copying it multiple times.. This cause a problem if I ...
0
votes
2answers
91 views
How to write an IF function in Excel that performs a calculation based on 3 arguments?
I have a table with three types of customers: GOV, NProfit, and COM, contained in column B. Each of these receives a different billing rate, 1.50, 2, and 3 respectively which needs to be applied to ...
0
votes
1answer
127 views
How to change cell colour in Excel 2010 based on certain criteria?
I would like a cell's colour to change when its value is less than that of another cell. How can I accomplish this?
0
votes
1answer
81 views
How can I hyperlink from PowerPoint to Excel, linking to a specific tab and named range or cell?
How can I hyperlink from PowerPoint to Excel, linking to a specific tab and named range or cell and make it stick?
I am successful in creating the Hyperlinking and obtaining the desired results, ...
0
votes
0answers
31 views
Excel function is not returning expected results
I have a list of documents, and I'm trying to flag those that have the word see in the title. The formula I'm using is =--(ISNUMBER(SEARCH("see",F43))). but all my results return as 0.
ACE [see C3] ...
0
votes
1answer
342 views
How to disable Excel number autoformat
This problem is simple to correct but is very very annoying
what I'm doing is to type a hour range, eg. (0-1),(1-2),(2-3) so on
per cell row
DATE --- HOUR
1/1/2013 0-1 1/1/2013 1-2 ...
2
votes
2answers
137 views
Values with decimal point do not appear on graph
Whenever I have a decimal point in my data, the point on the graph drops down to 0 in the Y-axis.
What could be causing this? It is unusual behaviour, right?
0
votes
0answers
139 views
Cascading dropdown list in Excel 2010
I created dependent dropdown lists in my workbook. The first dropdown selected is nails_screws the second dropdown dependent on that choice will not display.
All of the other dropdowns in the sheet ...
1
vote
2answers
1k views
Is there an Excel function to create a hash value?
I'm working with a number of data lists that are keyed by document name. The document names, while very descriptive, are quite cumbersome if I need to view them on (up to 256 bytes is a lot of real ...
0
votes
1answer
82 views
Extracting delimited substring in Excel
I started with this question, but it doesn't quite address my needs. I have a series of filenames in a worksheet. Some of the filenames have cross-references enclosed in square brackets. Consider Foul ...
0
votes
1answer
306 views
Excel: How to hide/remove scrollbars from Pivot Table Slicers?
Slicers are a fantastic tool new to Excel from 2010, allowing you to quickly switch your selections when analysing data using a pivot table.
Sometimes there are too many options to fit in the slicer ...
0
votes
1answer
93 views
Why am I getting unexplained vertical lines in the center of merged cells?
I am working on a spreadsheet that merges 20 columns into a single row. This row is conditionally formatted to display a data bar, of a proportional length based on a set of values from 0 to 275 that ...
0
votes
3answers
87 views
Looking up (text)values in Excel array
I was searching around on internet and playing around in Excel 2010, but could'nt really find an answer.
For the sake of cleanliness I made an abstract, but the real file is a lot bigger.
In ...
