Skip to main content
Super User

Questions tagged [microsoft-excel]

Ask Question

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.

13 questions from the last 30 days
Newest Active Bountied Unanswered
0 votes
0 answers
38 views

enter image description hereExample of a test workbook with conditional formatting. Using Formulas shows results on display but does not print.
Paul Wagner's user avatar
  • 1
0 votes
1 answer
58 views

Sorry for this fuzzy question, it just came into my mind, I don't know whether there's a correct term for this kind of question. Let say we have a table of timeline recording types of events: Event ...
jamgoo's user avatar
  • 1
0 votes
1 answer
94 views

In Excel, if you press End, it doesn't jump to the end of the current line. It activates End Mode, which is visible in the status bar. How to make the End key select the last filled cell in the ...
Dr. Gut's user avatar
  • 1,110
1 vote
1 answer
54 views

In Excel, I can go to Developer->Macros to view all macros in open workbooks. I can then select to only show macros in the active workbook: However, I often have multiple workbooks with lots of ...
Boom's user avatar
  • 183
1 vote
1 answer
119 views

I have a situation in Excel where I want to use conditional formatting to change the text color based on cells values so the lowest values become red, and they get progressively bluer as the values ...
Boom's user avatar
  • 183
2 votes
2 answers
71 views

I have a dataset that is not useful to me in its current format, and I lack the Excel knowledge to automate what I'd like to accomplish. The current data set contains: Column A: An ID number. ...
CheapLabor's user avatar
  • 21
12 votes
3 answers
2k views

I have a list of terms (Before). I replace all occurrences of |[*] Carbamidomethyl (C) with nothing, in order to remove them. This generates the column in After. I observe that several occurrences ...
Tim Kirkwood's user avatar
  • 223
0 votes
0 answers
38 views

Using Excel Online - a few select cells in tables are changing font size when the value of the number is 100 or higher. No conditional formatting set. Format painter will change them to the correct ...
user3255398's user avatar
  • 1
1 vote
2 answers
215 views

I need a formula that returns a value based on data like this: Here's a graphical explanation of what I'm supposed to get out of the data: If the data looked like this: then it would be very easy, ...
Erundil's user avatar
  • 33
0 votes
0 answers
22 views

I created several PivotCharts using PowerPivot on a single table, just showing different fields/aggegations and using a shared data slicer. This worked fine during build-up. I now saved and reloaded ...
Honeybear's user avatar
  • 192
3 votes
2 answers
545 views

I cannot figure out how to search through the list (in Column D), under Plan Name to find the unique name and then populate a list under B2 (where the result box is). What is the best way to ...
Paul's user avatar
  • 201
1 vote
1 answer
53 views

I have an array of data like this: As you can see, in rows 2 and 3 the cells are multilined. I'm looking for an Excel formula that would turn the above into this: splitting the multi-row cells into ...
Erundil's user avatar
  • 33
0 votes
4 answers
64 views

I have a list of items with attached attributes. Each has more than one attribute, and there are a lot of attributes, so each alike attribute does not have its own column. I would like to have a ...
Opal's user avatar
  • 11