Highlight the next column to the right (column AR).Find the last column in which data appears (column AQ, say).Often you don't know why it's happened, and you can't find any data anywhere near those extremes. It's basically saying that there's something at the far right of your worksheet (column IV pre–Excel 2003 column XFD thereafter), or else at the very bottom (row 65,536 pre–Excel 2003 row 1,048,576 thereafter). I adore its use of the "off of" artificial construct. Select another location in which to insert new cells, or delete data from the end of your worksheet. To prevent possible loss of data, Excel cannot shift nonblank cells off of the worksheet. When you try, it will give you the following error: Sometimes you'll encounter a spreadsheet that doesn't allow you to insert a new column.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |