Questions tagged [microsoft-excel-2019]
78 questions
15
votes
7 answers
Set Excel to search within entire workbook by default
In Microsoft Excel, when I search using CTRL+F, by default it only searches within the current worksheet.
How can I set it to search within the entire workbook by default? I have Office 2010. Is this even possible? Is it possible to set this for a…
Joel Coehoorn
- 28,637
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
- 6,865
4
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
- 884
3
votes
1 answer
Populating a column with filtered values from another column in Excel
I have the following excel spreadsheet:
A B C D E F G H
1 # Size Age Color =B1 =C1 =D1
2 1 Big
3 2 Small 2983 Yellow
4 3 3459 Red
5 4 Big Yellow
6 5
7 6 …
Mate de Vita
- 393
3
votes
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
- 19,327
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
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
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
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
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
2
votes
0 answers
Change font in Excel forumula bar
Is it possible to change the font type in Excel's formula bar? I want to use a monospace font to make my formulas easier to read.
I'm using Office 365, Excel version 1904.
Thanks in advance.
Coen Visser
- 21
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,062
1
vote
4 answers
How to average the last N row in Excel 2019 with blank cells
I'm trying to average the last N rows in Excel, but I have some blank (and merged) cells; in something like this:
Example
A
1
2
x
3
4
5
6
7
y
8
9
10
for example, wanting average the last four rows it should average A8…
Mauro
- 235
1
vote
1 answer
Nested If's with Vlookups not working in Excel
I have an MS Excel 365 (with current patches) spreadsheet that tracks mileage and tolls to various locations. I am trying to build in logic that won't populate mileage and tolls if I have 2 entries to the same location on the same day (as it would…
cgru
- 21
1
vote
1 answer
Disable truncation of labels of treegraph in excel
I'm creating a treegraph in Microsoft Excel, but my labels get truncated unnecessarily. See the image below:
As you can see, the second digit of the labels of the smallest rectangles, which are the numbers 12 to 16, have wrongly been replaced with…
Bassie-c
- 128