Help with Excel pop out window
I found a free spreadsheet online that I wanted to use. I am able to manipulated it for my use case. But the original creator added these call out fields that I cannot seem to find out how to delete or change the syntax. I can't even find out what they are called. Any suggestions?? In the attachment, I select a filed and a little yellow box pops up. How do I change or delete these??
Excel formulas starting to include current sheet name
Hi I recently noticed that formulas in excel starting to automatically include the "current" sheet name after leaving and coming back to the sheet (example below). I don't remember this used to be the case but I could be wrong. Does anyone have a similar experience or can confirm if this is correct? Is there a setting somewhere I can turn this on and off? Example: I have 2 tables (1 per sheet). After clicking on Sheet2 to select the cell I want to sum, coming back to Sheet1 and referencing any cells will include "Sheet1!" in my formula. I believe previously the formula omits "Sheet1!". Both ways are useful in different scenarios but wondering if I have missed a trick to "turn on and off" how it behaves. Thanks!
Why can’t an Advanced Filter be re‑applied like an AutoFilter in Excel?
Hello everyone, I’m trying to clarify a technical question about how Excel handles Advanced Filters versus normal AutoFilters. In my course, I was asked to use an Advanced Filter to display only specific records in a dataset. I applied the Advanced Filter correctly, and the results were displayed as expected. However, when my instructor tried to “remove the filter and apply it again,” Excel did not behave like it does with a normal AutoFilter. Because of this, the instructor assumed the filter was not done correctly. From what I understand, this is actually normal behavior, because: Advanced Filters are not dynamic They do not remain active after being applied They do not have the “Reapply” option that AutoFilters have To use the filter again, you must run the Advanced Filter command manually each time The result is static and does not update automatically Microsoft’s documentation confirms this behavior. For example: “The Advanced Filter command is not an interactive filter. To change the criteria or reapply the filter, you must run the command again.” Source: https://support.microsoft.com/es-es/office/filtrar-por-criterios-avanzados-4c9222fe-8529-4cd7-a898-3f16abdff32b So my question is: Is this the expected behavior of Advanced Filters in Excel, and is it correct that they cannot be re‑applied automatically like AutoFilters? I want to make sure I fully understand the intended functionality so I can explain it properly. Thank you in advance for your help.Problems to move cursor / Problèmes pour bouger mon curseur
Hi everybody, English and French below. I'm strangely unable to move cursor with my arrows or other means. On my keyboard, the 3 lights over the numbers (and Verr num, /, * and -) are illuminated. Can somebody help me? Salut à tous. Je suis bizarrement incapable de bouger mon curseur autrement qu'avec ma souris. Pas très pratique pour passer d'une cellule à l'autre. Sur mon clavier, les trois lumières situées au-dessus de mes chiffres (et Verr num, /, * et -) sont allumées. Quelqu'un pourrait m'aider?
Calculating and adding time
I am trying to figure out how to automatically calculate time differences for a delayed racing start time. I have: a rating which provides a handicap correction factor: PHRF Tod A Sec/ Mile correction number A Total correction in Seconds (based on a distance) This I figured out. I have a set start time for the first entry at 11:00:00 I need to figure out the Start time for the delayed boats as shown in the diagram, but I don't know what formulas will do this. This diagram is taken from a pdf document.
