Microsoft Office Tutorials and References
In Depth Information
Using Go To for Navigation
Using Go To for Navigation
You can press the F5 key to display the Go To dialog. Then you can type a
cell address and click OK to quickly jump to that cell.
You can also use the Name box the same way you use the Go To dialog. The
Name box is the drop-down area immediately to the left of the formula bar.
You click in the Name box, type a valid cell address, and press Enter. Excel
then jumps to that cell.
Understanding the File Formats
Excel 2007 introduced three new file formats, which are discussed in this sec-
tion. Later, the section on file compatibility discusses how you can continue
to share files with people using legacy versions of Excel.
A Brief History of File Formats
A Brief History of File Formats
Excel has traditionally stored workbooks in Binary Interchange File
Format (BIFF). The BIFF specification has changed occasionally over time.
In 1993, when Excel expanded to 16,384 rows, Microsoft began using BIFF5
format. In 1993, most companies did not have corporate local area networks
(LANs); a file format conversion therefore usually affected just one per-
son on one computer. If you had upgraded from Excel 4 to Excel 5, as long as
you had a way to convert your Excel 4 files to Excel s new BIFF5 format,
everything was fine.
Note
Although you will generally be saving files in one of the .XLSB,
.XLSX, and .XLSM formats, there are other new file formats. The
.XLAM format is used by developers to distribute add-ins. The .XLST
is a template format.
In 1997, Microsoft introduced a major file change, BIFF8. This version of
BIFF allowed 65,536 rows. The rise of the Internet and email meant that far
more people were now sharing files. Excel 97 offered a way to save files in
the old format in case you needed to share files with a person using a legacy
version of Excel.
All BIFF versions are proprietary formats. Figure 7.4 shows an Excel 2003
spreadsheet as viewed in Notepad. You would certainly never be able to open
Search JabSto ::




Custom Search