# 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.

7,411
questions with no upvoted or accepted answers

**7**

votes

**1**answer

29k views

### Intermittantly can't edit Excel cell

I use Microsoft Office 365 ProPlus running over Windows7 64 Enterprise. While I work on an Excel spreadsheet, it will often refuse to let me edit a cell. I click in the formula bar but the editing ...

**5**

votes

**1**answer

112 views

### Why is the implicit intersection operator changing the behavior of my formula?

Since an update I have from Excel, which induces the automatic insertion of the implicit intersection operator @, my formulas have changed behavior in Excel workbooks.
I noticed the problem appeared ...

**5**

votes

**1**answer

226 views

### Delete or create Excel cell cell style group

In Excel, the built-in cell styles are grouped. There is "Good, Bad and Neutral", "Data and Model", "Themed Cell Styles", etc:
Is there a way to interact with these groups? Like, can I delete an ...

**5**

votes

**1**answer

211 views

### MS Excel: Displaying custom lower error bars

I have an odd issue with custom error bars in MS Excel 2016 (from MS Office 365). The upper error bars are showing but not the lower ones. At least not all the time... only once in a while...
See the ...

**5**

votes

**1**answer

619 views

### Excel- How do I find common text values from multiple (>2) rows?

This is essentially a variant of the question asked here:
Excel- How do I find common text values from multiple (>2) columns?
In this case, however, instead of multiple columns of data I need to ...

**5**

votes

**0**answers

3k views

### Key command for move cursor to next different value in column in Excel

Some Excel jockey told me how to do this once, but I've forgotten.
Basically I have a huge list sorted by a STATUS column. I'd like to press the down key and go to the next changed value in the ...

**4**

votes

**2**answers

2k views

### Determine order of 'refreshes' when using Refresh All

Is there a particular order in which tables and connections are refreshed in Excel when using the Refresh All on the data tab?
For example, suppose I have a table that is sourced via an ODBC or SQL ...

**4**

votes

**1**answer

110 views

### Excel 2013/2016 not updating values while workbook is minimized

I have the following setup:
1 Workbook named Workbook1 with the value 123 in A1
1 Workbook named Workbook2 with value =[Workbook1.xlsx]Sheet1!$A$1 in A1
Now, when I go and change the value of ...

**4**

votes

**1**answer

710 views

### Respond to SharePoint Survey through VBA

How can I respond to SharePoint surveys through VBA? I am trying to track a workbook's usage through a macro but I can't seem to figure it out or even the proper search terms to to search.
Any ...

**4**

votes

**1**answer

1k views

### How do I stop my account name appearing in Office application title bars?

I have an Office 365 Subscription with Office 2016 installed. All of my Office Apps including Word, Excel, Access and PowerPoint include my name in the application title bar, near the top right corner,...

**4**

votes

**1**answer

2k views

### Function names in international versions of Excel

I'm writing a documentation how to use some Excel functions in a rather company specific context for novice users.
I noticed that the functions seem to have completely different names in non-English ...

**4**

votes

**0**answers

742 views

### Optimize row height/column width in Excel = minimize white space

I often create tables in Excel where some cells contain a lot of text while others just contain a single digit or some other short value. With wrap text in cells enabled and then a combination of ...

**4**

votes

**0**answers

54k views

### How do I create a table with multiple header rows

How can I create a table in Excel that has two or more headers rows. I want to keep the range as a table so I can use the built in tools such as re-sizing, totaling, formatting, etc...
I saw a ...

**4**

votes

**1**answer

2k views

### Excel VBA : SQL query handles error

I have SQL that I can use in Excel 2013 to get the info from the Access database and it works using the SQL directly in a connection, but now I want to run it from VBA instead so I can use some ...

**4**

votes

**1**answer

2k views

### How to default into edit mode instead of insert mode when entering content into a cell?

When I directly start to type content into a cell, Excel is in Input Mode, which means I could easily reference cells in formulas. Unfortunately most of the time I do not enter formulas, but simple ...

**4**

votes

**2**answers

4k views

### Excel and tab delimited files, using Carriage return and Line Field

How do you introduce a CR and LF into a cell so when it is saved as a Tab delimited text file, the importing program will recognize the CR and LF?

**4**

votes

**1**answer

8k views

### How to change Excel Pivot table “Report Filter”s values cell formatting

My Excel is in Finnish, but don't let that bother you...
First Report Filter "Kupi" has only number values in my source table, for example 643203, 3533, 253244, etc. How ever in Pivot's "Report ...

**4**

votes

**0**answers

4k views

### Excel 2010 crashes: Excel.exe 0xc0000005 when trying to highlight from pivot table

One of our users uses pivot tables a lot. She often called me about Excel crashing from time to time without being able to reproduce the problem. Today we have found a way to reproduce the crash every ...

**4**

votes

**1**answer

2k views

### Excel 2007 - cannot open the clipboard

Every now and then within Excel when I do Ctrl-x (cut) or Ctrl-c (copy) I get the pop-up message 'Cannot open the Clipboard'.
I can't see any particular pattern to it but it's very annoying when it ...

**3**

votes

**0**answers

80 views

### How to calculate average number of days, hours and minutes in excel

Can anyone help me please to calculate the average number of days, hours and minutes in excel? It is to calculate the average time taken to complete maintenance jobs.
To start I merged the date and ...

**3**

votes

**1**answer

27 views

### Efficient way to find last vector element that is a member of a set

I have a spreadsheet where column A lists the days of a month (1-Jan, 2-Jan, ...), column B lists the corresponding days of the week (Fr, Sa, Su, Mo, ...), and column C contains various notes that can ...

**3**

votes

**2**answers

45 views

### Assigning different value to a specfic number for caculation

First, I'm new here and I'm would be so genuinely grateful to any guidance or help with, what might be, a simple question.
I'd like to assign the value 1069 to 30. And then divide the number displayed ...

**3**

votes

**1**answer

89 views

### Excel VBA: Application.Tranpose on an array gives Run-time error 438

I have a VBA code that gets data from a column of a structured table and puts it in a column of another structured table like this:
Dim TopNTickers As Variant
Dim NoOfTickers As Integer
Dim ...

**3**

votes

**0**answers

33 views

### Changes to User Defined Functions in Office 365 Subscription based

I've seen issues a couple of times when using User Defined Functions with Excel from subscription-based Office 365.
When a workbook is opened with these formulas, they are automatically updated. ...

**3**

votes

**0**answers

41 views

### Searching for possible solutions/workarounds to creating a Master Excel workbook

I'm trying to find solutions for creating a master template in Excel. We have almost 100 Excel workbooks where data in them varies but the formatting and cell and row layout including header names ...

**3**

votes

**1**answer

705 views

### How to turn on or off editing invisible cells when filtering?

When I filter out a row in excel, if I edit the entire range (including the cell that is filtered out), only visible cells get edited. When my boss does this on his computer, the entire range gets ...

**3**

votes

**1**answer

3k views

### Import Vcard (.vcf file) to Nokia 3310 3G phone

I want to import a .vcf file (with many contacts exported from an iphone) into a Nokia 3310 3G cell phone. I'm doing a test file first. The procedure is:
load the file on a PC
change the format of ...

**3**

votes

**0**answers

17 views

### Excel csv-import into table referenced by name

I have a worksheet called raw_data where I import some data via the Data-Import Wizard. This created a new name-referenced range called abc.csv.
However if I try to create a table on another ...

**3**

votes

**1**answer

106 views

### How do i paste data (which has no hidden cells) into a worksheet which has hidden columns

Is it possible to prevent data being pasted into the hidden columns in one copy/paste movement rather than having to copy/paste multiple times?

**3**

votes

**1**answer

706 views

### Why does Windows Defender slow my Excel file saving, even if the xlsm file type is excluded?

I'm experiencing a strange issue with Microsoft Excel (Office 365 MSO 16.0.11126.20234 32B) and Windows Defender running on Window 10 Pro (1809 Build 17763.253 64B) . When I save a macro-enabled Excel ...

**3**

votes

**0**answers

2k views

### Updating List in Sharepoint Online (o365) via Excel/VBA

I am currently using VBA to update/create new sharepoint list items via SOAP.
My IT dept has advised that they are migrating to SharePoint Online and the same code no longer works, I believe due to ...

**3**

votes

**0**answers

1k views

### How do I get a cross-join with power query to “remember” values associated with it?

Let's say you have a basic Excel cross-query. You have two lists:
A
B
C
and
X
Y
You cross join them (Cartesian join them), and get the following table:
A - X
A - Y
B - X
B - Y
C - X
C - Y
Now, ...

**3**

votes

**2**answers

3k views

### Copy many formulas from one workbook to another without pasting in reference workbook

I have a sheet like below. I want to copy all formulas from workbook B into A but without the reference to workbook B.
when I do it now I currently get a link in all my formulas to workbook B. But I ...

**3**

votes

**1**answer

800 views

### What is the “next cell character” when coping and pasting from a table?

