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 ...
- 1,455
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 ...
- 5
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:
...
- 5
1
vote
1
answer
382
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 ...
- 183
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 ...
- 11
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
...
- 2,281
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 ...
- 1,732
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
-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 ...
- 183
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.
- 101
0
votes
2
answers
210
views
How do I format a target cell based on a source cell, using VBA?
I'm looking to copy the format of a cell within the table table1 to cells with matching text within the second table table2.
So for instance: NOT(H) is showing as green in table 1 and I want it to ...
- 1
0
votes
0
answers
2k
views
Excel - paste *only* number formatting
Is it possible to copy/paste only number formatting in Excel.
There are various paste special options.
In particular Formulas/Number Formats and Values/Number Formats. But is there a way to paste only ...
- 273
0
votes
1
answer
1k
views
Fill a cell when empty, and past a date in another column
I need a cell in column "B" to fill red, if it is empty and the date is past the date on column "M"
I have tried googling it, and there are no answers to help.
Thanks for your help
- 1
2
votes
0
answers
212
views
Stacked Area Chart Excel, 3 Series Negative Problems
I am trying to create a chart similar to this original chart. I'm having troubles with the negative values. The red area falls negative when I chart it as a stacked chart.
It seems like it should be ...
0
votes
3
answers
223
views
Data Formatting in Microsoft Excel: Cell formatting, Text formatting, and Number Formatting [closed]
Formatting text or numbers can make them appear more visible especially when you have a large worksheet.
Formatting in Excel is a simple process of modifying or manipulating data in spreadsheets from ...
user1806663
1
vote
0
answers
237
views
Excel VBA Macro: Formatting Duplicates and Uniques
I have a spread sheet where each row consists of information about a member of a group. In each cell of column B there is an integer that represents each person (i.e., think of an member ID). All ...
- 11
-2
votes
1
answer
48
views
How to use conditional formatting in excel for a crosstabbed table with multiple conditions?
I am having trouble in excel using conditional formatting for my table. I need to highlight the sample values that are greater than screening_1 or screening_2 for each individual row.If the value is ...
- 1
0
votes
1
answer
2k
views
Conditionally formatting left align for a cell with text thats separated by multiple lines
I'm trying to write conditional formatting that will handle left aligning text in a cell that is normally in a range that's centered. The data in the cell could look like the following with each line ...
- 123
1
vote
1
answer
3k
views
How can I get Excel to use conditional formatting per day of the week using dates and not the words "Monday, Tuesday,"
I am working on a delivery schedule for the company I work for and we want to be able to have the dates color coded by days of the week. But we often have several deliveries on the same date, so when ...
- 11
1
vote
1
answer
3k
views
Removing outer white space around a bar graph
It might be a bit of a simple question but on
I want to remove the outer white space around the graph but I have no idea if its possible or how to do this. Any help woule be appreciated.
- 11
0
votes
2
answers
30
views
Excel - Total Count of multiple reasons
Ideally, I am looking for a solution where I can see the total number of reasons why the device failed, which is currently recorded in a dropdown list on excel (with option for multiple entries). When ...
-1
votes
2
answers
242
views
MS excel not coping data in correct format from csv file
I am coping data from csv file
it contains tables
in that table there is column name PostedDate
when i copy that PostedDate column in excel it shows wrong formatting (ie instead of / it shows -)
...
0
votes
1
answer
432
views
Can't remove hidden characters?
I'm trying to make a simple tool for my job where I can decline job listings for a specific reason simply by checking their boxes and then copying and pasting the final cell where it will compile all ...
0
votes
1
answer
75
views
Formatting whole and decimalised numbers differently in Excel
I'm having some difficulty formatting some data correctly and after looking around extensively in similar threads such as here, I've come looking for help.
I have two similar datasets (X and Y) and ...
- 1
0
votes
1
answer
327
views
Copy cell data to second sheet and place in certain cells depending on criteria
I have a list of names on one sheet. I would like to be able to type something next to a name and that name is placed in another sheet in the correct place.
For example if I type A1 1A next to a name, ...
