![]() Then, in Excel 2003, choose Row or Column from the Format menu and select Unhide. If you need to unhide the rows and columns, first select the entire sheet. Note: Figure C Figure C Restoring the display LEARN MORE: Office 365 Consumer pricing and features Press Ctrl + Shift + Right Arrow and then choose Column from the Format menu instead of Row. Repeat this process to hide unused columns, only select the column header in the first empty column. Then, choose Row from the Format menu and select Hide. (Select the row header to select the entire row.) Next, press Ctrl + Shift + Down Arrow to select every row between the selected row and the bottom of the sheet. To hide unused rows in Excel 2003, select the row beneath the sheet’s last used row. To demonstrate, we’ll use the sample worksheet shown in Figure A, which has a small working area and a whole lot of unnecessary rows and columns. By hiding unused rows and columns, you present a sheet that focuses on just the work area. But you can also hide unused regions of a sheet to keep users from exploiting unused areas or to help keep them on task by not allowing them to wander. You usually hide a column or row to conceal or protect data and formulas. Top TechRepublic Academy training courses and software offerings of 2022īest project management software and tools 2022 Best tech products and most innovative AI/ML companies of 2022 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |