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. Also add the the specific version tag (e.g. [microsoft-excel-2019] or [microsoft-excel-365]) as features and functions may vary between them.
8,877
questions with no upvoted or accepted answers
6
votes
2
answers
1k
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 ...
6
votes
1
answer
3k
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 ...
5
votes
1
answer
1k
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
358
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
1k
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
1
answer
9k
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 ...
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
1
answer
21k
views
How can I format cells in Excel to render the HTML they contain?
Given an Excel spreadsheet with cells that contain HTML (in other words, content with markup), how can I get Excel to render that HTML rather than simply showing the combined content/markup? In other ...
4
votes
0
answers
839
views
Microsoft Excel: how to disable the "two click" requirement when Excel window doesn't have focus?
In Microsoft Excel, all versions as far as I can tell (office 2007 to 2019), implement window focus differently than any other Windows apps:
When Excel does not have focus (i.e. you're using another ...
4
votes
3
answers
4k
views
Open desktop shortcut to SharePoint directly in Excel
I have a desktop shortcut to a shared Excel spreadsheet that I use daily. It lives in a Microsoft Teams folder, i.e. on SharePoint. This shortcut opens a browser window asking me if I want to open the ...
4
votes
1
answer
243
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
4k
views
How to split comma-separated values for Pivot Table?
I have data which has the following format:
Electricity
Electricity, Cooling
Electricity, Heat
Electricity, Heat, Cooling
I want to use this data in a Pivot Table so I can count the number of items. ...
4
votes
1
answer
795
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
4k
views
Paste in Excel without splitting on newlines
I have some data in Google Sheets that has newlines in cells.
When I paste into Excel the data is split into rows at those newlines and the other columns remain blank on the "inserted rows".
How to ...
4
votes
0
answers
58k
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 ...