0
votes
2answers
29 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
35 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
24 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
19 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
44 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
80 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
37 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
143 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
130 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
179 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
3k 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
206 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
121 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
54 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
123 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
321 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
122 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
281 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
417 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
262 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
9k 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
969 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
4k 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
253 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
539 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
20k 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 ...
11
votes
3answers
41k 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
161 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
548 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
4k 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
474 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
6k 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
2k 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 ...