![]() On your sheet, locate the last row containing data and select the entire row below it by clicking the row label. The easiest way to establish boundaries is simply to hide all the unused columns and rows. Doing this also can make it less daunting to scroll around in a worksheet, as it is not uncommon for users to find themselves at row 50,000 and then start screaming that they are unable to find any data in a worksheet. ![]() ![]() You then can place data you do not want a user to see outside the scrollable area. A nice bit of spring cleaning limits the worksheet's scrollable area to just the part containing the data you want a user to see. More often than not, your worksheet uses only a small percentage of the cells available to you. ![]() All Excel worksheets created in Excel 97 and above are 256 columns wide (A to IV) and 65,536 rows long. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |