Top "Excel-2010" questions

The Excel-2010 tag is used for referencing the Excel Version 2010 spreadsheet application from Microsoft.

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 …

excel if-statement excel-2010 worksheet-function
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 …

excel excel-formula excel-2010
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 …

excel excel-2010
Swap x and y axis without manually swapping values

So I have a set of data that has conditional formatting. Basically it's a set of photometric measurements of stars …

excel charts excel-2010 axes
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 …

excel excel-formula excel-2010
Excel VBA Run-time error '13' Type mismatch

I created a macro for a file and first it was working fine, but today I've been opening and restarting …

excel excel-2010 vba
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 …

excel-2010 conditional-formatting
Copy an entire worksheet to a new worksheet in Excel 2010

I have found similar questions that deal with copying an entire worksheet in one workbook and pasting it to another …

vba excel excel-2010
Copying and pasting data using VBA code

I have a button on a spreadsheet that, when pressed, should allow the user to open a file, then copy …

vba excel excel-2010
How do you select the entire excel sheet with Range using VBA?

I found a similar solution to this question in c# How to Select all the cells in a worksheet in …

excel vba excel-2010