fbpx

Remove cell spill-over from Excel data

If a cell has no data in it, the data from the cell on the left side spills over it. This can lead to confusion while reading and understanding the data. How to remove this cell spill-over?  Very simple. Just three steps:

image

  1. Select the data range.
  2. Press Ctrl G or F5 to open the Go To dialog.
  3. Click the Special button.
  4. Choose the Blanks option.
  5. Now, all the empty cells in the highlighted area will be selected.
  6. Just type a spacebar. This will go automatically into the active cell.
  7. DO NOT press ENTER. DO NOT disturb the selection.
  8. Press CTRL ENTER.
  9. That’s it. Now all the spill-over items will be truncated.

image

Share on linkedin
Share on facebook
Share on twitter

Queries | Comments | Suggestions | Wish list

teams logo

Teamwork Beyond Meetings

Thu 5th Nov – 7pm IST 

Teams Gif

Teamwork Beyond Meetings

Event by Dr. Nitin Paranjape
Thursday, 5th Nov
7 pm IST