All Questions
Tagged with microsoft-excel formatting
75
questions with no upvoted or accepted answers
1
vote
0
answers
276
views
Make Excel 2007 pivot tables default to Classic View
When I launch a new pivot table in Excel 2007 (.xlsx file format) the defaults appear to be:
New view (not Classic view)
Autofit column widths on update = on
Subtotals = on (top of group)
I end up ...
- 623
1
vote
1
answer
441
views
Formulas and icons in Excel
In Microsoft Excel 2007 and am attempting to track vehicle mileage
I’m looking for Excel to calculate mileage until service, from two cells, and output 3 different icons or colors to been easily ...
- 11
1
vote
0
answers
426
views
Maintaining subscript format when copying a cell
How do I copy/lookup/drop down list a cell with subscript format?
EXAMPLE:
Phosphate (P2O5) should have the 2 & 5 in subscript but always returns without it.
- 11
1
vote
2
answers
644
views
Formatting of output .csv file generated by a software
I've been using a software which gives the output in .csv format automatically. In my .csv output file "." is used as a decimal separator. In my colleague's computer, the same software outputs the ....
- 1,715
0
votes
0
answers
41
views
Pdf table pasted into excel via word but there is hidden text i dont want. I cannot find how to remove
My excel data appears to be cells like 200.00 BUT I cannot add up because the actual cell content is Money in (£) 200.00. So it has text at start and . at end that I don't see in the display. I just ...
0
votes
1
answer
108
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
33
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
67
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
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
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
217
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
3k
views
Conditional Formatting for cells that are 50%<
I am trying to get conditional formation to highlight cells in column G that are 50% greater than the corresponding cell in column D. I have tied to use a formula to determine which cells to format ...
- 1
0
votes
1
answer
651
views
Removed thousand seperator in Excel currency format
we have a big file including a lot of prices in EUR. These columns are format on currency. By doing this Excel automatically creates a , as thousand seperator. This , creates an issue in our file ...
- 1
0
votes
0
answers
42
views
Office365 Excel and different formatting inside cell
LibreOffice can do different formatting inside cell. But when I try to do the same with Excel on Office365 it does not work.
e.g. I have text:
When I select part to format it, bold/italic/underline/...
- 592