R-click header of Column A and pick Delete. Everything will move left
one column.

Cory wrote:

I need to shift all the cells to the left on a worksheet. When I go to delete
and choose to shift cells left. It only shifts the cells that I have
highlighted. How can I get all the cells to shift over so I can get
everything organized correctly?