What's the difference between a Table and a Named Range in Excel 2007??

Can someone explain the difference between Excel Tables and Named Ranges in Excel 2007? It seems that in addition to...

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 a...

Upon clicking on a file, excel opens but not the file itself?

Platform: Windows XP SP2, Excel 2007 Problem description: Upon clicking on a file in Windows Explorer (file is eith...

How to get excel row numbers to skip the header?

This is really a cosmetic question. Excel by default starts counting from line one which is the header. Is there som...

How do I line up two sets of data in Excel??

If I've got two sets of data, how can I line them up in Excel 2007? For example, if one set of data has Position ...

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 th...

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'...

Auto-fill a repeating pattern in Excel?

I'm trying to use auto-fill to continue a pattern, however it's skipping several numbers as it fills. For example, t...

Alt + E, S suddenly not working?

Yesterday 'Paste Special' using the right mouse click and the keyboard shortcut Alt +E,S stopped working. Applicati...

How to make cells perfect squares in Excel??

In Microsoft Excel, I want to make the height of first three rows and first four columns (12 cells in the top lef...

Excel ran out of resources while attempting to calculate one or more formulas?

I received the error message "Excel ran out of resources while attempting to calculate one or more formulas" on ONE...

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 te...

Excel: how to disable extend selection mode (F8 key) being activated by “-” key??

Using Excel 2007, every time I press the "-" key, the extend selection mode is activated. Notice that in other progr...