Re: my impressions of Excel 2007

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"T. Valko" <biffinp...@xxxxxxxxxxx> wrote...
....
On my 17" CRT monitor @ 100% zoom I get a whopping 18 rows by 11.6
columns work area!
....

I can understand fewer rows, but not fewer columns. I see all of A-O
and part of P at 1024x768 monitor resolution, maximized app and doc
windows, displaying the row/column frame, 8.43 standard column width
and Arial 10pt as standard font. Are you displaying a Task Pain on the
right?

FWIW, I also see 35+ rows at standard 12.75 row height (because I only
display the menu bar, formula bar and a single row of toolbars).


I like the expandable formula bar - nice for those monster formulas

Do the 2nd and subsequent lines use all of the space below the first
line, or do the left sides of the subsequent lines align under the
initial = on the 1st line? If the latter, is the space to the left of
the 2nd and subsequent lines wasted space? I ask because there's a lot
more, er, features to the left of the formula bar's 1st line.


Here's something I don't understand...

If I want to close Excel I have to click the "X" twice? What's that
all about?
....

Do you have Excel 12 set to display each document separately in
Windows's Taskbar? If so, welcome to Office 2007, in which defaults
for *ALL* Office programs are based on what makes the most sense to
*Word* users, not Excel users.


I'm wondering if IFERROR makes a real difference with real long
complex formulas. My guess is that it isn't any better than a
"crafted error trap" although it would shorten some formulas
considerably.

I'd guess the opposite: IFERROR would make error trapping much more
efficient. Indeed, to me it's about the only unambiguous improvement
in Excel 2007.
.

Relevant Pages

  • Re: Unacceptable floating point errors
    ... colleges and many commercial settings, (e.g., Mathematica), can provide ... Some software gives you better accuracy than does Excel. ... Single Precision Floating Points, about at 15 places in Double ... byte Double Precision Floating Point standard published by IEEE. ...
    (microsoft.public.excel.misc)
  • Re: What advantage ACCESS over EXCEL?
    ... answer was "we dont trust the Standard times on the Routers", ... EXCEL, well, if it's within EXCEL's size limits, then just about anything ... a relational database like Access can store that information once as ...
    (microsoft.public.access.gettingstarted)
  • Re: weird, hard to find Excel-automation error
    ... occured on subsequent print out and not on the first one. ... >> Approximately every other time everything runs without problems and fails ... >> I have Access open up Excel with the code below. ... >> Set objExcelDoc = objExcelApp.Workbooks.Add ...
    (microsoft.public.access.modulesdaovba)
  • Re: Saving a CSV file WITHOUT opening Excel
    ... >> But is that an industry standard or just how Excel exports to CSV? ... close to something like, say, the ANSI SQL standard? ...
    (microsoft.public.vb.general.discussion)
  • Re: Excell cant add
    ... ISO8601:2000 on dates has been around as a Standard for nearly 15 ... English and foreign language editions of Excel. ... > For those who don't know how these things are dis, ISO ... > decimal separator symbol, but I suggest that a problem that should ...
    (microsoft.public.excel.worksheet.functions)