All Questions
Tagged with microsoft-excel formatting
240
questions
6
votes
1
answer
618
views
Why is Outlook Formatting this Column Header into text wrapped (2 lines) when pasting from Excel and how can I stop it?
I'm trying to spend a moment to figure out how to block Outlook from messing with my tables each time I paste one. Basically, each time, I have my data so there is no "text wrapping" and its ...
0
votes
1
answer
1k
views
Mail Merge messing decimal places
When using an Excel spreadsheet as input to Word Mail Merge feature, the decimal places get all messed up:
8,1 becomes 8,0999999999999996
7,0 becomes just 7
(commas are the decimal separator, and ...
0
votes
1
answer
99
views
Excel - how to handle custom timestamp format
I have some measurement data from a datalogging software, saved as CSV, and one column contains time stamps like this:
12.04.2024 15:11:32:684
12.04.2024 15:11:35:752
The format of this is:
dd.mm....
0
votes
1
answer
28
views
Where is the Sparkline tab in the Show group for Excel?
How would I display the high points?
screenshot
Copilot says:
You Apply Blue sparkline color and display the high points for the
sparklines.
Copilot Certainly! Let’s create sparklines in Excel, apply ...
0
votes
1
answer
31
views
How to use conditional formatting based on a different column?
Looking to format a column background color using conditional formatting based on the integer value from a different column. Where or how is the second column referenced?
Bing AI, copilot, says:
...
1
vote
1
answer
383
views
How to format Y axis in an Excel chart in days, hours, minutes?
I have an Excel chart tracking time taken to complete a task. I managed to use rows in my spreadsheet to apply custom data labels for the graph, but it doesn't match up to the Y axis of my graph.
I ...
1
vote
1
answer
61
views
Excel conditional formatting highlighting different cells in range
I need to setup conditional formatting to highlight any cells in the range that are not equal to the first cell. I have attached 2 pictures the first is how the data is typically entered and I have ...
0
votes
2
answers
525
views
Multiple Currency Number Formats in the Same Excel using Custom Number Formatting
I have an excel which has multiple columns of numeric values / amounts, which are all in different currencies in different column. One column is in one currency.
I have my regional setting set to a ...
1
vote
1
answer
838
views
How to remove values in conditional formatting
I have conditional formatting rules applied to a workbook. When a user selects No in Row 1 for example, Row 2 and subsequent rows get greyed out. When user selects Yes in Row 1, Row 2 and subsequent ...
0
votes
2
answers
137
views
Excel datetime format issue, possibly locale dependent
I'm working on a Belgian Excel 365 workbook. I have just imported a list of dates, looking like this:
dinsdag 5 december 2023 11:55:55
dinsdag 5 december 2023 11:55:56
dinsdag 5 december 2023 11:55:57
...
0
votes
1
answer
65
views
Excel - status (online/offline) corresponding to concrete number
I cannot deal with the below tasks, and need your help!
The thing is that I need to use a formula to solve this (not just copy-paste, assuming that the data will be much bigger). Basically, I need to ...
0
votes
1
answer
96
views
Convert duration in XXm, YYs format to time value
In Microsot Excel, I have string data that represents duration of an event:
duration
40s
5m, 40s
59m, 59s
I need to convert the values to time (in adjacent column) so that I can format and sort ...
0
votes
0
answers
24
views
Cells number format breaks in one column only if multiple cells are moved
I have a table where I keep track of best times & corresponding dates in pairs of cells. Time on top with the date below it, stored in range [B3:E10]. The time values are entered into the formula ...
-1
votes
2
answers
741
views
How to copy/paste cells from a conditionally formatted sheet to another file or sheet with formatting but without conditional rules?
I have an excel file "Book1" with conditional formatting enabled on "Sheet1".
Conditional rules are based on a formula.
For example, highlight the entire row blue if the value in ...
0
votes
1
answer
59
views
How can be column incluted into rows?
There is the table in MS Excel or LO Calc.
How can be it converted to this view of the table?
The transformation using links (within the same table) to the initial version is allowed.