I saw a solution for "Allowing Input, but restricting deletion" once data is
entered into a cell and it works great (thanks Gord Dibben), however, it does
not work when I set my workbook up for sharing.  I need to have a workbook
that many people can access but once the cell is ...

I work with farily complex Excel worksheets which require print outs
as both hard copy and PDF.  I normally keep the formatting as they are
and select [Black and White] in [Page Setup] [Sheet], as this
preserves the integrity of the financial model while printing out a

Suppose I have two columns of numbers:
1  7
3  -6
1  0

I'm noticing this while trying to PDF in MS Excel (2003).  When I try
to send the pages I'm interested in PDF'ing to the printer to create
an Adobe document, the tabs are all saved as separate files.  I have
up to 200 pages that I need to PDF, and many of these documents are in

I have a workbook with two sheets pertaining to this issue. I have one sheet
(A) with a keycode, description, unit of sale , and cost. This sheet has
multiple listings of products
EX.

I'm new to Office 2007 so I thought this would be a good place to start.
I have files created in Excel 2003 as I had been using Office 2003 prior to
upgrading. Now, when I open a old spreadsheet in 2007, it is opened in Read
Only Compatibility Mode. I only have one user, me, on ...

sorry, to bother u with a noob question, but for selfstudy purposes i have
come across a thing that i would like to figure out on how it works. how does
it work ? (i don t even know what it is called, so i best describe what i
mean....

Let's say I have a table:
Month   Usage
Jan        10
Feb        12

I have created a worksheet in Excel but when I print it I only get the column
heading, lines inserted within the document but the data does not print.  
Help!

I am logging telephone calls per month and have been playing around with the
pivot table function, I'm having a problem in that I want to specify the
number of rows to the endth row, ie. 65536 to throw up the cost per call in
the table so that in future when I add call data to ...

This sounds so stupid but I can't find an answer.  How do I force users
to input only positive amounts in a cell.  I would like that 0 would
also be an acceptable value but no negative amounts.

I have created two worksheets:
1) Auction Items
Item# Table# Location# ItemDescription WinBid are the headers of the data.
2) Bidders

I'm a newbie as far as Excel is concerned. I'm using Excel 2003 and
having 2 problems that, coincidently, involve dates.
1. I want today's date to display as "01 September 2007", say. I used
the NOW function and got "01/09/2007 12:38". Although I would prefer to

Can anyone give me some help with a problem I am having in my payroll
packet at work - the explanation is quite long and involved, but here
goes. My payroll packet has different lettered sheets, one for each
letter of the alphabet.  I input 2 weeks worth of time in these sheets

Is there some way that I can password protect a an xl workbook that is also
shared. The intention is to have a file that calculates freight rates
available to marketers without them stuffing up the formulas in it.
I know how to protect certain cells from being edited and others ok ...