2
votes
1answer
56 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?
0
votes
0answers
57 views

Can't Find/Find&Replace “Purple, Accent 4, Lighter 40%”, all other colors work - Excel 2007

I have a several large Excel tables that I am managing for my current project. Whenever a metric or value in the table changes, I indicate the change by changing the background color of the cell for ...
0
votes
0answers
30 views

Excel dates with standard format (*) become custom when opened in another country

Here in the USA, I have created an Excel 2007 spreadsheet with a table that contains several columns with dates. I have formatted the date columns using the standard short date format (with the ...
1
vote
0answers
52 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 ...
-1
votes
1answer
34 views

Conditional Formatting from Helloh, for a Noob

I'm going to try my best to explain what I need to figure out. Also, for you to understand exactly how mind bending this is for me, I haven't used an Excel formula since 2005/2006ish. We're doing a ...
1
vote
1answer
67 views

How to change cell format from [ss] to number without changing values

I am doing my Msc Ecology thesis and in the process of organizing my data set. When inputting my data for the amount of time a skink spent in a hole I inputted h:mm:ss for the time it went in and the ...
0
votes
2answers
49 views

Formatting columns in microsoft excel?

I have a list (.txt document) of telephonenumbers with first and surname and number. Like this : 123123 john doe 123132 michael jordan etc. I want to put the list in microsoft excel that after a ...
1
vote
1answer
67 views

Excel does not accept custom cell format for cents

I have a spreadsheet containing cent amounts, and I am trying to format the amounts such that the last two zeroes are separated from the rest of the figure by a space, and from then on thousands are ...
0
votes
1answer
110 views

How to find the programming done for cells / worksheets in Excel, to be able to set precision?

I have a drawing in SolidEdge software, where the dimensions of the drawing are exported to Microsoft Excel. It has a column where various dimensions of the drawing are given in various forms in every ...
-1
votes
1answer
328 views

How to set number format to show all decimal digits

I have one excel sheet. In that one cell value $1,544.13 when i click that cell it is showing 1544.12857142857 in formula bar. I tried to set as General, but it does not show all the digits. It ...
0
votes
2answers
115 views

Excel 2007 suddenly does not paste with formatting anymore

A friend's Excel 2007 used to, when you'd copy cells and paste them within a document, paste the formatting along with it. Suddenly today it no longer does that. I found this question: How can I ...
0
votes
1answer
730 views

How can I copy cells in Excel 2007 and paste with formatting

I am wanting to be able to copy cells in a worksheet and paste them elsewhere in the same worksheet while maintaining the original formatting. I also want to be able to paste into Word and Outlook ...
0
votes
2answers
149 views

How can I check cells for number series?

I have a bit of a problem evaluating an excel cell. Example: M M M M M M M M M 1 2 3 4 5 6 7 8 9 2;5;7 1;9 3;5;7;9 I have a number of excel ...
2
votes
2answers
6k views

How to rotate text in axis category labels of Pivot Chart in Excel 2007?

I'm using a pivot chart in Excel to display data. My problem is: I can not influence the orientation of the text in the "axis" (don't know how to call it correctly, I'm sorry). As an example: In the ...
2
votes
1answer
821 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 ...
0
votes
1answer
722 views

Pasting HTML table into Excel 2007 without modifying the format of each cell

I have a table in HTML having cells storing numbers like 123.0,123.00. When I use ctrl-A to copy the whole page into excel, 123.0 and 123.00 are all changed to 123, which is not something I want to ...
7
votes
2answers
2k views

Excel elapsed time format

In Excel, given a number representing some amount of time (e.g. 25.5 hours), is there a way to format it so that it shows as 1d 1h 30m? Bounty question : Is there a way to add months to this format? ...
7
votes
3answers
15k views

How to stop Excel from Auto-formatting and making it work like a number crunching program

I have a real problem with Excel in csv files where it is formatting numbers in certain ways and I cannot seem to get Excel to display the data right no matter what I do. Imagine I have a colum ...
4
votes
1answer
16k views

Color Cell Based On Text Value

An Excel column contains a text value representing the category of that row. Is there a way to format all the cells having a distinct value a unique color without manually creating a conditional ...
1
vote
1answer
69 views

Excel Formatting Issue Without Being Administrator

Having a real weird issue. A few excel files sent to my office open fine as Administrator. However, as a standard account it opens with all of the cells shrunk and the formatting completely messed up. ...
1
vote
3answers
8k views

Add more than 20 digits in Excel without an exponential sign

I want to add more than 20 digits in an Excel cell. The current format of the cell is general, and it converts the number to an exponential format. I tried with a number format and accounting, but ...
1
vote
1answer
394 views

Format Million on Excel 2007

I would like to change the format predefined with Excel 2007 for million in the previous versoin I could do that but havent found a way to do this. For example I have this: 1,235,000,00 and I ...
1
vote
5answers
4k views

Excel 2007: “Format as Table” Increments Column Names

I love using the formatting styles for tables in Excel 2007, but in my data I'm using the same column name for multiple columns. When I format my table using the pre-defined styles, it automatically ...
1
vote
1answer
477 views

Change cell formatting without VBA. Custom formatting?

I have a dropdown field with two values in a form I am creating. The expected data in cell D15 changes depending on the selection. If Option A is selected then a dollar amount is expected. If option B ...
0
votes
1answer
1k views

Is is possible to apply separate formatting to multiple different Excel table columns?

I have some calculated columns in an Excel (2007) table. I'd like to distinguish them visually from the user-input columns in some way, but without losing the nifty automatic row banding. It looks ...
0
votes
1answer
685 views

Excel Macro: compare separate workbook lists and LINK to the data in a corresponding column?

1. How can I compare two matching lists from separate workbooks? And then retrieve the data from the same row but another column - (Index&Match maybe be appropriate for this). But how does this look ...
0
votes
3answers
2k views

Excel VBA/Macro: how can I delete rows and remove dots & dashes?

I've recently been handed an Excel file to format - 100's of lines. The image below shows you the state of it. This could be a really long exercise if I work through it manually, so I wondered if a ...
1
vote
0answers
525 views

Pivot Tables: how can I stop my columns from disappearing if they are empty?

I've ticked 'preserve cell formatting on update', but if one of the columns doesn't have an entry then it disappears. Is there any way I can keep it from disappearing even if it's blank? I suspect not ...
1
vote
1answer
420 views

Excel Graph: How can I turn data below in to a 'time based' graph

In my spreadsheet I am collecting time periods when certain values have been changed. The user is restricted to 4 time periods. I would like to show the data based on thos time periods. I've included ...
1
vote
1answer
801 views

Excel 2007 Pivot Tables: Refreshing upsets my manual formatting

How can I stop a refresh on Pivot Tables from ruining my manually configured columns widths? I'd like to be able to make the columns fixed. The columns will always be the same ones, but the data ...
12
votes
7answers
28k views

Table Formatting in Excel 2007: How do I remove it?

I've used the new Table Formatting option in Excel 2007. Now I can't remove it. I've dragged the little blue square up to the last cell on the top left, but it just won't go any further. In fact it ...
1
vote
3answers
126 views

Excel 2007 shortcut?

Is there a shortcut in Excel 2007 (or a simple way to define one) to paste all copied values, but without formatting ? I'm entering some data in tables, and it would really save my life, that one.
2
votes
2answers
2k views

How best to manage my growing data in Excel?

This isn't a question about formulas or features in Excel. I'm debating the correct/best way to manage the growing amount of data 'I have to' manage in Excel (I produce PIVOT tables/reports for my ...
1
vote
3answers
19k 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 ...
0
votes
3answers
17k views

Excel 2007 formulas not autofilling when I drag down

If you write a formula like: =sumproduct((something=$A1)*(somethin=$B1)) Giving a result of 8. Usually the references and results change as you drag it down into other cells. Well,the references ...
2
votes
2answers
2k views

Open blank Excel spreadsheet with all cells in text format by default

When I paste data with leading zeroes to a newly-opened blank Excel document, it strips out all leading zeroes. Is there a way for me to open up a new instance of Excel (not from a template, I ...
2
votes
5answers
1k 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 ...
0
votes
3answers
1k views

custom format for cells with nothing in them without using conditional formatting

if a cell is blank I would like to add text using a custom format. I've seen where text is added if a value is above or below a certain value. Can you add text to the cell if the cell is blank? I've ...