![]() ![]() Therefore, you can check the sales volume in a small range. Besides, you can also input the current value directly into the link cell. The numbers in the area will also change according to the current value. ![]() Now you can click the arrow in the scroll bar or drag the scrollbar. And then you will get the first 5 rows in the range. Now use the fill handle to fill other cells in this range.In this formula, you need to use the absolute for the cell E1. E1 is the link cell that we use for this scrollbar. A1 is the first cell in the original area. Here we use the OFFSET function to return the value. In this example, we input the formula into the cell F1. Now input this formula into the upper left cell in the scrollable area.And then adjust the size of the scrollbar.After that, input the same column header into the area that you need.When you finish those settings, click the button “OK”.You can also use your mouse to select the designated cell. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |