I have a spreadsheet with several rows of data.
The first cell of each row contains a logical formula which equates to
'TRUE' or 'FALSE'.
I want to hide the rest of the cells in the row if the first is FALSE.

What I want it to do is
I have a drop down list in cell D3 that will display a name such as smith
I want cell E3 to display a number such as 200
is this possible in excel

Hi new to the forum - hope this is correct format
Half my work deals with the calendar year 1/1-12/21
and half deals with FY 10/1 - 9/30
I am trying to build a function that i could apply to a worksheet that

Is there any easy way to returnt to the previously selected cells? This is
helpful especially after "goto" or "find".

Using Excel 2003 and have put a check mark next to the box to "extend data
range formats and formulas."  I then began entering data and created a
formula in Column E that calculates a running balance based on whatever is
entered in the row.  When  I first built the worksheet, I ...

I have used the first couple of rows as 'headers'. When I want to
print this spread sheet I have set up the options so that these rows
are repeated on every page. I would like to know if I can keep these
rows locked on the screen so that as I move up and down thru the data

I'm attempting to create a scheduling calendar in Excel 2007 (but it needs to
be compatible with 2003) and I could use some help.
It's going to be used for work purposes and what I'm trying to setup is one
main calendar and then one secondary calendar for each project in my group. ...

i hope this is possible, i need a little help.
i use 2 excel files.
the 1st file (i dont think this matters, but) the filename always changes
InvoiceNumberTenantName.xls

When I create a pivotchart located on same worksheet than the pivot
table, I am unable to correctly display the sheet (layout and painting
problems).
Workaround :

I am using an IF formula to calculate between two cells, one is J (width) the
other is K (length).  Currently these formulas give an answer that then has
to be rounded up based on the decimal place.  I need the formula to also
round up the amount to quarter increments.  For ...

Good day, I am a lecturer and would like help with the following problem : I
have 10 students in a classs and the pass mark is 50% I want to determine the
no failed i.e how many students got below 50%
Test          Marks

I've got two questions regarding publishing Excel sheets as web
pages.  For the record, I'm using Excel 2007.
I have some text in a cell that is aligned 90 degrees from
horizontal.  When I publish this sheet as a web page, the alignment of

I use Conditional Formatting a lot!  However, it only allow three conditional
formatting for each cell. In my case, I need 5 conditional formats some time,
therefore, I have to choose three out of five.  
My question is that is there any way or with the help of excel formula, to

I am using Excel 2007 and have just loaded a spreadsheet created in a
previous version which is running in Compatibility mode.  When I try to
insert a row I get an message "Cannot shift objects off sheet".
How do I insert rows on this sheet?  No problem with another workbook ...

We distribute a MS Access (97) application which references Excel's object
model to import various spreadsheet content. This works well up to and
including Excel 2003. In principle would there be any major problems using
the app. on a 2007 Excel file ? and if so how could this be ...