Super User Stack Exchange
Super User Stack Exchange

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.

Microsoft Office Excel is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X as part of the Microsoft Office suite.

A new user-interface design, dubbed the "ribbon", was introduced with Excel 2007 for Windows. A similar UI was introduced to Excel 2011 for OS X.

Excel is the among most widely used spreadsheet programs, especially in business environments. The first version was introduced in 1993, and new versions have been released every 2-3 years since then.

2256 questions
167
votes
6 answers

Is there a way to scroll, by pixel, instead of by cell, in either Excel or OpenOffice Calc?

We have lots of spreadsheets that have lists of numbered sound files for an educational app. We use spreadsheet features such as "fill down" for the numbering, and we often use formulas to check whether contents of cells are the same when edits are…
Triynko
  • 3,274
  • 7
  • 24
  • 27
155
votes
5 answers

Is it possible to paste CSV formatted data into Excel 2007?

I want to copy and paste CSV formatted text into Excel 2007. Is there a way of doing this without saving it to a temporary file first? I'm sure in previous versions of Excel there was a way to trigger the CSV import wizard by hand in this situation,…
therefromhere
  • 8,412
  • 10
  • 42
  • 43
139
votes
8 answers

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?
C. Ross
  • 6,174
  • 16
  • 62
  • 82
132
votes
6 answers

Turn off scientific notation in Excel

I would like to prevent Excel behavior that any large number I enter is stored as a number, then abbreviated to scientific notation. Is it possible to tell Excel 2007 to stop doing this?
Pierre Gardin
  • 1,454
  • 2
  • 10
  • 10
88
votes
13 answers

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? Example I would like to select data cells of a…
Robert Koritnik
  • 2,016
  • 6
  • 28
  • 43
76
votes
21 answers

Excel Auto-Fill a Series Without Mouse (Keyboard Only)

So when I want to extend a series or something along those lines, I can highlight a group of cells, then click on the bottom right corner of the highlighting box and drag down. Excel will then attempt to automatically extend the contents as well as…
jtpereyda
  • 2,447
  • 3
  • 23
  • 29
74
votes
3 answers

What is the maximum allowed rows in a Microsoft Excel .xls or .xlsx

Is there a limit? I couldn't find one posted.
Andy
  • 882
  • 1
  • 6
  • 8
73
votes
12 answers

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 | LocNum | Loc ---+--------+---- 1 | 1 | NY 1 | …
devuxer
  • 3,951
  • 6
  • 31
  • 33
61
votes
2 answers

Excel - can I set a cell to equal a certain value, no matter what is typed in it?

This is to play a joke on someone...not sure if it's possible to do what I want. We are circulating an Excel file among friends to select players for a golf tournament. I would like to set a cell (call it A1) to to show a certain name (call it…
Adam
  • 601
  • 5
  • 4
61
votes
22 answers

Unable to get Excel to recognise date in column

I constantly have problems working with dates in Excel, I must be doing something wrong but I don't understand what. I have a spreadsheet, exported from our exchange server, that contains a column with dates on. They have come out in US format even…
Patrick
  • 1,488
  • 4
  • 16
  • 28
56
votes
17 answers

Copy Excel worksheet and maintain relative cell reference in formulas

Another copy problem in Excel: How can I copy a Worksheet from WorkbookA.xlsx into WorkbookB.xlsx without the copied Worksheet still referencing WorkbookA.xlsx e.g. the formula =B!23 becomes =[WorkbookA.xlsx]!B!23 when copied over. I want to…
Jake
  • 2,029
  • 10
  • 32
  • 46
56
votes
12 answers

Excel keyboard shortcut to copy/fill down for all cells with non-blank adjacent cells?

I'm looking for a keyboard shortcut that will duplicate the functionality available by double-clicking the "handle" in the bottom-right corner of a cell. Is there something that can do this, without third-party software or creating custom macros?
Iszi
  • 13,585
  • 44
  • 113
  • 181
39
votes
17 answers

How to get the current column name in Excel?

What is the function to get the current line number and the current column name for a cell in Excel?
Jader Dias
  • 15,756
  • 60
  • 143
  • 196
39
votes
9 answers

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 colour for the editor (I can only choose from the…
Breakthrough
  • 34,227
  • 10
  • 105
  • 149
36
votes
4 answers

Excel: filter a column by more than two values

I have a worksheet with a column, user_ID, that contains a large number of user IDs I'd like to filter it down to about a dozen IDs, but using Filter -> Custom Filter only allows me to filter by 2 IDs total. Is there a better way to filter this…
fox
  • 797
  • 6
  • 10
  • 17
1
2 3
…
99 100