สำหรับผู้ใช้ Excel 07 หรือเวอร์ชันใหม่กว่า ให้เข้าไปที่แถบ Formulas (สูตร) > Define Name (กำหนด ชื่อ) จะปรากฏหน้าดังรูปที่ 8To set up a chart that is automatically updated as you add new information to an existing chart range in Microsoft Excel, create defined names that dynamically change as you add or remove data More Information This section includes two methods for using defined names to automatically update the chart range Method 1 Use OFFSET with a defined name To use thisThe key benefit to using Defined Names scoped to the worksheet is that the worksheet can be cloned and all the formulas will continue to work without modification as the Defined Names are cloned with the worksheet When I create names for a structural purpose as described above, I usually prefix them with a BBB_ rather than the BB_ This is a way of differentiating them from the
ว ธ การแก ไข Name ข อผ ดพลาด Busy การสน บสน นของ Office
