Microsoft Office Tutorials and References
In Depth Information
AUTO-NUMBER RECORDS AND COLUMNS IN AN EXCEL DATABASE
Figure 65. h
e complete database.
Figure 66. Your goal is to have row labels in A and column labels in row 2 get renumbered as
shown here.
Solution: You start by defi ning the name Database for the range A2:G13. This
excludes row 1 from the default selection when you apply AutoFilter. You need
to put a space in the fi rst cell immediately following the last record (A14 in this
case). (This is a workaround to an annoying Excel bug that shows the last
record, regardless of whether it meets the fi lter criteria.)
 
Search JabSto ::




Custom Search