All Questions
Tagged with microsoft-excel-2007 microsoft-office
52 questions
0
votes
1
answer
343
views
How do I sort pivot chart groups by their actual value, not their stringified group name?
When I group by a date field, it formats the grouped field as a string and then sorts the recordset as a string rather than its actual value (see screenshots). When grouping by day, it turns 8/10/2021 ...
- 3
4
votes
2
answers
49k
views
How to have a color-specified scatter plot in excel?
I have a table of information in excel in which I have a column for some attribute and two columns of for example X and Y information. I want to plot them in scatter form but with specified color for ...
- 141
1
vote
2
answers
2k
views
How to auto populate an excel column based on multiple rows and columns?
I have the following columns in my excel spreadsheet:
Participant ID; Date of Event; 3 or more events in one month
I want to auto populate the 3rd column 3 or more events in one month - by ...
- 11
0
votes
1
answer
175
views
Shared Excel doc with one user who's changes aren't saving for others to see
So my office uses tick sheets to catalogue tasks performed throughout the day in order to input them into the time-card/work-volume prediction system at the end of the day. A few years ago, when this ...
1
vote
1
answer
5k
views
Is there an English Office Language Interface Pack?
Located in France, I have only access to a French version of Excel and would like to change it to English for programming purposes. I want to use this model, based partly on Excel VBA code. Currently ...
- 177
0
votes
0
answers
3k
views
Install older version of MS Office without removing newer version first
I'm currently running Microsoft Office 2010, but I temporarily need Excel 2007. I know I can use the Custom setup at the 2007 install process to select just Excel, and based on the Setup Help page:
...
- 111
0
votes
1
answer
2k
views
Changing current mail merge to use new source data
I have a mail merge file that I created last year, I would like to use a new source data file to create new post cards.
Can this be done and how do I go about doing it? I really don't want to create ...
- 1
2
votes
1
answer
14k
views
Pivot table with two headers in MS Excel
I'd soo appreciate if someone could help.
My initial table looks like this:
Brand Period_1 Period_1 Period_2 Period_2
------------------------------------------------------
...
- 123
4
votes
1
answer
13k
views
Copy data from multiple MS Word files to Excel using VBA
I know this question was already asked (Copying data from multiple word docs into one excel sheet) the thing is I can't use the answer.
I'm fresh to VBA, but I thought I can handle it. I was wrong. I ...
- 43
0
votes
1
answer
2k
views
When try to open word/excel 2007, I am always getting Microsoft office enterprise 2007 configuration progress pop up. How to get rid of this
I have office 2007 and 2013 in my system. I uninstalled 2013. Now When I try to open word or excel 2007 files, I am always getting installer popup. How to get rid of this pop up once for all ...
- 105
1
vote
2
answers
3k
views
Excel 2007 or 2010 copy/paste without merging cells & with shift all down
Let say I have an excel sheet with structure like
I select a few cells (at one column) and click Ctrl+C. After that I want to paste it. I select one cell(B116):
And click Ctrl+V. It gives me an ...
- 111
0
votes
1
answer
205
views
excel - if value grater than, use that value
I am having problems with my excel function. I want to:
if value 1 is greater than value 2, then write value 1 in a cell. If value 2 is greater than value 1, then write value 2 in the cell.
...
- 101
0
votes
2
answers
4k
views
Disable custom view in Excel
I am using a shared excel workbook that everytime a user accesses it and saves it, it
saves a Custom View for them. I want to disable this settings so that every one can see only same view of the ...
- 823
0
votes
1
answer
16k
views
How do you click and drag lower right corner of a cell (autofill) in excel using the keyboard? [duplicate]
If I press CRTL+Down I move to the cell before the empty cell.
If I press CTRL+SHIFT+End I end up selecting everything between the active cell and the next empty cell.
Now if I want to auto fill ...
- 23.1k
4
votes
2
answers
15k
views
Multiple Y-axis labels in Excel 2010 line chart
I have a table containing cycling data. Date, distance, time, calories burned, max heart rate and average heart rate. They all have different value ranges. Excel scales the chart to show the calories ...
- 601
3
votes
1
answer
311
views
Permanently increase 'Recent Documents'
I've tried to look around for a similar question but it didn't seem as though there was one, so here's my case:
I've tried to increase the number of recent documents in MS Word/Excel for a while now ...
- 4,946
2
votes
1
answer
568
views
How to config Microsoft Office Application (Word / Excel) to stop adding personal information to the document?
I have created word document (*.doc or .docx) or excel documents (.xls or *.xlsx).
Sometime, these documents need to be sent to some customer and therefore require personal information to be removed ...
- 547
0
votes
1
answer
80
views
MS Office Word - EXCEL
I've got a problem:
I want to create one document, consisting of different documents.
Using an excel sheet (comparable to mail merge therefore)
! But: Every recipient has a different content. (Every ...
- 17
3
votes
2
answers
3k
views
In Excel 2007 where do you store macros that you want to use on all sheets that you open?
It looks like you can store it in a file called PERSONAL.XLSB and that will create "Global" (for all worksheets) macros.
This file is of course stored in your user profile (%USERPROFILE%\AppData\...
- 23.1k
19
votes
7
answers
127k
views
Microsoft-excel newlines and tab
Current I use "CONCATENATE" to join string in Excel, but I want insert character newlines and tab in string joined by "CONCATENATE".
Example:
I've string below when I completed join string.
"Today ...
- 191
2
votes
2
answers
18k
views
Create reusable custom shapes in Microsoft Excel or even Office in general
In Microsoft Excel 2007/2010, or even Microsoft Office in general,
Say I use the use Insert > Shapes to create a drawing in Excel, is it possible to save this drawing in as a new Shape itself in the ...
- 2,139
0
votes
1
answer
2k
views
excel cannot open the file xxx.xlsx' because the file format is not valid error
I have difficulty open opening word and excel files suddenly. Only particular office file give me the problem. These files were previously scanned by combo fix and I believe they were damaged. The ...
- 1
6
votes
7
answers
165k
views
Excel Spreadsheet for Barcode Scanning
I've been asked by our warehouse guy to help him with an excel spreadsheet to increase his productivity. The problem is, I'm not what you would call an "excel expert". What he wants sounds very simple,...
- 63
75
votes
3
answers
311k
views
What is the maximum allowed rows in a Microsoft Excel .xls or .xlsx
Is there a limit? I couldn't find one posted.
- 892
2
votes
1
answer
217
views
Remove duplicate results when filtering data in Excel
I'm working with Excel 2007. I have 700+ lines of information on an Excel sheet and I am using filter to filter out when the certain employees started working for a certain branch and/or team using ...
Tyler D.
39
votes
9
answers
64k
views
How can I use custom colours in the Microsoft VBA editor?
I'm working on a few projects for work using Excel and VBA, so I have no choice but to use the Microsoft Visual Basic editor. I normally wouldn't mind, but I can't figure out how to set a custom ...
- 34.7k
0
votes
1
answer
9k
views
Excel cannot open the file "filename.xlsm" because the file format or file extension is not valid?
In Excel 2007, I get this error when I try to run a script a friend posted to the web. I have heard of no one else having trouble.
Any ideas what might be going on here?
- 887
2
votes
4
answers
7k
views
Worksheet is larger than the window
I have a worksheet saved which is larger than the Excel 2007's work area.
This means when I open the worksheet I cannot access the corners of the worksheet to reduce the size and the worksheets title ...
- 21
0
votes
1
answer
3k
views
Is there any way to restore an Excel file to a previous version?
Is it possible to roll back changes I made by mistake in Excel 2007? The Windows 7 system protection option was disabled.
1
vote
1
answer
148
views
Stop Microsoft Excel 2007 from formatting anything?
How can I stop Excel 2007 from modifying any character, I don't want to modify the date in any way, I don't want to modify misspells, nothing.
I just want to see the exact text I'm writing.
- 415
10
votes
2
answers
209k
views
Excel: Find a subset of numbers that add to a given total?
I have a column of numbers (lets say it's A1:A100) and I need to find a subset of them that sum to a certain total.
- 1,625
0
votes
1
answer
3k
views
How do I avoid saving Excel files in the temp directory in Windows XP?
How do I make sure that I don't save files (Excel in this case) in C:\Documents and Settings\u.sername\Local Settings\Temp? (Apart from having my brain in gear!)
It's kind of disconcerting to save a ...
- 2,790
-1
votes
3
answers
342
views
Macros Excel 2007 - extracting data
Im trying to extract certain data from a cell and trying to put it somewhere else within the same cell. Any suggestions?
EDIT
I have several text strings in ONE cell (a date, a part number and a ...
- 9
1
vote
1
answer
415
views
Extending a range of fractions
I'm trying to fill a range with fractions i.e. 1/3, 1/5, 1/7, 1/9 etc.
When i try to drag the fill handle down it gives me all kinds of odd results. e.g.-1/8, -1/5, -2/7 etc.
Any ideas on how to get ...
- 33
3
votes
2
answers
151
views
Reverse-tracing a list of numbered items
Is there a programmatic, hopefully non-macro way to reverse-trace a set of numbered items?
Example:
The first two columns are ones which data is entered in. You can see that item A has a ...
- 748
3
votes
2
answers
6k
views
Microsoft Excel - Copy Pasting while maintaining reference to a single cell
Let's say that I have a value in cell A5 that is being used to calculate a value in A3.
Example:
A3 = (A1 + A2) * A5
When I copy paste cells A1:A3 and paste onto B1:B3, I'd like the resulting ...
- 1,762
13
votes
2
answers
37k
views
Excel: Edit the XML inside an XLSX file
An Excel XLSX file is a zip archive containing several XML files. I tried to extract all the XML files, and edit xl\connections.xml using an XML editor. That's because I have to change 20+ ...
- 1,501
3
votes
3
answers
27k
views
How to disable moving down on Enter key in Excel 2007?
There used to be a check-box in preferences in Excel 2003 to disable moving down on Enter key after you edited a cell. Where could I find that setting in Excel 2007?
<whining on>It drives me ...
- 423
1
vote
1
answer
190
views
How do you create a report in Word (or other documentation software) that is linked directly with Excel 2007 data?
I believe my question may be best answered by using Access since that's more what it's made for. However, I don't have a license for Access here at work and trying to get one is pulling teeth.
So I'm ...
- 3,169
32
votes
5
answers
124k
views
What the heck have I done to my Excel sheet (and how to undo it)?
I have a lot of Excel sheets for all sorts of things - but none has ever acted up like this one here:
This used to be a totally normal Excel 2007 sheet which I was able to resize, maximize etc. - but ...
- 1,397
0
votes
1
answer
18k
views
Un-table a cell range in Excel 2007
In Excel 2007, if you highlight a block of cells and then "Format as Table", it doesn't just apply colors and formatting, it somehow marks those cells as being a table.
Now I want to get rid of the ...
- 311
1
vote
2
answers
3k
views
Is there anyway to make particular-selected cells in MS Excel as read-only?
By LOCKING the cells, and switching protection on will make whole file read-only .. But I want to make only few/selected cells as read-only .. that means, those cells cannot be edited anymore ..
Is ...
2
votes
2
answers
1k
views
Use Microsoft excel sheet feature in Microsoft Word
In Microsoft Excel they have a sheets feature where I can make many sheets in one document.
That helps me a lot by keeping various related data in separate sheets but in one file.
I want a similar ...
- 3,283
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
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,240
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 ...
- 626
10
votes
7
answers
45k
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 ...
- 626
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
902
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
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.8k