# Questions tagged [microsoft-excel]

A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function.

**71**

**11**answers

### How to “unpivot” or “reverse pivot” in Excel?

**32**

**17**answers

### Display Blank when Referencing Blank Cell in Excel 2010

**75**

**10**answers

### How can I set Excel to always import all columns of CSV files as Text?

**6**

**2**answers

### Turn one row into multiple rows in Excel

**40**

**8**answers

### Excel function that evaluates a string as if it were a formula?

**110**

**15**answers

### Open Excel files in new window

**2**

**1**answer

### How can I auto generate date based on number of contacts in a company?

**22**

**4**answers

### Excel - How to vlookup to return multiple values?

**9**

**2**answers

### How do I split one row into multiple rows with Excel?

**13**

**11**answers

### Adding more than 15 digits in Excel

**219**

**13**answers

### Easiest way to open CSV with commas in Excel

**67**

**18**answers

### Excel Auto-Fill a Series Without Mouse (Keyboard Only)

**10**

**5**answers

### How to combine values from multiple rows into a single row in Excel?

**46**

**11**answers

### How to compare two columns and find differences in Excel?

**15**

**7**answers

### Comparing Similar Text Strings in Excel

**322**

**7**answers

### How do I get the distinct/unique values in a column in Excel?

**27**

**7**answers

### Apply Formula to a Range of Cells without Drag and Drop

**11**

**4**answers

### Remove password from an Excel Document

**185**

**9**answers

### How can I “group by” and sum a column in excel?

**48**

**2**answers

### Prevent Excel from clearing copied data for pasting, after certain operations, without Office clipboard

**1**

**2**answers

### How to Split one column in Excel into multiple columns of 55 rows

**2**

**3**answers

### How do I transpose data in columns to rows?

**32**

**6**answers

### Need two Excel windows side by side, on different monitors, in the same instance

**4**

**3**answers

### How to fill a large series (over 10,000 rows) in Microsoft Excel without dragging or selecting cells?

**6**

**2**answers

### Excel 2007 transpose/combine multiple rows into one

**6**

**2**answers

### How do I use Excel 2010 Personal Macro Workbook?

**3**

**1**answer

### Sum Values in One Range Based on Criteria in Another

**5**

**1**answer

### Excel 2010 conditional formatting: selectively highlighting duplicates

**132**

**10**answers

### How do I join two worksheets in Excel as I would in SQL?

**120**

**9**answers

### How to get Excel to interpret the comma as a default delimiter in CSV files?

**95**

**16**answers

### How to make Excel's “Auto Fit Row Height” feature actually auto fit the row height?

**56**

**22**answers

### Unable to get Excel to recognise date in column

**36**

**7**answers

### How to count number of distinct values in a range?

**2**

**2**answers

### MS excel - assigning “categories” based on keywords

**11**

**2**answers

### Automatically update cell in Excel with current timestamp when another cell is changed

**1**

**1**answer

### Excel – Checking if the content of several cells exists inside one main cell

**2**

**2**answers

### Excel: How to treat multiple lines as one while sorting?

**157**

**14**answers

### Convert a column into a comma separated list

**122**

**8**answers

### Find Items in one column that are not in another column

**76**

**4**answers

### Can I use an excel formula to extract the link location of a hyperlink in a cell?

**101**

**8**answers

### Cells not updating automatically

**103**

**6**answers

### Turn off scientific notation in Excel

**44**

**15**answers

### Excel hyperlink not redirecting properly (bug?)

**17**

**3**answers

### Why is Excel truncating my 16-digit numbers? [duplicate]

**26**

**4**answers

### Excel conditional formatting fragmentation

**7**

**5**answers

### How to add/subtract months from given date in Excel

**7**

**5**answers

### How can I merge hundreds of Excel spreadsheet files?

**3**

**1**answer

### Mirror cells so that a change in either cell updates the other

**1**

**2**answers

### How to identify cells in Column A that contain any of the values in Column B

**1**

**2**answers