Questions tagged [microsoft-excel-2007]
Microsoft Office Excel is a spreadsheet application written and distributed by Microsoft. Use this tag for problems specific to Excel 2007 for Windows.
2,269
questions
1
vote
1
answer
15k
views
Combining multiple Excel 2007 tables into one PivotTable
I have two tables, in separate Excel worksheets in the same file, which I'd like to combine. Is this possible?
The tables look like so:
Project | Subproject | Hours
PAlpha | SPOne | 5
PAlpha ...
- 2,257
1
vote
1
answer
13k
views
How can I remove a password on an Excel 2007 VBA project?
Is there any way to remove the password on an Excel 2007 VBA project? (Either within Excel itself of with some other application.)
MJ
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 ...
- 875
1
vote
2
answers
1k
views
Pivot table - calculations across totals
I have a Pivot table in Excel, where I have two fields in the totals area (say, I calculate the Countof both A and B).
Is it possible to do calculations on these totals instead of just displaying ...
- 144
2
votes
3
answers
134k
views
Excel 2007 formulas not auto-filling when I drag down?
If you write a formula like:
=sumproduct((something=$A1)*(something=$B1))
Giving a result of 8. Usually the references and results change as you drag it down into other cells. Well,the references ...
- 1,528
3
votes
1
answer
1k
views
Opening Excel 2007 to a specific worksheet from a file:// link
Our internal website links to Excel files on a network-mapped drive. The links specify the filename and worksheet to open, in the following format (path and link information omitted):
ExcelFileName#'...
- 223
3
votes
3
answers
14k
views
Make Excel 2007 open hyperlinks in Firefox
In Excel 2007, when I click a hyperlink, it opens in IE.
I'm running XP Professional SP3.
Firefox is set as my default browser. Links in Word and Outlook open in Firefox. But Excel opens them in IE. ...
- 1,197
1
vote
2
answers
11k
views
Excel 2007 Save as PDF with pagesize/pagewidth auto or not breaking Excel lines
I tried to export an Excel file into PDF, but it looks horrible. I need at least that one row form Excel to be saved into a one row in PDF.
I know that it is not so simple, because Excel does no have ...
- 310
5
votes
4
answers
7k
views
Colour coding blocks of rows using conditional formatting
My macros have been taken away; never to be used again! I'm gutted. I now need to use formatting to help me highlight the different users and their data. Doing this manually is a chore.
Using Excel ...
- 1,528
0
votes
2
answers
1k
views
How to make an Excel formula which totals several adjacent rows based on cell values
I have an Excel sheet with three columns: date, person and percentage. I would like to put in a data validation that flags cells if the total for a given data/person combination do not equal 100%. Is ...
- 125
89
votes
13
answers
364k
views
Selecting whole column except first X (header) cells in Excel
I know I can select all cells in a particular column by clicking on column header descriptor (ie. A or AB). But is it possible to then exclude a few cells out of it, like my data table headings?
...
- 2,036
2
votes
3
answers
14k
views
Excel 2007 does not close properly
I've noticed some odd behavior with Excel 2007 and I'm curious if others have seen this. When clicking the application close (big red X), Excel actually closed down the open workbook, yet leaves the ...
- 1,220
14
votes
3
answers
49k
views
Keyboard shortcut to switch between sheets in Excel
Does Excel 2007 have a keyboard shortcut that switchs between worksheets?
- 1,125
0
votes
1
answer
3k
views
Ctrl + F9 Does not update Formula Text on Excel 2009
I have a lot of excel workbook that follows a template. Since each workbook has a lot of sheets. I usually just use the equal formula to refer to the heading of the first sheet for the succeeding ...
- 547
1
vote
2
answers
1k
views
Excel 2007: what happened to the Auto Expand Selection tool?
Older versions of Excel had a icon that would expand the selection to include any non-empty cells in all directions. It was an X shape with four arrowheads. You can still write VBA code to do this, ...
- 113
4
votes
1
answer
870
views
Excel 2007 Constantly Creating Custom Cell Styles
I've been using Office 2007 for a few months now and have noticed that it was creating duplicate custom cell styles on its own, like Normal 2, Normal 3, etc. It didn't really bother me at first, but ...
Nick
1
vote
2
answers
55
views
Rows in seperate sheets in workbook seem to be linked?
I have a problem where a colleague is editting a spreadsheet I provided in 2003 workbook format. When he is editing in Excel 2007, he is inserting a row on one sheet in the workbook. This is fine but ...
oidsman
2
votes
1
answer
31k
views
Excel Dashboard Templates [closed]
Are there any nice sites for neat and free Excel dashboard templates? The following one is a great example:
3
votes
1
answer
6k
views
tab-shape or round corner background in Excel
In the below screenshot, you can see that each blue group header has a tab-shape or round corner background. Does anyone know to to create it?
Source
northTiger
2
votes
5
answers
5k
views
In a spreadsheet (Excel, Google Docs, OpenOffice), how do I transpose data from rows to columns, but only non-null cells?
I work with all three spreadsheet programs listed above, and I believe my question can be answered the same or similarly for all three.
On my sheet, I have a top row full of column headers. The ...
- 3,147
3
votes
2
answers
5k
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 ...
- 616
10
votes
7
answers
44k
views
How can I make Excel documents open in different windows?
Office 2007, Windows Server 2008 x64.
How can I make Excel so that when I double-click a document, it opens in a new Excel instance, so that I can easily view them side-by-side as separate windows ...
- 616
2
votes
5
answers
6k
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 ...
- 131
1
vote
2
answers
11k
views
Cannot get out of compatibility mode in Excel 2007
I cannot get out of compatibility mode in Excel 2007. I've tried resaving the document but that doesn't help. Thoughts?
Rachel
147
votes
8
answers
694k
views
Find Items in one column that are not in another column
I have two columns in Excel, and I want to find (preferably highlight) the items that are in column B but not in column A.
What's the quickest way to do this?
- 6,344
5
votes
1
answer
19k
views
How do I change the default program to open Excel files with from Excel 2010 to Excel 2007?
I have the Office 2010 beta installed, but I have some programs that aren't compatible, so I have Office 2007 installed as well, and Office 2003 is also installed for testing purposes.
Right now, ...
- 983
4
votes
3
answers
12k
views
How to find and replace link paths in multiple Excel files at once
We have a huge folder containing office documents on our server. IT wants to change the name of the folder from Mehper_repository to Planning_reports. Since most of the Excel files in the subfolders ...
- 55.5k
4
votes
13
answers
28k
views
Mouse wheel does not work in Excel 2007
I am running Office 2007 on Windows XP-SP3. My mouse wheel works fine in other applications, meaning that it scrolls information up and down when the mouse is positioned over a given panel. It's even ...
- 397
73
votes
12
answers
137k
views
How to "unpivot" or "reverse pivot" in Excel?
I have data that looks like this:
Id | Loc1 | Loc2 | Loc3 | Loc4
---+------+------+------+-----
1 | NY | CA | TX | IL
2 | WA | OR | NH | RI
And I want to convert it to this:
Id | ...
- 4,031
0
votes
1
answer
2k
views
User Sql Server Compact 3.5 as a data source in Excel 2007/2010?
I'd like to provide users the ability to connect to a Sql Server Compact SDL from Excel to do some analyses. I'm having a hard time figuring out how to do this and would like a little help.
Are ...
user939
0
votes
1
answer
6k
views
How do I freeze a chart in Excel 2007?
I have 2 columns of data and a chart on the right side.
I'd like to freeze the location of the chart so that I can scroll up and down to view the data while viewing the chart at the same time.
How ...
- 1,438
0
votes
2
answers
1k
views
Excel 2007 'Corruption'- Named Ranges vanising, buttons losing Macros
I'm seeing a lot of weird things happening in some excel sheets I use.
Some named ranges vanish
Worksheet buttons 'forget' what Macro they should run
Named ranges 'forget' what cells they pointed too
...
- 1,495
0
votes
3
answers
6k
views
Shared workbook copy/move delete p_roblem?
Hi I've a shared workbook. But it doesn't allow me copy/move or delete sheet(s). How can I solve this problem? Or How can I undo sharing? (I don't remember how I Shared :) )
- 205
0
votes
3
answers
1k
views
automatic hyperlink to worksheets in excel 2007
I have a worksheet called 'summary' this contains a list of english counties, and I then have a seperate worksheet for each county.
What I want to do is automatically make my list of counties on the ...
- 2,099
0
votes
2
answers
1k
views
How to "Track Changes" in Excel?
"Track Changes" is a very useful feature in Word, but I can't find a similar button in Excel. Does anyone know where it is?
- 203
0
votes
1
answer
899
views
How to plot Excel graph of multiple series of data using smooth lines
Long time reader, first time questioner. I'm wondering how I'd use the following Excel cell data:
http://screencast.com/t/ZjNkODQ3O
Into a graph which looks like: http://screencast.com/t/MTVhYTY1YTMt ...
user18133
3
votes
3
answers
60k
views
Excel opens file as read only; won't save after unflagging the file on disk
I open a file that's read only. I change some stuff. When saving, Excel whines that it's read only. I uncheck the read-only attribute. However, the readable attribute does not propogate upwards to ...
- 1,816
4
votes
1
answer
7k
views
Is there any way to suppress the Excel 2007 warning "in a different format than specified by the file extension"?
We have an application that exports data using the older Office XP/2003 XML Spreadsheet format. These files are saved with a .xls extension so that they can be launched directly, without having to ...
- 143
0
votes
1
answer
721
views
How do I prevent Excel 2007 from opening hidden workbooks, so the X button exits Excel completely?
I've been frustrated recently because Excel 2007 no longer exits when I click the upper-right X button. Instead, it simply closes the current workbook. I've found a partial answer here: the behavior ...
user16613
3
votes
3
answers
56k
views
How to set Function "formula" for whole column in Excel 2007?
I want to set "Formula" to all cells in certain column whatever the number of rows was.
But i don't want to set this function to first cell "Header" of this column.
How do i make it ?.
- 1,905
1
vote
2
answers
7k
views
Date selector popup in Excel
I'd like to setup an entire column, so that it will only contain dates, and I won't have to manully enter the date string. Instead, I'd like a click on the cell to pop up a calender selector.
How can ...
- 11.5k
10
votes
3
answers
52k
views
Fixing the first row as sortable title in Excel 2007
I know this is super easy, I just couldn't find it.
I'd like the first row in an excel document to be the "title" field. I want that:
Whenever I scroll down, this row will remain fixed
I can sort ...
- 11.5k
29
votes
4
answers
84k
views
Setting up a column of "enum"-fields in Excel
I'd like to setup a column in excel with several fixed possible values (like 'in-progress', 'done', 'canceled').
I'd like to set it up so the only possible values in these column are from the fixed ...
- 11.5k
4
votes
4
answers
23k
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 ...
- 983
2
votes
1
answer
10k
views
Excel: filling a table based on trendline equation without creating a chart/trendline
Is it possible to generate a trendline equation without drawing a graph?
I have a column that is missing about 30 data points, I'd like to fill the blanks based on a trendline of the existing data
- 1,022
9
votes
5
answers
145k
views
Can I split a spreadsheet into multiple files based on a column in Excel 2007?
Is there a way in Excel to split a large file into a series of smaller ones, based on the contents of a single column?
eg: I have a file of sales data for all sales reps. I need to send them a file ...
- 233
1
vote
5
answers
11k
views
Excel 2007 and Word 2007 are very slow when closing or opening a file
I have a new PC with a fresh install of Office 2007. This computer freezes randomly when I open or close an Excel or Word file. It seems to freeze more often when the file is from a network share.
...
- 1,930
6
votes
4
answers
72k
views
How can I add a calculated field to a pivot table that shows the difference between two series of data?
My underlying pivot table has the following columns - ProjectName, Type, Year, Budget. The data shows information for 2009 and 2010 for the same ProjectName and Type. I can pivot this to get a table ...
- 805
8
votes
4
answers
96k
views
In excel, cannot figure out why background color for a cell will not change?
Ok, so I inherited an excel workbook full of excel forms to modify. I am not the original author of the form. I cannot for the life of me figure out why it wont let me change the background color of ...
- 10.2k
8
votes
4
answers
48k
views
Using Paste Special > Values with the HYPERLINK function in Excel
I have a long list of data in Excel 2007. Using the Hyperlink function:
=HYPERLINK(C2,A2)
I've added individual links to them all. Now I want to get rid of the function and just leave the data with ...
Pete