Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Điều hướng một Workbook Sử dụng tên Range Một trong những lợi thế lớn của việc xác định tên dãy là họ làm cho nó dễ dàng hơn để di chuyển một bảng tính. Bạn có thể chọn một tên từ danh sách và Excel tự động chọn phạm vi liên quan | Navigate a Workbook Using Range Names One of the big advantages of defining range names is that they make it easier to navigate a worksheet. You can choose a range name from a list and Excel automatically selects the associated range. This is much faster than scrolling through a workbook by hand or by entering a cell or range reference into Excel s Go To command. Excel offers two methods for navigating a workbook using range names the Name box and the Go To command. Navigate a Workbook Using Range Names Navigate Using the Name Box 1 Open the workbook that contains the range you want to work with. 2 Click the Name box . 3 Click the name of the range you want to select. Excel selects the range. Working with Range Names CHAPTER 4 Navigate Using the Go To Command 1 Open the workbook that contains the range you want to work with. 2 Click the Home tab. 3 Click Find Select. 4 Click Go To. Note You can also select the Go To command by pressing ED 3. The Go To dialog box appears. 5 Click the name of the range you want to select. 6 Click OK. Excel selects the range. Is it possible to navigate to a named range in a different workbook Yes but it is not easy or straightforward 1 Follow Steps 1 to 4 on this page to display the Go To dialog box. 2 In the Reference text box type the following workbook worksheet name 2 Replace workbook with the file name of the workbook worksheet with the name of the worksheet that contains the range and name with the range name. 3 Click OK. Change a Range Name You can change any range name to a more suitable or accurate name. This is useful if you are no longer satisfied with the original name you applied to a range if the data changes and the original name is no longer suitable for the new data or if you do not like the name that Excel generated automatically from the worksheet labels. If you want to change the range coordinates associated with a range name see the second Tip on the next page. Change a Range Name 1 Open the workbook that contains
