0
votes
1answer
43 views

Microsoft Excel Custom Label Overlay on Line Graph

I have 2 tables identical. One records the progression of projects as a percentage over dates until completion. The other is a replica table but records the daily status of the projects on the ...
1
vote
2answers
107 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 ...
1
vote
1answer
96 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 ...
-4
votes
2answers
242 views

Custom Data Validation in Excel 2010 [closed]

I'm trying to make error messages appear when someone tries to enter the wrong data type in a certain cell with data validation in Excel 2010. Is there a feature or some sort of formula I can use? ...
0
votes
2answers
33 views

Excel: Applying Condittional formatting to every other row

I would like to apply a specific conditional format to every second row in my spreadsheet. In my specific case I have regression results, where the first row indicates the beta coefficient and the ...
0
votes
1answer
47 views

excel - if value grater than, use that value

I am having problems with my excel function. I want to: if value 1 is greater than value 2, then write value 1 in a cell. If value 2 is greater than value 1, then write value 2 in the cell. ...
0
votes
0answers
37 views

Force PowerPoint to open a new Excel instance

When using the insert diagram function in PowerPoint, PowerPoint automatically opens a new Excel window. Unfortunately, if you already have an Excel workbook open, it will simply use the same Excel ...
1
vote
1answer
22 views

Excel 2010 switching to formula view after every click

Since I installed Excel 2010 64-bit (was using 32-bit version before), every time I click on an icon in one of the ribbons, e.g. reducing icon size: The top bar switches to the formula view: ...
0
votes
0answers
181 views

Export to excel not working if ms office is not present on machine

You might think this can be a possible duplicate to questions like this: How to create excel file witout installing MS Excel in vb.net? However this is not the case, I've googled a lot and things are ...
0
votes
1answer
191 views

Disable custom view in Excel

I am using a shared excel workbook that everytime a user accesses it and saves it, it saves a Custom View for them. I want to disable this settings so that every one can see only same view of the ...
0
votes
0answers
58 views

Excel: Timeline for Pivot Table based on XML imported data in Office 2010?

I imported XML data into Excel document on Sheet 1. Added Pivot Table based on that data to Sheet 4. Then I made a chart based on that Pivot Table. Is there any way to create a timeline just like in ...
3
votes
3answers
171 views

Filling empty spaces in a column with a series in Microsoft Excel

I have a list like this: A B Student ID Student Name 20496836 Barnes, Troy 28682693 Bennett, Shirley Edison, Annie 28395839 Hawthorne, Pierce ...
1
vote
1answer
172 views

Displaying Other Values Via COUNTIF in Excel

Basically I have a sheet like this: A B C D Name (From File 1) Name (From File 2) Phone Number Countif Walt ...
0
votes
1answer
301 views

Linking to Other Excel Sheets Greyed Out (Excel 2011 Mac)

I just got a file from my colleague which has some broken links. They were broken because the path to the cells pointed directly to a file on her computer. She sent over those files, and now I have to ...
4
votes
2answers
5k views

Multiple Y-axis labels in Excel 2010 line chart

I have a table containing cycling data. Date, distance, time, calories burned, max heart rate and average heart rate. They all have different value ranges. Excel scales the chart to show the calories ...
2
votes
1answer
259 views

How to config Microsoft Office Application (Word / Excel) to stop adding personal information to the document?

I have created word document (*.doc or .docx) or excel documents (.xls or *.xlsx). Sometime, these documents need to be sent to some customer and therefore require personal information to be removed ...
-1
votes
1answer
384 views

use tabs inside Excel 2010 cells

I'm struggling with this issue for quite some time now and can't find the solution I want to. I'm looking for a solution to tab between two or three words/values inside a single Excel 2010 cell. I'm ...
0
votes
0answers
58 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 ...
0
votes
1answer
133 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
2answers
455 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' ...
0
votes
0answers
155 views

Hyperlink is not opened in Excel 2010 on click

When I click on hyperlink in Excel 2010, nothing happens. How to make web-browser open on click? It seems something specific with Excel only, because links in Outlook works fine. I have found ...
0
votes
1answer
429 views

Adding Subsequent Cell Values For Each Row in Excel

I'm new to excel so this might be a simple question. I have around 100 rows with 7 columns. Out of those, 4 column needs to have the value computed by 3rd and 2nd columns' value of the same row. I ...
1
vote
0answers
568 views

