I am trying to figure out how to sort columns in order without having t
cut and insert the whole column.  For example, Column, G is 10, colum
H is 9, column I is 8; I would like column G to be 8, column H to be 9
column I to be 10.

I know that you can place the name of the file (&[File])
into the header and footer of a worksheet.  But is it
possible to do the same into a cell?  If so, how would it
be done?

Ok, let me explain subject line. I have a spread sheet where I want to be
able to put in T in a cell which represents if tax is paid, what I would
like is that by having a t in one cell the cell with the formula for tax is
used. i.e. if cell B1 has a T in it, then cell J1 will run ...

I have a simple function to subtotal a long column.
The function is   =SUBTOTAL(9,P7:P850)
some of the cells in the column have values but don't add to th
total.

I teach teenage boys computer basics and am currently going over Excel
with them. I came across something which I am sure is inefficient the
way I explained it. I would like to know the best way to build a
spreadsheet for the following scenario :-

I am using Excel 2002.  I cannot get Excel to fill in a series based on
lower case or upper case letters.  I want to fill in a series of cells with
a, b, c, ...zz.  Upper or lower case would be fine.  I figure this would be
a very basic thing for excel to do.  I have tried starting ...

I have a list of timecodes, examples,
ESD1.2
ESD12.3.2
ESD12.4.12

I am writing a spreadsheet which requries users to enter a numbe
value.
i want to set the spreadsheet up so to allow an entry tp be made o
altered on or before todays date - but prevent any entries o

Excel 2k, win2k both updated
Wishing to link to an Access2k db.
Any attempt to 'get external data' causes excel to stop responding; no link
or external data window opens.

I have a sheet in a xlw which has data in just 200 rows but the scrol
bar  believes that the sheet uses every row - this makes it hard to us
the scroll bar to scroll down the 200 rows.
How do I reset the size of the sheet to the rows uaed so that scrollin

I'm trying to delete data I don't need but I need to keep all Row data in
sync while I sort any of the column data.
What would I need to do to get this done?
Thanx

I have a simple form in Excel. In this form, I have a the member'
number, name, address and phone number. Presently, I save each for
under the member's number. So I have a bunch of files.
I would like to use only 2 files (one for the form and one for th

Is there any way to have a drop-down menu within a cell so that I don't have
to paste form buttons for each line?
I'm building a spreadsheet to track packaging graphics here and would like
to have a set of repeating predetermined values for each line of packaging

I want to have my workbook both protected and shared, whilst still leaving
autofiltering turned on.  The workbook runs fine without sharing it :  at
startup it calls a macro which:
.EnableAutoFilter = True

I just performed the "Text to Columns" function in Excel and it didn't do exactly what I was hoping for. I have a spreadsheet with 1300 addresses in the following format:
Street Address
City, State Zip
I want to change it so that Street Address is a separate column and City, State ...