I have a column which is the name of cities. There are about 5 cities
which is repeated in 50 records (rows). I want to get the name of this
5 cities in a separate column. How can I do this?
TIA

I am tired of resetting page attributes on similar worksheets within
a workbook.  Seems like one should be able to copy print settings
(margins, footers, headings, font, etc. etc.) from one worksheet to
another with one click like the format brush.  What am i missing?  Must

I have one sheet that has many columns and is basically a mess (but that's
another story).  The people using it update values in 2 of the columns, and
then HAND ENTER the same data into another worksheet in another workbook.
So I say, "that's ridiculous, there's gotta be a way to ...

I want to enter today's date in column A anytime that a change is made
in the row, e.g. enter today's date in A1 if any cell from B1 to ZZ1
is changed. Are there any fucntions that can be invoked to do this or
does it require some VBA code?

I oftentimes use alt-tab to switch from one window (i.e., some website
having data) to excel.
Oftentimes I have a search box open in excel because I want to see if I
already have certain data from the website located anywhere in my

Hi, is there any way I can automate the process of of adding a blank row
between rows in a >400 row Excel 2003 spredsheet.?
Thanks,
Mike

Hi! I am using data validation with combobox autocomplete and it's working
fine. However, I noticed I am unable to cut and paste values from other cells
(cells which do not have data validation) I'd like to know if there's any way
I can have the cut and paste function back? ...

I am trying to create a line graph from multiple worksheets, within the same
file. I have a budget with each year on a separate worksheet, but I need a
graph showing the five year trends.
I am using Microsoft Excel 2003 (11.8120.8122) SP2.

Just another newbie question for anyone kind enough to respond:
Is there a way to reference a group of cells (eg. a column of 20 values)
directly to another group of 20 cells on a different worksheet, but within
the same file?

I loaded the Analysis pack addin, typed 100 in B1, in B2 typed =CONVERT(B1,
"F", "C") and I get #VALUE, no matter what I do. I changed number format
also but of no avail. What's wrong?

Hi
In Excel 2003, I could click on Tools/Options and then tick the "view page
breaks" box, so that I could see dotted lines representing my page sizes in
workbook (normal) view, but I can't find a similar command in Excel 2007,

I have a series of data, which represents the mean sold price of an
item, with one value per day.
Could anyone please advise how I (robustly) create an Index based on
this data series. I've seen similar things elsewhere, where the index is

Say I have data similar to the following:
Col A     Col B
1            3
2            6

I would like to use a formula to tell whether one date and time is
earlier or later than another.
In cell A1:  4/7/07 1:00PM
In cell B1:  4/4/07 5:00PM

I have a spreadsheet which, until recently, on opening updated links to
external spreadsheets (whether or not the file was already open).  Now, for
some strange reason, it updates all but one link but it will do so when that
file is already open.  I get the message "The workbook ...