Stack Overflow
Stack Overflow

Questions tagged [excel-2007]

The Excel-2007 tag is used for referencing the Excel Version 2007 spreadsheet application from Microsoft. The version independent Tag is "excel". If your question is about VBA then also tag it VBA. If it is about an Excel formula or worksheet function, then tag it worksheet-function.

Excel 2007 is the 12th version of Microsoft's commercial spreadsheet program. It is the first version of Excel to incorporate a new user interface (UI), which is now standard across most/all Office suite programs.

This tag is used for questions specific to the 2007 version of the program. However, it is usually used in tandem with other tags, to let SO users know what your question is about. If your question is about VBA then also tag it . If it is about an Excel formula, tag it or . Questions about addins for Excel 2007 should be tagged .

Links:

3668 questions
347
votes
23 answers

How do I convert a column of text URLs into active hyperlinks in Excel?

I have a column in excel, wherein I have all the website url values. My question is I want to turn the url values to active links. There are about 200 entries in that column with different urls in all cells. Is there a way I can create active…
developer
  • 5,178
  • 11
  • 47
  • 72
222
votes
9 answers

Why am I getting "Unable to find manifest signing certificate in the certificate store" in my Excel Addin?

I've got an Excel add-in project that was created a couple years back in Visual Studio 2008. It's got some changes to be made so I've upgraded to Visual Studio 2010 (the only IDE I am able to use). Not sure if this is causing the problem but it's…
Andy Parsons
  • 2,229
  • 2
  • 14
  • 4
168
votes
25 answers

Excel "External table is not in the expected format."

I'm trying to read an Excel (xlsx) file using the code shown below. I get an "External table is not in the expected format." error unless I have the file already open in Excel. In other words, I have to open the file in Excel first before I can read…
Sisiutl
  • 4,915
  • 8
  • 41
  • 54
153
votes
25 answers

Importing CSV with line breaks in Excel 2007

I'm working on a feature to export search results to a CSV file to be opened in Excel. One of the fields is a free-text field, which may contain line breaks, commas, quotations, etc. In order to counteract this, I have wrapped the field in double…
jeremyalan
  • 4,658
  • 2
  • 29
  • 38
114
votes
8 answers

How to add a custom Ribbon tab using VBA?

I am looking for a way to add a custom tab in the Excel ribbon which would carry a few buttons. I chanced on some resources addressing it via Google but all look dodgy and outrageously complicated. What is a quick and simple way to do that ? I'd…
BuZz
  • 16,318
  • 31
  • 86
  • 141
112
votes
5 answers

When should the xlsm or xlsb formats be used?

Since Excel 2007, Microsoft has split the classical .xls format to several formats (in particular, .xlsx, .xlsm, .xlsb). I've got no problem to understand the use and purpose of .xlsx format but I am still wondering whether we should use a .xlsm or…
JMax
  • 26,109
  • 12
  • 69
  • 88
105
votes
14 answers

Excel formula to reference 'CELL TO THE LEFT'

I'm trying to do conditional formatting so that the cell color will change if the value is different from the value in the cell left of it (each column is a month, in each row are the expenses on certain object. I want to monitor easily changes in…
mik
  • 1,668
  • 4
  • 15
  • 15
93
votes
12 answers

Append same text to every cell in a column in Excel

How can I append text to every cell in a column in Excel? I need to add a comma (",") to the end. Example: email@address.com turns into email@address.com, Data…
Keyur Shah
  • 1,335
  • 1
  • 11
  • 14
66
votes
34 answers

Excel: the Incredible Shrinking and Expanding Controls

Occasionally, I'll happen across a spreadsheet which suffers from magic buttons or listboxes which get bigger or smaller over time. Nothing in the code is instructing this. Has anybody else experienced this joy?
Nick
  • 3,573
  • 12
  • 38
  • 43
56
votes
5 answers

Excel Date Conversion from yyyymmdd to mm/dd/yyyy

I have been searching for about an hour on how to do this in Excel. I have an Excel file that was created from an old system and I am pulling information from a SQL Server Database, I will be inputting the information back into the SQL Server…
Malachi
  • 3,205
  • 4
  • 29
  • 46
50
votes
5 answers

excel delete row if column contains value from to-remove-list

Let's say that I've got a sheet - number one - with over 5000 rows (say, columns 'A' - 'H' each). In another sheet - number two - I have a "to-remove-list" - a single column 'A' with 400 values, each containing alphanumerical string (example:…
user1666562
45
votes
8 answers

Closing Excel Application using VBA

I have used the following without success. The active workbook closes, indeed, but the excel window remains open. Application.ActiveWindow.Close SaveChanges:=False ActiveWorkbook.Close SaveChanges:=False Which is the command that terminates the…
Brani
  • 6,454
  • 15
  • 46
  • 49
45
votes
7 answers

Number format in excel: Showing % value without multiplying with 100

When I set format of a cell as %, it automatically multiply the value with 100 & show the value. So 5.66 becomes 566 %. I want to apply % format on a column but want to keep the values same as before. I just want % sign to be shown along with the…
SharpCoder
  • 18,279
  • 43
  • 153
  • 249
43
votes
3 answers

Excel how to find values in 1 column exist in the range of values in another

I have two columns- column A which extends upto 11027(values) and column I which extends to 42000(values).Both the columns contains some code details. Something like this A B q123 as124 as124 gh456 ff45 …
user1254579
  • 3,901
  • 21
  • 65
  • 104
41
votes
3 answers

Find if column contains value from another column?

I have two columns. Column E extends up to 99504 (values) and column I extends to 2691 (values). Both columns contains filenames with extension. Something like…
Nemo
  • 1,111
  • 6
  • 28
  • 45
1
2 3
…
99 100