all of a sudden, save as opens a full screen, not the 1/4 page it used to be.
I must have changed something, but after checking all help related things, I
can't see how to change it back.
a normal excel page has view options, the save as screen doesn't

Can anyone help me out with the following, I have tried to use the OR
function but I have not been able to get the result I want.  Its a little
complicated but here goes.
I am trying to formulate an inspection report, here is the layout plus example

When I put this formula into cell N2, why does it occupy BOTH cells N2
and N3?
=IF(ISNUMBER(SEARCH(",",L2)),M2,L2)
Thanks

I want to take the data from one particular cell (i.e., B2) from a multiple
of workbooks and have that data put in a new workbook. I don't want to have
to open each individual file, since there are over 300.  Is there a formula
for this?

I receive financial data from the bookkeeper as an Excel workbook.  Openning
these workbooks turns ON the Reviewing Toolbar.  It then remains on, and
defaults on at next Excel start unless I remember to turn it OFF.  This is
annoying as there are no Reviewers changes or comments ...

Does Office 2003/ Excel 2003 have superscript or subscript icons that can be
dragged onto the formating toolbar?  My version does not have supersripts etc
as options.

Hi, I have a large sheet with dates going back to 2000 through to (at this
stage) 2012 in column A, the rest of the data across is personal details for
that day.
I want to be able to make a button bring up a box that I can enter a date,

I have an protected excel file (sheet1) with approximately 200 data entry
(200 rows and 10 columns). and user can enter the data in sheet1. I would
like to build a second sheet to do advance filter and display selected 5
column only not all but with a criteria cell in the second ...

I am unable to scroll down (scroll lock on my system is turned off) on my
spreadsheet.Its in a share drive..initialy it was in share mode..but now its
exclusive..not sure what the problem is..Pls help
Thanks

I am not getting the result for the below mentioned formula. I request any
one of you to help me in resolving the error.
Error : "You have entered too many arguments for this function"
Formula : =IF(ISERROR(VLOOKUP(CB2,Master!$G:$H,2,0)),IF(VLOOKUP('Base

I have an excel spreadsheet that has one sheet that defaults to 4 copies when
you print.  This spreadsheet is on a server and is able to be accessed and
updated by everyone in the company.  Everyone that prints it has the same
trouble as does everyone we email it to.  Does anyone ...

I'm trying to sum a column of numbers with =Sum(A2:A5).  Excel acts like no
numbers are present. I tried changing  cell formating, from general to text
to number with no effect. I can view the numbers but formulas don't seem to
recognize them. any suggestions to fix this would be ...

I am working in accounts dept and have to prepare excel invoices daily. I
have to write the total amount of invoice both in figures and words, right
now i m manually writing the amount in words. Is there any formula to convert
the figures to words? The amount to be written in USD ...

The reply I received suggested this formula...
=IF(COUNT(C1:D1),MAX(C1+90,D1+60),"")
Many thanks and I carefully tried it but did not completely work.
Maybe I confused the issue...

How to convert a CVS file to fit columns on an Excel worksheet