Excel for mac part of the cell is hidden mac os x#
Select View » Project Explorer (Ctrl-R) on Windows, or press -R under Mac OS X to visit the Project Explorer. Right-click the sheet's tab at the bottom left of the window and select View Code from the context menu. The second way to establish boundaries is to specify a valid range in the worksheet's Properties window. If all went according to plan, your useful cells should be surrounded by a gray moat past which you cannot scroll. Do the same thing for unused columns find the last-used column, select the entire column to the right of it, press the Ctrl and Shift keys while pressing the right arrow, and select Format » Column » Hide. Select Format » Row » Hide to hide them all. Press the Ctrl and Shift keys while pressing the down arrow to select all rows beneath. 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 kommentar(er)
