When cutting the CONTENTS of a cell in Excel I do not want the BOARDERS to be
cut....!!!! this drives me nuts!  The only way to protect the boarders is to
create a "safety" rom/column of cells between the data cells and the boarder
cells which is not always possible.. Also the ...

I need a macro to set the print area of a sheet that may vary greatly in the
number of rows - in Visual Basic, the macro seems to only accept this
instruction as a specific reference to a cell range.  I cannot pre-format the
sheets or tel it to 'fit to' as again, the size varies ...

I'm trying to set up a spreadsheet so that people can pick their dates from a
calendar, rather than retyping the date whenever it changes.  Sort of a
covenience thing and it reduces errors, hopefully.

Trying to use the Proper Function in Cond Format so when people type names it
automatically corrects it to Title case.Please advice how i can acheive this.
Many thanks
laurie g

I have tried to creat a farm template for my goat farm and cows but have been
unsucessfull of creating on that looks profesional enuf for others to view
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the

Can I set a cell to equal a font color, such as:
if any cell within B4 to B21 equals "1" I would like the "1" to
automatically come up red, if its a "2" then it will be yellow.  
Thanks

Hello  I created an advanced filter but when I run the advance filter the  
comments on the cells are gone.  How can I view these comments on the advance
filter  thanks in advance

I have 3 sheets in my workbook. 2 lists and 1 matrix.  Is there a way to
make the values of a column in 1 of my lists to be the values of a row (the
column headers) in the matrix.  I can link the values from 1 column to
another but not a column to a row.

Hello. I'm having problems with the LEFT function of Microsoft Excel. I'm
trying to have cell B1 display the date in A1 (but not the time). In cell B1
the formula is
=LEFT(A1,10), and this displays 38623.6205. I do not understand why this

how can I tell to calendar object that it should allways use current
date as default?
hannu

I have the following
Column   A       B       C      D      E      F       G
Row
1                       Z       Y      X      W      V       U

I would like a formula that checks through several levels of criteria before
returning the value.
So, for example, I have the following:
1     A       B     C     D     E

What is the best way to generate an auto number, like an invoice number, on a
template so that each time a new workbook is created a sequential number
appears
thanks in advance

I have a large table of data from which I would like to extract a number of
sub-tables to new worksheets, for instance I would like to have a sheet
showing all entries for a particular module reference.  I suppose this is
similar to an advanced filter but using different ...

This isnt really an excel question but I thought Id try on here just in case
anyones come across this before.
In short I have a networked xls file which the server thinks is open and
therefore the users can do nothing with it apart from use it as read only.