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.

2269 questions
19
votes
10 answers

Unhide row doesn't work

One worksheet doesn't show the first 15 rows. I tried the followings, neither worked, even in full-screen mode Step 1: F5 (Ctrl+G) to define & select 1:15, set row height to 20 and "unhide row", they are still hiding; Step 2: Put cursor in A16,…
PerlDev
  • 291
  • 1
  • 2
  • 3
11
votes
3 answers

Text cell is displayed with hash characters

In Excel 2007, I see that the content of some cells are displayed as hash characters (###). These cells are formatted as text and their contents are displayed like this if the number of characters are more than 255. Is there any way to fix this?
Ashwin Nanjappa
  • 10,167
10
votes
2 answers

How can I refresh a document I have open in Excel in read-only mode?

I have an Excel document that is stored on a SharePoint Server, which I always have open on my computer in read-only mode because I need to refer to it. Every so often, in order to get the latest changes, I have to close down the file and reload it…
RoboShop
  • 3,576
9
votes
6 answers

Why does Excel now give me already existing name range warning on Copy Sheet?

I've been working on a Microsoft Excel 2007 spreadsheet for several days. I'm working from a master template like sheet and copying it to a new sheet repeatedly. Up until today, this was happening with no issues. However, in the middle of today…
WilliamKF
  • 7,908
9
votes
2 answers

Automatic hyperlink in Excel

Is it possible to hyperlink a url in excel automatically. I mean when the cell starts with something like http or www can I hyperlink that. Currently, I have to hit enter in the cell value in the formula bar to make the link as clickable. Also if I…
developer
8
votes
4 answers

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 the link. If I do Paste Special > Values, it does…
Pete
7
votes
2 answers

Set default cell value in Excel

Other than the top row, which is a header, I'd like one column to always have a default value, ideally added when that row is not empty... so I don't have an infinite number of rows with just the default value. I couldn't find a way to set default…
Mr. Boy
  • 5,256
7
votes
2 answers

How to Use (--) this in Excel Formula

I found (--) this to add criteria in a sum Function, can you please tell me its exact use. And is this function(--) (whatever it is called by) can be used in any other formula?
Sarthak Gupta
  • 71
6
votes
4 answers

Excel 2007: Possible to Wrap Text But Not Split Words?

Is it possible to use the wrap text option in an Excel cell but not have it split words when autoresizing? For example, if I have this text in a cell "This is my column title", it would be okay when I autosized (double click the column border) to…
sdoca
  • 690
5
votes
3 answers

Can't create a scatter chart from a pivot table in excel

No, excel. I can, it's just you that won't let me. *copy/paste, create chart, done*. Is there a way to bypass this check? Copy/paste works, but I'd like a scatter chart from a pivot table to automatically update when I change the source data.
jozxyqk
  • 2,782
5
votes
4 answers

"Remove Duplicates" feature does not remove all duplicates

When the Data Tools>Remove Duplicates command is used on the following list, some duplicates are not…
raph82
  • 116
5
votes
1 answer

Embed an Excel document into a worksheet in another Excel document

I have an Excel document in which I want to add another Excel document. I hoped it would be possible in the same manner how we used to embed a Word document in another, using the Insert → Object option. But this doesn't seem to work with Excel. Is…
Sandeep
  • 390
5
votes
2 answers

Excel repeatedly changes cell number format to Text

I've used Excel more than I care to think about, but this is a new one for me. I have a cell with a simple formula, =Counts!E3. I set the number format to General. I edit the cell (just F2-Enter, no change). The formula no longer works, and when…
user49214
5
votes
1 answer

Perform data validation from table on different worksheet in Excel 2007

Is it true that in Excel 2007 you can't do list validation to a table on a different worksheet, only a named range that is not a table? I enter a Source of =Responses and it keeps complaining "The formula you typed contains an error." On the…
ErikE
  • 264
5
votes
2 answers

Is there any way in Microsoft Excel that two or more consective blank rows converted to one blank row

I have MS Excel 2007 document where i have many blank lines between data. i want that if there are more than one blank lines then all others are deleted but only one blank line is left
Mirage
  • 3,183
1
2 3
…
15 16