When you try to insert rows or columns into a Microsoft Excel 2000 worksheet, you may receive an error message that is similar to the following: To prevent possible loss of data, Microsoft Excel cannot shift nonblank cells off the worksheet. To resolve this issue, clear each of the cells in the row or column, […]
Tag: excel
Show or hide rows or columns in Excel 2016
Hide rows and columns Select the row or column that you want to hide. On the Home tab, click the Format menu. Point to Hide & Unhide, and then click either Hide Rows or Hide Columns. Show hidden rows and columns Do one of the following: To Do this Display hidden rows Select cells in […]