Stack Overflow
Stack Overflow

Questions tagged [excel-2010]

The Excel-2010 tag is used for referencing the Excel Version 2010 spreadsheet application from Microsoft. If your question is about VBA then also tag it VBA. If it is about an Excel formula or worksheet function, then tag it worksheet-function.

Excel 2010 is the 14th version of Microsoft's commercial spreadsheet program. Microsoft made slight user interface (UI) changes; otherwise, it continues to use the UI pioneered in Office 2007.

Features such as Sparklines and Slicers were introduced in Excel 2010 to provide more charting and data visualization power.

This tag is used for questions specific to the 2010 version of the program. However, it is usually used in tandem with other tags, to let SO users know what your question is about. If your question is about VBA then also tag it . If it is about an Excel formula, tag it or . Questions about addins for Excel 2010 should be tagged .

Links:

6168 questions
148
votes
16 answers

IF statement: how to leave cell blank if condition is false ("" does not work)

I would like to write an IF statement, where the cell is left blank if the condition is FALSE. Note that, if the following formula is entered in C1 (for which the condition is false) for example: =IF(A1=1,B1,"") and if C1 is tested for being blank…
Mayou
  • 8,498
  • 16
  • 59
  • 98
139
votes
6 answers

Insert picture into Excel cell

I'm tying to generate a report with pictures, but I cannot get the pictures into a single cell. I can get the pictures to "float" around my worksheet, but I need to put them into a cell. How can I do this?
Reid
  • 4,376
  • 11
  • 43
  • 75
133
votes
6 answers

Remove leading or trailing spaces in an entire column of data

How do I remove leading or trailing spaces of all cells in an entire column? The worksheet's conventional Find and Replace (aka Ctrl+H) dialog is not solving the problem.
venkat
  • 5,648
  • 16
  • 58
  • 83
120
votes
1 answer

Freezing Row 1 and Column A at the same time

I want to "freeze" Row 1 and Column A simultaneously in Excel 2010. Is this possible?
Matt Ridge
  • 3,633
  • 16
  • 45
  • 63
118
votes
4 answers

What is the difference between "Form Controls" and "ActiveX Control" in Excel 2010?

Using Microsoft Excel 2010, I noticed two kind of controls that can be inserted into a document: Form Controls and ActiveX Controls. What is the difference between them?
Rubens Mariuzzo
  • 28,358
  • 27
  • 121
  • 148
86
votes
6 answers

Conditional formatting, entire row based

I've searched and read through answers related to conditional formatting, but I can't seem to get mine to work, so maybe I'm doing something wrong. I have a worksheet for work. It contains a list of animals in our shelter. What I'm attempting to do…
Josh
  • 3,225
  • 7
  • 30
  • 44
77
votes
14 answers

Ignore Duplicates and Create New List of Unique Values in Excel

I have a column of values that often appear as duplicates. I need to create a new column, of unique values based on the first column, as follows: Column A Column B a a a b b c c c This Column B will actually need to…
tob88
  • 2,151
  • 8
  • 30
  • 33
76
votes
4 answers

How to use workbook.saveas with automatic Overwrite

In this section of code, Excel ALWAYS prompts: "File already exists, do you want to overwrite?" Application.DisplayAlerts = False Set xls = CreateObject("Excel.Application") Set wb = xls.Workbooks.Add fullFilePath = importFolderPath & "\" &…
bob.mazzo
  • 5,183
  • 23
  • 80
  • 149
66
votes
34 answers

Excel: the Incredible Shrinking and Expanding Controls

Occasionally, I'll happen across a spreadsheet which suffers from magic buttons or listboxes which get bigger or smaller over time. Nothing in the code is instructing this. Has anybody else experienced this joy?
Nick
  • 3,573
  • 12
  • 38
  • 43
58
votes
2 answers

Count number of times a date occurs and make a graph out of it

I have a list of dates, each date in it can occur more than once. I want to count the number of times each date occurs (histogram) and display it in a graph (with the Y axis being the number of times the date occurs and the X axis being the date…
SystemX17
  • 3,637
  • 4
  • 25
  • 36
45
votes
7 answers

Number format in excel: Showing % value without multiplying with 100

When I set format of a cell as %, it automatically multiply the value with 100 & show the value. So 5.66 becomes 566 %. I want to apply % format on a column but want to keep the values same as before. I just want % sign to be shown along with the…
SharpCoder
  • 18,279
  • 43
  • 153
  • 249
43
votes
3 answers

Excel how to find values in 1 column exist in the range of values in another

I have two columns- column A which extends upto 11027(values) and column I which extends to 42000(values).Both the columns contains some code details. Something like this A B q123 as124 as124 gh456 ff45 …
user1254579
  • 3,901
  • 21
  • 65
  • 104
38
votes
3 answers

In excel how do I reference the current row but a specific column?

Let's say I had the datasheet A B C D ----------- 5 4 6 3 4 4 3 2 5 4 6 2 And I wanted to do something like A B C D E F ---------------------------------------------- 5 4 6 3 =AVERAGE(A1,C1) …
Jared Joke
  • 1,226
  • 2
  • 18
  • 29
37
votes
7 answers

Delete entire row if cell contains the string X

I am trying to come up with a way to delete all rows (and shift cells up, if possible) where the website column cell contains the word none. The table contains 5000+ records and this would save me a great amount of time. I appreciate any…
AnchovyLegend
  • 12,139
  • 38
  • 147
  • 231
34
votes
6 answers

Get list of Excel files in a folder using VBA

I need to get the names of all the Excel files in a folder and then make changes to each file. I've gotten the "make changes" part sorted out. Is there a way to get a list of the .xlsx files in one folder, say D:\Personal and store it in a String…
Buzz Lightyear
  • 824
  • 1
  • 7
  • 18
1
2 3
…
99 100