You know when you copy a row from a table and paste it into another one it is in the correct place. So what is the character that is between cell values when this operation is performed.
Eg. I have ...

**3**

votes

**1**answer

52 views

### How do I know if Excel has recovered all data with problematic content?

I downloaded an Excel created by DataTables but when I open it I'm greeted with this ambiguous error:
I select Yes and the Excel opens with seemingly all of the data, but it's such a big spreadsheet ...

**3**

votes

**1**answer

1k views

### TEXTJOIN() on an array incorrectly returns a blank

TL;DR: TEXTJOIN() on an array returns a blank - can't use VBA to solve the issue in an alternative way.
I've created several sheets with heavy dependence on Array functions due to limitations ...

**3**

votes

**2**answers

5k views

### Missing Paste (P) option in Excel 2016

I'm copying some data from a webpage which is tabulated. When I click Ctrl+C in Excel 2010 and Ctrl+V to paste, it pastes correctly.
However, in Excel 2016, the Paste (P) option is not there.
Only - ...

**3**

votes

**0**answers

135 views

### Excel formula to work out time elapsed between dates based on very specific criteria

I have a dataset with approx. 29,000 entries related to approx. 3000 unique individuals’ admission and departure dates to and from a service over a period of time.
I’m trying to collapse each ...

**3**

votes

**0**answers

1k views

### Dynamic Horizontal Axis Crossing Excel Bubble Chart

I'm attempting to make a 4 quadrant bubble chart in Excel to compare some competitor companies. I've input all my data from a pivot table, with 4 slicers to filter what the bubble chart is showing you....

**3**

votes

**0**answers

204 views

### Formulas Changed to Reference Last Row When I Close and Open Excel File

I have no idea what is causing this issue, but when I reopen an Excel file, formulas that reference cells will change the reference cells at the very end of the sheet.
Example:
Super simple spread ...

**3**

votes

**1**answer

2k views

### Writing Numeric Values from Excel Cells to Text File without Scientific Notation in VBA

I'm having some trouble with a VBA module in Excel. I have a script that references cells in my spreadsheet and writes the values in comma separated lines to a text file.
The way I do it boils down ...

**3**

votes

**0**answers

78 views

### Excel (Mac) updates, disable banner

Is there a way to disable for ever and ever and ever this annoying banner?
I tried to remove the update service, I tried to set the updates to manual, I had it check for updates so that it could ...

**3**

votes

**1**answer

515 views

### Define Name for Worksheet Scope in Microsoft Excel for Mac V15.38

I am trying to create named references that have a Worksheet scope in Microsoft Excel for Mac V15.38.
I want to set up a template sheet that gets duplicated multiple times (example: a template sheet ...

**3**

votes

**1**answer

344 views

### How to use Excel to get a Function Equation from a trendline?

I am struggling with Excel right now. What I have is a graph which can be approximated by a polynominal formula. I have values for X and Y Axis and want to get the equation of the trendline. To stay ...

**3**

votes

**0**answers

220 views

### Weird watermark when pasting Excel graph as picture with gridlines

When I paste an Excel 2016 graph as an image in Word (also 2016), if the graph has gridlines, the image displays some kind of watermark in the center, like this: .
I know the problem are the ...

**3**

votes

**0**answers

922 views

### What are the security risks to enabling editing in Excel and Word, if macros are disabled?

I'm using Office Professional Plus 2016. I often receive Excel spreadsheets and Word docs from clients and need to make small changes before sending them back. Assuming that my macro settings are set ...

**3**

votes

**1**answer

1k views

### Keeping locked cells when copying a worksheet

How do I copy an Excel worksheet, with protected cells, onto a new sheet and retain the locked cells? I have tried the normal protection sequences but every time I copy the sheet, the new sheet has ...

**3**

votes

**1**answer

2k views

### Can I automatically sort a grouped and stacked pivot chart by a sum of values without showing this on the chart?

I am working with data in groups in Excel. I currently have a pivot table and chart set up with:
Rows: symptom name grouped into one of four international severity grades
Columns: four datasets - ...

**3**

votes

**0**answers

2k views

### Prevent Excel's clipboard from “taking over”?

I'm an encountering a weird problem with Excel, and it's especially annoying because it wasn't happening yesterday, and hasn't happened ever before. Here's an explanation of what I'm doing:
I copy a ...

**3**

votes

**3**answers

133 views

### Excel data in rows and columns to be reformatted

I have data in Excel in a staggered format. There is a customer ID in the left-most column and the details of that customer are in different rows within different columns. I need to rearrange the ...