3 ms·
> Instead of writing the formula =A1*B1, you can do =Width*Height like you should have been able to 30 years ago. I don't have access to super old versions of
by bambax 4y ago
> Instead of writing the formula =A1*B1, you can do =Width*Height like you should have been able to 30 years ago.
I don't have access to super old versions of Excel, but I just confirmed that it worked perfectly well in Office 2003. I believe it's been the case forever.
(I wrote whole apps in Excel4 super-weird macro language in 1992-93 and distinctly remember we had named zones.)
- Someone 4y agoMicrosoft Multiplan for CP/M supported that in 1982 (http://www.bitsavers.org/pdf/microsoft/cpm/Microsoft_Multiplan_for_CPM_1982.pdf http://www.bitsavers.org/pdf/microsoft/cpm/Microsoft_Multipl..., page 99) I think later versions of VisiCalc did, too.
- adrian_b 4y agoAlready Lotus 1-2-3 for MS-DOS had named ranges. As Excel was made since the beginning as a replacement for Lotus 1-2-3, I believe it also must have had named ranges at least from its version for MS Windows 3.0. IIRC, when I have first used Excel, which was the Windows 95 version, it had them.
- pwinnski 4y agoI recall it not have named ranges initially, but I remember them being added pretty quickly. Not sure what year, but very early. The name manager was added in Excel 2007.
- wesnerm2 4y agoFormer Excel 97-XP developer here. Excel 97 had English language formulas. It automatically detected names in tables; however, it was buggy. The feature was removed in a later version (2007?).