Sequential column numbers

[C Holmes]

I want to delete a column in my spreadsheet and when I do the column heading indicates a column is missing. If I delete column 6 I would like column 7 to become 6 and so on. How do I do this?

[Ron Coderre]

Try a variation of this example:

A1: =COLUMNS($A:A)
Copy that formula across through H1

That will generate a series of digits from 1 through 8

If you delete any of those columns, the numbers automatically change.
For series that start in another column, just change the initial column ref...
eg C1: =COLUMNS($C:C)

Is that something you can work with?

[6StringJazzer]

A slightly simpler alternative is

A1: =COLUMN()

And copy to the right. Of course, this only works if you want A to be Column 1.