All Questions
Tagged with microsoft-excel formatting
241
questions
2
votes
4
answers
2k
views
Excel transpose and organize
I have a bunch of rows, that I want to turn into a table.
Is there a way in Excel to convert a bunch of entries, each occupying four rows into a table, where each of the four rows is put in one of ...
2
votes
5
answers
2k
views
Rotate text without rotating border
I'm attempting to rotate the text inside of a cell without altering the cell border.
Roughly the intended result:
Current Output:
The only solution I've found so far involves adding either splitting ...
2
votes
1
answer
5k
views
IMEI number formatting in Excel
I'm trying to format IMEI numbers in Excel according to RIM (Blackberry) conventions: XXXXXX.XX.XXXXXX.X
I enter them in excel without any periods and use the "special format" cell properties so it ...
2
votes
4
answers
726
views
Is it possible to have a conditional formatting cell "visually cycle" through all the formats that evaluated true?
Like the title says, "In Excel, when a cell has multiple conditional formatting rules that evaluate true, is it possible to have the cell "visually cycle" through all the formats that evaluated true? ...
2
votes
1
answer
2k
views
Formatting a tab-delimited CSV/TSV to force Excel to interpret value as a string
I had a followup question to this related post -
Formatting a CSV to force Excel to interpret value as a string (not date or number)
I was wondering how does one escape text starting with " using "...
2
votes
1
answer
4k
views
Why are some blank cells seen as zero in Excel?
We have Excel documents that date back years. Some of the document sheets haven't been touched for over 15+ years (or to the very early versions of Excel). They've had a new sheet added each year - ...
2
votes
5
answers
41k
views
Protecting the formatting in Excel 2007
I'm creating a number of forms in Excel 2007 for other people to use. They will be accessing the digital versions, and I'm afraid that they'll eventually accidentally break the formatting I've ...
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=...
2
votes
2
answers
11k
views
How do I filter on bold, struck through or italic text in Excel 2007?
Is it possible to filter an Excel column based on the format of the text, such as whether it's bold, italic or struck through?
2
votes
2
answers
26k
views
Excel: if duplicate cell value found in another column then highlight green
Can someone help me, I'm not sure what formula to use.
I have highlighted the cell in the picture to show an example of what I mean.
What I want to do is highlight the cell in column A where the ...
2
votes
5
answers
8k
views
Excel sheet - automatic formatting
I want to configure automatic formatting for my Excel datasheet.
Here's have an example (not mine):
How can I automatically format the rows depending on one of its cell's values which is not a ...
2
votes
3
answers
3k
views
How to Format Excel Bar Chart Date Axis Tied to Pivot
In the barchart below I want to format the X-axis to be "7/21". You can see that I've formatted in my pivot chart but that didn't help. Then in the Format Axis panel at the bottom under the ...
2
votes
1
answer
9k
views
How to set the numeric format in Excel so that every three digits have a space for some arbitrary long numbers?
For example, if the format is like this: ### ##0,
the number 1283300 will be formatted like this: 1283 300 but I want to display it like this: 1 283 300
or number 75125690347812567 I want to ...
2
votes
1
answer
2k
views
Macro for helping superscript last character of many rows in a single column
I'm adding footnotes (always adding footnotes) to a table and I would really like to be able to automate the repetitive nature of making my symbols superscript.
Currently it’s: >enter cell>highlight ...
2
votes
0
answers
221
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 ...