All Questions
Tagged with formatting microsoft-excel
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....