All Questions
Tagged with microsoft-excel formatting
241
questions
0
votes
1
answer
42
views
Turn four rows into running page header in Excel
I have an Excel sheet that I'm trying to format for print. I want to turn the top four rows of the sheet (or quite frankly any four rows, I don't care where they're stored) into the header so that ...
0
votes
2
answers
461
views
Excel automatically changes format from numeric to either date or other number format
I wrote a query in postgresql to get the data I need and want to further analyze it in excel. But everytime I past my numeric variables it either turns into a short date format or a number like 27....
2
votes
0
answers
205
views
in microsoft excel how to define a default language for columns
Hi I'm working on a dictionary and need to have English words in one column and Persian translation in another. but it takes time changing language every time I want to type the English and Persian ...
0
votes
1
answer
279
views
VBA Error in referencing range of another sheet via the Cells option
I have some subs I use to format data in an Excel file.
In particular, I have a sub that I can activate in the sheet("1.Parus") that has the line :
Range(Cells(2, 1), Cells(1000, 3)).Interior.Color ...
0
votes
1
answer
130
views
Excel - #VALUE! error message
I type $1000 in cell D31. I type =D31+50 in cell D32 because I want D32 to show $1050. I then want to copy that formula into the next 100 cells in row D so that the value in each cell is $50 higher ...
1
vote
3
answers
2k
views
Excel MATCH function seems to be broken. Issue description and investigation details. Any explanation or solution to this?
I'm a fairly intensive and experienced Excel user, used to work with INDEX and MATCH functions and with strings, so I am also used to the typical issues with errors with the MATCH function due to ...
0
votes
1
answer
453
views
Excel 2016 Chart > Date and Text on the same Axis
I received an interesting question yesterday during at work. Is it possible to have Date and Text values on the same Axis in Excel Chart, but that this "text" is actually formatted or somehow ...
0
votes
1
answer
312
views
Format series of excel pivot chart based on series title
I have a non-stacked pivot bar chart that is showing two values (Sum of Planned Hours & Sum of Actual Hours) for a number of Series.
What I want to achieve is a formatting rule that if all the ...
1
vote
3
answers
2k
views
How to reorganize vertically repeating data to horizontal?
I have data on 1 variable from 1970 to 2017 from all the countries in the world. this data is organized as one large vertical list, with first a column with the (repeating) country name, then a column ...
0
votes
1
answer
2k
views
Excel Chart data table. Formatting one row (TOTAL) only
Im trying to build a chart and Highlight TOTAL row in data table (that one underlined on screen) ;).
I can format only whole chart data table or nothing.
By a trick I did a "hidden" (no colour and ...
0
votes
3
answers
13k
views
Excel Conditional Decimal Formatting
I am trying to have decimal places display based on the value inside a given cell. I more or less understand how to custom rules work, and have come up with this rule: [>=10]#,##0.0;[<10]0.00
It ...
0
votes
1
answer
4k
views
How to copy from excel rows to word paragraph
How to copy from excel rows to word paragraph.
ex data from excel
1. robin d123 e123
2. morgan f123 e456
paste to word become:
1.
robin
d123
e123
2.
...
0
votes
1
answer
2k
views
Excel apply complicated formula to existing cells value without copy/paste
I want to apply the formula
=TEXT(A1,IF(A1-INT(A1)=0,"0","#.####"))
to existing cells with numbers without doing copy and paste.
The existing spreadsheet is already big and ...
0
votes
1
answer
46
views
If Then fomula for a range of dates
I have been out of practice with Excel for some time and I am stuck.
I am trying to create a formula for a date range and highlight. So for example, if the date in O4 is more than 28 days from the ...
0
votes
2
answers
302
views
Changing the structure of csv data
I'm trying to change data looking like this:
original csv
into this format:
name = "The V Girl";
author = "Mya Robarts";
pages = 341;
imageURL = "https://i.gr-assets.com/images/S/compressed.photo....
0
votes
1
answer
55
views
Can I use conditional formatting in an Excel PivotTable to format cells based on specific fields?
I have the results of numerous tests run on several sub-samples. Many sub-samples make up a sample. Between 5 and 10 samples make up a lot, and I have five lots I'm trying to analyze.
Each one of ...
1
vote
2
answers
1k
views
Highlight rows with identical data in Excel
I have a number of rows within a large spreadsheet that have some identical rows I would like those rows highlighted but only if every cell on the row matches, if random cells from different rows ...
1
vote
1
answer
71
views
How to make dependent cells follow decimal formatting of parent cell that changes from time to time?
I need dependent cells in an Excel worksheet to follow the decimal formatting of a parent cell. I've done this with format painter, but my parent cell decimal requirements change from time to time,
...
0
votes
2
answers
98
views
How to manipulate dates?
How can I change a date in an Excel file
to eliminate the day and be left with only the month and year?
E.g., convert 4/4/2019 to April-2019?
I am aware that I can change the format, but if I do so, ...
1
vote
1
answer
26
views
Decimal Display
I'd like to display decimals in the following way:
3 = 3.00
3.1 = 3.10
3.111 = 3.111
3.111000 = 3.111
Basically a min of 2 decimals, but more decimals displayed if necessary. The exception is if ...
0
votes
0
answers
2k
views
Print / Print Preview does not match normal view for Excel worksheet
I've got a certain worksheet that will not print correctly. An image that takes up a certain amount of space in the normal view looks very different in the Print Preview view. This is the case with ...
2
votes
2
answers
2k
views
Excel Conditional formatting and Offset
I cannot get conditional formatting to copy to the right (with paint brush) because excel references the wrong cells when copied. This is what I need to achieve:
A1 needs to be formatted if Sheet2!E4=...
18
votes
1
answer
74k
views
Stop Excel chart from changing series formatting
I have an Excel bar chart that is formatted exactly the way I like it. The bar colors, the label fonts, the grid lines, etc, etc.
Here is an example:
Notice the awesome formatting of the second ...
0
votes
0
answers
117
views
Excel Chart - show data formatted regardless the local settings
I want to share a excel file with charts on a different computer.
The data I have formatted to display with thousand (,) and decimal (.) separation char.
Unfortunately the other computer is set up ...
3
votes
2
answers
630
views
Format telephone numbers in Excel
I have a column of numbers in the format
'+43 ??? ?? ??
(the ' is there so Excel doesn't think it's a formula and ? represents an integer)
which I would like to have in the format
'+43 ?? ??? ??
...
0
votes
1
answer
1k
views
Format blank cells based on text in another cell
I would like to apply conditional formatting to a sheet, however, cant figure out the right formula.
The formatting would only apply to BLANK cells in columns S to AT based on text in in column I.
...
0
votes
1
answer
1k
views
How does Increase decimal and Decrease decimal work in Excel
How the increase decimal operation is performed in Excel and how they done it?
Case 1 :
I enter a number in a cell whose number of digit is less than 11.
For instance A1 cell value be : 123
If I ...
0
votes
2
answers
89
views
Excel 2016 time formatting cells
Using Excel 2016, I want to enter 90 minutes as 90:00, or 75 minutes and 33 seconds as 75:33, or 102 minutes and 54 secs as 102:54; then sum the column to report as 268:27. How do I format the data ...
0
votes
1
answer
191
views
Highlight cell based on whether or not a specific word appears in a given range?
I have 2 sheets. Sheet1 & Sheet2.
Sheet 1 has a list of items with descriptions & specific numbers.
Sheet 2 has a table filled with the same items.
What I am wanting to do, is highlight a ...
-1
votes
2
answers
725
views
Excel conditional formating: use fill color based on a different cell's existing fill color
The following table represents the value I’m working with in Microsoft Excel.
+---+----+-----+---------+-----+
| | A | B | C | D |
+---+----+-----+---------+-----+
| 1 | | Min | ...