Is it possible to add a data connection to an existing table in Excel?

I have a table in Excel which has a data connection to an Access database. When the data changes, I can click "Refresh" to re-query the data and update the table. However, Excel 2008 for Mac doesn't ...
2
votes
2answers
305 views

Skip rows in excel

I'm doing a budgeting spreadsheet in excel. Along the top, the columns are headed for each budget item I need to account for. The rows are each labelled with dates on a daily basis. At the end of each ...
1
vote
2answers
2k views

Excel 2010 Pivot Table: How can I expand/collapse a subset of records beneath a distinct set of records?

Consider the following set of data in a table called Employee: Name Sup Q1Sales Q2Sales Q1Atte Q2Atte John Joe Good Bad Bad Bad Mary Joe Good Bad Bad Bad Bob ...
3
votes
2answers
15k views

How do I bring back the ribbon in Office 2010?

The ribbon in Excel 2010 appears when I click on Home or Insert or one of the other tabs, but disappears again when I go back to editing my document. I'd like it to always be visible - how can I get ...
0
votes
2answers
1k views

How to set the displayed precision for a complex number in Excel 2010?

MS Excel provides a set of functions to work with complex numbers. When displaying real numbers, one can set the decimal places precision from the Format Cells dialog. However, it does not work for ...
2
votes
1answer
5k views

Create reusable custom shapes in Microsoft Excel or even Office in general

In Microsoft Excel 2007/2010, or even Microsoft Office in general, Say I use the use Insert > Shapes to create a drawing in Excel, is it possible to save this drawing in as a new Shape itself in the ...
1
vote
0answers
269 views

Is there anyway to co-author with the Excel 2010 Desktop App?

I'm wondering if there is clean way to co-author with the Excel 2010 desktop App? Now, or possibly this could be a placeholder for the future. The current answer seems to be no with Excel 2010 desktop ...
1
vote
1answer
581 views

Excel VB Convert sheet text to unicode chars

I need to enter a function in an excel sheet that converts all cells values, that are texts, to it Unicode values. For example I want ΓΌ to be ü and so on. How can I achieve this, is it ...
4
votes
4answers
26k views

Excel Spreadsheet for Barcode Scanning

I've been asked by our warehouse guy to help him with an excel spreadsheet to increase his productivity. The problem is, I'm not what you would call an "excel expert". What he wants sounds very ...
14
votes
3answers
54k views
2
votes
1answer
1k views

Excel 2010 changes number precision automatically

I've run into an issue in Excel 2010 where precision in percentage type cells is changing. To reproduce: Create two cells in A1 and B1, both with Percentage format (2 decimals) and numbers with ...
2
votes
1answer
219 views

Excel documents 'blanking' after a short delay

One of my clients is having a problem with certain Excel documents. Some of the worksheets go 'blank' after a short delay, after Enable Editing is clicked. The content is there before, and other ...
1
vote
1answer
631 views

Replacing wildcard characters like ? in Excel

Was is das? I try to replace the ? symbol to the ! symbol in Excel (2010)... and this changes all the chars to !??? I try to make a conditionnal formatting for cells that contains ? but it applyes ...
1
vote
0answers
5k views

Windows 7 can't open Excel 2010 .xlsm files?

I just reinstalled Windows 7. When I installed Office 2010 I deselected some components to save disk space. Now, I can't open xlsm files. I would like to know which components in the Office ...
0
votes
1answer
2k views

Remove Excel data link in Visio Drawing

I am creating a server topology for one of our SharePoint farms and thought it would be easy to just link the Excel spreadsheet with our server information to the Visio drawing to auto-populate some ...
0
votes
2answers
532 views

Excel 2010 prints older revision of a file

Using Excel 2010 on Windows 7, editing a file on a shared folder. (The file server is running Windows Server 2008 R2.) Opened the file to make some changes. Saved the changes. When I print, the Print ...
8
votes
4answers
8k views

Set Excel to search within entire workbook by default

In Microsoft Excel, when I search using CTRL+F, by default it only searches within the current worksheet. How can I set it to search within the entire workbook by default? I have Office 2010. Is ...
1
vote
1answer
3k views

Excel: Filter on column merged downwards

I have an excel spreadsheet with 3 columns. The first column is merged downwards to be the length of the other cells and contains a document name. The other 2 columns contain an id and some text ...