**3**

votes

**1**answer

28k views

### How can I hide 0-value data labels in an Excel Chart?

I would like to hide data labels on a chart that have 0 as a value, in an efficient way. I know this can be done manually by clicking on every single label but this is tedious when dealing with big ...

**3**

votes

**3**answers

187 views

### Strange behavior of left arrow key in Excel 2010

When I press the left arrow to return to column A - it will not stop at column A but will continue to wrap around to the end (column XEP or something huge like that). How do I make it stop when it ...

**3**

votes

**3**answers

10k views

### Ctrl + Shift + Arrow stopped working

When I work with a big amount of data, I introduce formulas in Excel by using the shortcut: Ctrl+Shift+arrow. That shortcut allows me to select a whole set of data to the left, right, up or down. ...

**3**

votes

**1**answer

265 views

### Paginate Rows into Columns in Excel

How would I 'paginate' every X row into a new column?
ORIGINAL LIST
Col A
-----
1
2
3
4
5
6
7
8
9
10
Is there a way to break after every third item? Turning the list into this:
PAGINATED LIST
Col ...

**3**

votes

**1**answer

2k views

### Excel conditional formatting to highlight entire row if one date is not equal to another date in that row

I'm trying to use conditional formatting to highlight an entire row if the date in column D is greater than the date in column B. I can't seem to make it work. Is it a problem because it's a date ...

**3**

votes

**2**answers

15k views

### Excel cells - show text different to the actual value?

Is it possible in Excel to have a cell show text that is different from its value?
I would like to have a a cell that has the value 1,2,3 ... or 7 but it will show day of the week as text - but when ...

**3**

votes

**1**answer

20k views

### How do you force the focus of an Excel Cell to remain the same?

I have set up an excel table where occasionally the data I have in several columns gets shifted down several rows to make room for new data. I also have a cell that references the top most cell in ...

**3**

votes

**2**answers

6k views

### How to utilize multiple monitors with Microsoft Project 2010 (or other Office 2010 products)?

My question does primarily concern Project 2010, though it would be applicable to other Office products such as Excel, which can tend to span several horizontal screens.
Seems like an obvious ...

**3**

votes

**6**answers

29k views

### Entering Time data in excel in mm:ss format (without the leading 0: for the hours)

I want to enter time data into excel sheet in mm:ss format.
The problem is - that although the cell format is mm:ss, if I enter the data like this:
12:33 the actual value stored is 12 hours and 33 ...

**3**

votes

**1**answer

8k views

### Strip out all HTML Tags from an excel file

I have an excel file that has cells with text that includes HTML tags.
The data was exported from a database and the HTML tags were included.
The HTML is stored as text, but I need it gone.
Is ...

**3**

votes

**3**answers

3k views

### Excel trendline accuracy

This is a problem I have every once in a while, and it annoys me tremendously, beacuse I have always to recheck every trendline I get.
An example:
r L
(mm)
30,00 97,0
60,00 103,2
...

**3**

votes

**4**answers

90k views

### How to break the Y axis in an Excel sheet

I want to break the Y-axis in an Excel sheet. How can I do that?
For example, suppose I have the data in a range from 0-7000 and then range from 22000-28000. I want a break in the Y axis from ...

**3**

votes

**2**answers

6k views

### How can I change a cell's background color based on the cell's current value?

I have a column with function values of True or False:
=IF(ISNA(A1), false, true)
from row 1 to 5000+ rows. I would like to mark all the False as red background color or text as red. Is there any ...

**3**

votes

**1**answer

3k views

### Is there any way to suppress the Excel 2007 warning “in a different format than specified by the file extension”?

We have an application that exports data using the older Office XP/2003 XML Spreadsheet format. These files are saved with a .xls extension so that they can be launched directly, without having to ...

**2**

votes

**1**answer

3k views

### How do I filter on bold, struck through or italic text in Excel 2007?

Is it possible to filter an Excel column based on the format of the text, such as whether it's bold, italic or struck through?

**2**

votes

**2**answers

3k views

### VBA Excel 2007 help to speed up code to hide rows [closed]

I am trying to write a VBA code that automatically hides rows if a value in the row is equal to "". My range of values is A37:A400. Because my range is so big my previous VbA is to slow and looks one ...

**2**

votes

**1**answer

6k views

### How to hide formula results until conditions are met

I am completely new to making spreadsheets with Excel and even more dumb when making formulas. I have come to surprise myself how much I have learned, but now I am stumped and could really use some ...

**2**

votes

