hi, my worksheet seems to have limited column range. Last column is R and I can't insert any more column. I cant also move my cursor to the right of R. Im getting the error:
"To prevent possible loss of data, Excel cannot shift nonblank cells off of the worksheet. Select another location in which to insert new cells, or delete data from the end of your worksheet.
If you do not have data in cells that can be shifted off of the worksheet, you can reset which Excel considers nonblank. To do this, press CTRL+End to locate the last nonblank cell on the worksheet. Delete this cell and all cells between it and the last row and column of your data then save."
I have tried the instruction above but still last column is R and cant insert more. Last nonblank cell is already in column R. There's also no hidden columns either. I've selected all and unhide but still, last column is R.
Help pls on how to expand the range and add column. Thanks!
Bookmarks