2
votes
0answers
36 views

copy data from multiple word files to excel with 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 ...
0
votes
1answer
32 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 ...
1
vote
1answer
49 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 ...
0
votes
1answer
44 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. ...
0
votes
1answer
140 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 ...
0
votes
1answer
274 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 ...
4
votes
2answers
4k 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 ...
3
votes
1answer
143 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 ...
2
votes
1answer
236 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 ...
0
votes
1answer
61 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. ...
2
votes
2answers
1k 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 ...
1
vote
3answers
10k 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 ...
2
votes
1answer
5k 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 ...
0
votes
1answer
805 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 ...
4
votes
4answers
23k 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 ...
12
votes
3answers
49k views
2
votes
1answer
119 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 ...
16
votes
5answers
4k 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 ...
0
votes
2answers
2k views

How do I make the first row of an Excel chart be treated as a heading when it's a number?

Given a data sample like Prisoner 24601 0.50 Day 1 80 90 Day 2 81 89 Day 3 82 90 Day 4 81 91 What's the easiest way to tell Excel that 24601 and 0.50 are data series names rather ...
0
votes
1answer
3k 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?
2
votes
3answers
2k views

Worksheet is larger than the window

I have a worksheet saved which is larger than the Excel 2007 "workarea". This means when I open the worksheet I cannot access the corners of the worksheet to reduce the size and the worksheets title ...
0
votes
1answer
2k 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
1answer
99 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.
6
votes
2answers
26k 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.
0
votes
1answer
2k 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 ...
-1
votes
3answers
294 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 ...
1
vote
1answer
108 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 ...
3
votes
2answers
98 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 ...
3
votes
2answers
2k 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 ...
5
votes
3answers
6k 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+ ...
3
votes
3answers
8k 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 ...
1
vote
1answer
113 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 ...
8
votes
3answers
24k 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. - ...
0
votes
1answer
2k 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 ...
1
vote
2answers
2k 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
2answers
140 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 ...
1
vote
2answers
6k 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 ...
1
vote
3answers
8k 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 ...
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 ...
3
votes
5answers
11k 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 ...
0
votes
2answers
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?
0
votes
1answer
179 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 ...
8
votes
10answers
29k views

Multi-row headers and excel 2007 sort/filtering

I have a spreadsheet which uses 2 rows for header information. Filtering implicitly is assuming only 1 row of header information. Sorting has a header row checkbox but that only toggles treating the ...
1
vote
3answers
2k 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 ...
5
votes
2answers
14k 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 ...
4
votes
2answers
975 views

How can I create a reusable function in Excel 2007?

How can I create a resuable function/formula I can use in formulas in a spreadsheet? In particular I need a very simple DateDiff formula and would like a way to encapsulate this function: ...