**1**answer

271 views

### how to determine which values in a given set of cells will add up to a numerical range

In other words, I'm looking for a sum range that consists of combinations of cells from an array. Given a set of numbers:
1 720 56 17 59 120 153 203 39 1 690 583 582 561 256 310 232 95 108 16
26 ...

**2**

votes

**2**answers

985 views

### Excel - Sum values if their row meets more than one criteria

I have a spreadsheet of my bank account transaction history in this format:
| A | B | C | D
1 | Date | Amount | Balance | Category
2 | 2013-03-10 | $ -10.59 | ...

**2**

votes

**4**answers

18k views

### Excel ran out of resources while attempting to calculate one or more formulas

I received the error message
"Excel ran out of resources while attempting to calculate one or more formulas"
on ONE of my computers (Out of 2).
My worksheet contains: (Inside a single worksheet, not ...

**2**

votes

**3**answers

22k views

### Count unique names in excel column range

I have an excel spread sheet that contains a list of server names in column B.
The server names appear multiple times in this column.
I would like to count the number of unique server names in a ...

**2**

votes

**3**answers

3k views

### How can I make a SUM of cells that match a specific criteria?

Here's the excel table:
In B16 I'd like to insert the sum of all the cells in the range B1:B10 that have "*" on the right.
In this case B16 = 10 + 2 + 7 + 9 = 28
How can I do this with a formula?
...

**2**

votes

**1**answer

10k views

### Compare 2 text cells and show difference in the third cell

If cell A1 = abcd, cell B1 = abcdefg, then what formula to use in order to get the text difference efg?

**2**

votes

**3**answers

24k views

### How to change or remove all traces of original author name in Excel 2010 document

At our company we need to deploy one Excel Workbook in that way that nobody would see it is made by us by looking at the Office metadata.
What fields do we need to look for? I know, that the document ...

**2**

votes

**2**answers

6k views

### Excel (2010) HYPERLINK: how to call a file with command line arguments and spaces in the path?

I am working on an Excel-document to make a (project-)folder structure manageable, using HYPERLINKs to important files and folders (Word/Excel, etc.).
Since we are also using TFS, I want to add the ...

**2**

votes

**1**answer

2k views

### Using Excel Linest function with blank cells

I need LINEST function to be applied with blank cells to get the slope parameter as well as the associated standard error. I can get the slope parameter with a normal function that may resolve the ...

**2**

votes

**6**answers

34k views

### Missing Paste special options in Excel 2010

I have a weird problem with the Excel. Every time I copy and paste only the text is copying and the format is not copying as shown in the below figure. There are no paste special options available ...

**2**

votes

**9**answers

25k views

### Excel freezes when copying / cutting to paste elsewhere

When cutting/copying some cells to paste them into another sheet/page, sometimes Excel freezes/locks up and fades out. At the top toolbar it says in brackets "not responding".
Eventually, I must ...

**2**

votes

**2**answers

9k views

### Export to CSV From Excel

I frequently use Excel to prepare data to load into a table. I create a CSV file from it and use that file for data loading. I generally find myself creating the CSV file multiple times.
My current ...

**2**

votes

**1**answer

3k views

### Excel count coloured cells

If i have 500 cells filled with red, 500 filled with green and 50 filled with yellow, is it possible to do a countif sorta formula where i will have a cell which will count the number of red cells, ...

**2**

votes

**1**answer

283 views

### Is Workbook.FileFormat available to the Excel UI (specifically when the file type can't be saved)

As a programmer I eventually located the file type of a .d extension file loaded successfully by Excel 2007 by interrogating Workbook.FileFormat via VBA, but can a normal user determine it is a DBF4 ...

**2**

votes

**4**answers

12k views

### Filling cells with sequential numbers in an Excel (2003) macro

I need to fill an excel column with a sequential series, in this case from -500 to 1000. I've got a macro to do it, but it takes a lot of lines for something that seems like it should be a single ...

**1**

vote

**1**answer

35 views

### Excel SUMIFS based on two criteria

I would like to total a list of minutes based on two criteria to make a graph after the data is calculated.
The item "Department" (Column C) and "Day of Week" (Column F) are both drop down menus.
I ...

**1**

vote

**1**answer

65 views

### Excel formula to show FORMULA

Ok, guys. I am 100% sure that a few days ago I saw and tested a real built-in Excel formula for showing a formula as text in any cell. Now, when I need it, I cannot find it!!! No VBA, no tricks. Just ...

**1**

vote

**2**answers

385 views

### I need todays date to auto fill in cell when data is entered into another cell

I would like to have cells C5-C39 auto fill the date when data is entered into cells B5-B39. I have tried to get it to work using =TODAY() but don't how structure the formula.
Thanks.

**1**

vote

**4**answers

209 views

### How do I stop Excel from converting value 0503E000 to 5.03E+02 automatically?

Excel converting value 0503E000 to 5.03E+02 in any cell automatically in CSV
I tried to convert it to text number and general but after i save it and reopen it again
it goes back to 5.03E+02
How do I ...

**1**

vote

**3**answers

288 views

### How to split numbers into columns with negative and positive values, without empty cells?

Given positive and negative values in column A of an Excel sheet, I want column B to list the positive values from column A, and column C to show the negative values, in the order in which they appear ...

**1**

vote

**1**answer

34 views

### can someone help me with my Formula Excel need it show blank

=IF(NOW()-B4>=15,"OK","Warning - Time to Renew")
that is the formula, but can it stay Blank until a date is put into cell B4
thanks

**1**

vote

**1**answer

122 views

### Dropdown, multiple values in dropdown

I'm trying to make something for my hobby, and for that I was wondering on how to do it:
These are my input values:
And via dropdown you can choose one player and it autofills the other values:
...

**1**

vote

**1**answer

85 views

### Excel autofill problems

I am an advanced novice at using Excel and I have a problem.
I am using 2 worksheets and want to refer cells from sheet1 to sheet2.
In sheet1 (named "Aktuel") I have a list of all my costumers' ...

**1**

vote

**1**answer

38 views

### Excel rounding errors

In a new worksheet (I'm using Excel 2013), starting in the top left, I type:
=18.6 + 67.2 | =A1-85.8 = 0 | =(A1-85.8) * 1000000000000
Expectation
85.8 | TRUE | 0
Actual Result
85.8 | FALSE | ...

**1**

vote

**3**answers

2k views

### Excel function working like SQL group by + count(distinct *)?

Suppose I have an Excel sheet with below data
CODE (COL A) | VALUE (COL B)
==============================
A01 | 10
A01 | 20
A01 | 30
A01 | 10
B01 | ...

**1**

vote

**3**answers

1k views

### Conditional Formatting: 3 color scale showing text relevance in Excel for Mac

Is there a way to use conditional formatting in the following manner in Excel? (For those who are curious, I am using Excel 2010 for Mac)
I want Cell B2 to be green when A2 says "John likes green ...

**1**

vote

**1**answer

83 views

### How to create multiple rows combining data sets

I have three tables and i need an out put which has data from two tables, i would like to create the same using macro.
Table A
A
B
C
D
Table B
Apple
Orange
Pears
Table C
Americas
Asia
Europe
...

**1**

vote

**2**answers

12k views

### How to change date format from dd-mm-yyyy to dd-mm-yy in formula bar of MS-EXCEL? (Still didn't got satisfactory answer)

I've written a date in one of the cells of MS Excel spreadsheet as 26-09-2013. Then by right clicking on that cell I selected Format cells and gone to Number->Date option and by selecting the type ...

**1**

vote

**2**answers

24k views

### Looking-up the values of one worksheet in another worksheet

Basically, I could do this manually, but as the data is huge, it would take a lot of time. I am sure there must be a formulaic way of doing it.
I have two worksheets in Excel.
Worksheet 1.
Column-A ...

**1**

vote

**1**answer

4k views

### How to get relative worksheet references when copying formulas in Excel?

I have a workbook containing two types of worksheets. One type is 12 worksheets, each referring to a month (JAN, FEB, MAR, etc.) Then I have another type of worksheets referring to employee's time ...

**1**

vote

**4**answers

31k views

### Extracting Data Between two Characters in Excel

I have the following format in Excel and I am trying to extract the data between the characters:
First Last <flastname@xxxx.com>
I need to extract the email address between < and > into ...

**1**

vote

**2**answers

14k views

### Excel Date Formula - Return the next specified day of the week

I need a formula that will always return the next specified day of the week.
For instance
IF(A1="A",RETURN NEXT FRIDAY, IF(A1="B",RETURN NEXT TUESDAY.....ETC
The reason I need this is because I ...

**1**

vote

**2**answers

36k views

### If an Excel row contains particular words, return that row, highlight that row, or give Y/N for that row

I have a sheet containing thousands of cells in a column. These cell contains names of different securities.
Some names of these securities contains a particular string such as "C/O".
How can I use ...