Super User Stack Exchange
Super User Stack Exchange

Questions tagged [microsoft-excel-2019]

66 questions
5
votes
2 answers

Excel - Live filter of list based on another column?

In Excel, I'm looking to get a breakdown of the values in one column (IDs) by the values in another (status). Input | ID | Status | |----|----------| | 1 | Complete | | 2 | Active | | 3 | New | | 4 | New | | 5 | New | | 6 |…
KyleMit
  • 5,992
  • 7
  • 46
  • 61
3
votes
1 answer

Datalabels are missing in dynamic chart

I am trying to create a dynamic chart but the data labels are missing. I add the data labels manually to all headers and then save and close the file. When I open the file and select a different header, they go missing again. Only the chart with the…
Dhruva
  • 435
  • 3
  • 5
3
votes
1 answer

How can I fill a shape in Radar Chart?

I'm struggling to find a way to just fill one shape in a radar chart. An example of what I would like to have is in the image. I tried to start from a simple radar chart and then filling the shape --> I can't find the option; I tried to start from…
spartan15
  • 33
  • 1
  • 3
3
votes
0 answers

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 app) and you click on the Excel window, the first…
Ryan Griggs
  • 854
  • 1
  • 9
  • 21
3
votes
2 answers

Excel shortcut to expand / collapse entire group outline level

I'm trying to find out if there's a shortcut key combination in Excel to expand & collapse an entire group outline level. This would be the the equivalent of mouse clicking on the 1, 2, 3, ... buttons in the top left of the window: I know you can…
James MacAdie
  • 141
  • 1
  • 1
  • 4
2
votes
1 answer

How to identify what a shortcut key is triggering in an Excel workbook?

I've inherited a workbook and a personal macro workbook that operate in conjunction with each other (drawing on a CSV and 2 LST files) to produce a report. The spreadsheet has rudimentary instructions, essentially: Sign on to the server Place the 3…
DWGKNZ
  • 211
  • 1
  • 6
2
votes
1 answer

Calculating totals with hidden cells in Excel

I have a problem with my Excel sheet. "Kolom4" has the product codes. Each code has two rows with data. With each code I want to have the combined values of "kolom11" till "kolom14" from both rows. So for example for product code 10303814140001 I…
Cas040
  • 55
  • 5
2
votes
1 answer

Excel number format adds decimal point for whole numbers

I want to be able to see every digit, but without any padded zeros on the right. So I formatted the cells like this: #,##0.################################################################ However, now Excel is displaying a decimal point for whole…
Giffyguy
  • 1,022
  • 10
  • 22
  • 38
1
vote
2 answers

Excel importing: converting text file with many new lines into single cells instead of multiple

I have a lot of data in a text file and I'm trying to figure out the fastest way to convert what are individual lines in the text file to a single cell entry. Each Person has a number of entries that they may have entered, and I want each Person to…
greyspace
  • 113
  • 4
1
vote
1 answer

How to sum a column based on existance of value in another column

I have the following sheet: I want a sum of individual spending by Frank, John and Nancy in the yellow cells. Each person's spending is denoted by an x. I tried the SUMIF formula, but I don't know how to denote criteria to be the existence of a…
AngryHacker
  • 18,217
  • 67
  • 156
  • 209
1
vote
0 answers

Excel 2019 default encoding for csv files

Problem I'm using Excel 2019 and I have this .csv file(Multiple language) which is in UTF-8 encoding and when I try to open the file, Excel opens it in ASCII encoding — the english characters and numbers are displayed correctly but the other…
muralee_maddy
  • 11
  • 4
1
vote
0 answers

Excel color is abnormal

The Excel setting is Dark Gray, and it turns out to be super black inexplicably when opened today, and there are some dotted lines in the table. I checked online and there are several methods, but none of them worked. Open the print preview ->…
xioacd99
  • 11
  • 1
1
vote
1 answer

Alternative for a filter formula

I used a filter formula to find all data from another sheet and column, that start with "US". In the column, I have about 5000 rows that have different data with different markets. And the next column is the market followed by its serial number:…
Sissi
  • 5
  • 4
1
vote
1 answer

Excel bar graph with error bar

At this point I feel kind of stupid for asking, because I should probably be able to do this. I want to create a graph like seen on the first image below, with each task having its own label on the x-axis and the error bars being individually…
Frederik Andersen
  • 11
  • 2
1
vote
2 answers

How do I get the first row and column to stay visible in Microsoft Excel

When I downloaded the fatalencounters.org data (found here: "download database" ) in a .xslx file. I have Microsoft Office 19 I believe. I noticed in this spreadsheet the first row and column stay the same, so that you can see the name of the…
Jimmy G.
  • 131
  • 4
1
2 3 4 5