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,794 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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 ...
Arthur Attout's user avatar
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 ...
ElRudi's user avatar
  • 424
5 votes
1 answer
328 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 ...
Steeven's user avatar
  • 283
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 ...
Russ's user avatar
  • 51
5 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 ...
mthomas's user avatar
  • 153
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 ...
Damiqib's user avatar
  • 113
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 ...
Mike Cole's user avatar
  • 441
4 votes
0 answers
726 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 ...
Ryan Griggs's user avatar
4 votes
1 answer
234 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 ...
Rand Random's user avatar
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. ...
Joseph's user avatar
  • 343
4 votes
1 answer
791 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 ...
wizlog's user avatar
  • 13.3k
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 ...
emanuel cristian Mocean's user avatar
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 ...
k rey's user avatar
  • 149
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 ...
Jim J's user avatar
  • 41
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 ...
Pier-Luc Faucher's user avatar
4 votes
1 answer
3k views

Automatic LaTex document generation from Excel spreadsheet

I have some data in an Excel file from which I have to generate a report. I repeat this task fairly regularly and am looking to automate it. I have a LaTeX project into which I usually just copy data ...
Bowler's user avatar
  • 141
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 ...
Paul's user avatar
  • 803
4 votes
2 answers
13k views

Are Excel table headers always converted to text?

I am trying to get table headers containing dates to auto-fill properly, so that they increase by one day between columns. Unfortunately, Excel seems to treat table headers as text regardless of the ...
Mr Ethernet's user avatar
  • 4,311
4 votes
1 answer
13k views

Single-Window Mode for multiple worksheets

Is it possible in Microsoft Excel 2013+ (the plus currently means 2016 too) to open multiple sheets in the very same work space? Basically View=>Split but for different worksheets. The reason I ask ...
LWC's user avatar
  • 926
3 votes
0 answers
783 views

Why does Excel display incorrect modified times when listing recent files?

When I try to open a file in the recent files list in Excel I'll often find that a workbook I worked on yesterday or the day before is not in the list. When I expand the list to include older ...
Simon Elms's user avatar
  • 1,005
3 votes
2 answers
63 views

Inserting the hyperlink value if there is one but do not enter anything (leave blank) if there is no value

Currently I am using this on a new added column to extract the hyperlink. How do I add code that will not enter any value (leaving it just blank) if there is no URL. Actually what I needed was when ...
mantrawoods's user avatar
3 votes
3 answers
3k 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 ...
Frederic Bayer's user avatar
3 votes
0 answers
548 views

Unicode ☑︎ becomes 🤵🏻 emoji in Excel on macOS Catalina (10.15.7)

I am using Excel 16.46 on macOS Catalina 10.15.7 and here is what I am experiencing. Using macOS's character viewer — command+control+space — I've entered the “ballot box with check” Unicode ...
Unrelated's user avatar
  • 149
3 votes
1 answer
49 views

How can I use Excel to calculate the number of recent, consecutive fiscal years someone has made a gift to my company?

I am working at a nonprofit and we are trying to get a project off the ground where we send people postcards celebrating how many years they have been giving to us. I am working with Excel in Office ...
Sophie39DS's user avatar
3 votes
1 answer
41 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 ...
shankar2k's user avatar
3 votes
0 answers
966 views

When importing CSVs, does Excel have a limit of 32,767 characters or 32,758 characters?

According to the documentation, Excel has a limit of 32,767 characters per cell. However, when I save a CSV file that looks like this: "Cell with exactly 32,767 characters........","...
Pikamander2's user avatar
3 votes
2 answers
54 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 ...
Drd4's user avatar
  • 31
3 votes
0 answers
82 views

Why is text typed into other cells appearing in a cell with no formulas in a workbook with no macros?

I have a workbook with a few sheets of data, one PowerQuery, a few pivot tables. On one of the sheets, when I type into some cells at the top of the workbook, whatever I type is repeated in cell B3. ...
FlexYourData's user avatar
  • 6,840
3 votes
1 answer
288 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 ...
Kenny's user avatar
  • 55
3 votes
2 answers
508 views

MS Excel 365 Not Sorting

I have recently started experiencing a weird bug with excel, for some reason it has stopped sorting columns. It does not matter the way I try to sort, it just does not do it, however, filtering does ...
EOZyo's user avatar
  • 31
3 votes
0 answers
48 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. ...
Susan Joyce Gross's user avatar
3 votes
0 answers
63 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 ...
anahka-7's user avatar
3 votes
2 answers
1k views

Keyboard Shortcut - Highlight to bottom of range based on data one column over

I work with similar data pulls frequently and am trying to be more efficient in how I transform them. Typically, I will autofill a field down to the end of the range one column over by using the ...
Alex Keyes's user avatar
3 votes
3 answers
7k views

When a Google Sheet is exported to Excel the line heights of wrapped text are not maintained - any way to change this?

Ive got an issue when exporting an Excel file form a Google Drive Sheet. If i have a large amount of text / data in a cell in Google Sheets i use the wrap text feature so that all the text is ...
sam's user avatar
  • 4,149
3 votes
0 answers
111 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 ...
Philipp Birkl's user avatar
3 votes
1 answer
9k views

Excel Formula to Translate Text into Target Language

I'm looking for a built-in Excel Formula Function to translate text into a target language. I see Google has made a function "GoogleTranslate()" available and was wondering if something equivalent ...
ffejrekaburb's user avatar
3 votes
1 answer
571 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?
Rosie's user avatar
  • 31
3 votes
1 answer
2k 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 ...
michaelf's user avatar
  • 131
3 votes
0 answers
3k 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 ...
Riss's user avatar
  • 31
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, ...
Selkie's user avatar
  • 471
3 votes
2 answers
4k 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 ...
excelguy's user avatar
  • 391
3 votes
1 answer
2k 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 ...
user14492's user avatar
  • 140
3 votes
1 answer
57 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 ...
Anthony's user avatar
  • 151
3 votes
2 answers
2k 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 ...
hooge's user avatar
  • 31
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 - ...
RShome's user avatar
  • 131
3 votes
0 answers
174 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 ...
Jenny T's user avatar
  • 41
3 votes
0 answers
3k 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....
user402253's user avatar
3 votes
0 answers
327 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 ...
BigChief's user avatar
3 votes
0 answers
122 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 ...
Thomas's user avatar
  • 184
3 votes
1 answer
748 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 ...
AMR's user avatar
  • 580

1
2 3 4 5
176