Putting columns back in alpha order

[Guest]

I have a file where the columns go from A to G then skips to AU so I can't
average the row. Can I "rename" the columns so there is no break from G to
AU?

 

[Sandy]

Try using

=AVERAGE(A1:G1,AU1)

Sandy

 

[Guest]

It sounds like your columns H through AT aren't out of order, but rather have
been hidden.

Select Columns G and AU
Click on the "Format" Menu
Select "Column"
Select "Unhide"

Now, you should see all of your columns.

HTH,
Elkar

 

[David Biddulph]

I have a file where the columns go from A to G then skips to AU so I can't
average the row. Can I "rename" the columns so there is no break from G
to
AU?

If you can't see the columns from H to AT, then they are presumaby either
hidden or have zero width. If you select columns on either side (or the
whole sheet) then you can unhide and/or set the width to something visible,
then if you want to delete the columns you can.

 

[Bernard Liengme]

Sounds like there are hidden columns - you cannot rename columns
Select the column headers G and AU and right click - is there an Unhide
item, if so click it
Happy Thanksgiving

 

[Guest]

Thanks for your help. But columns are not hidden. I am getting this file
second hand, at some point someone deleted the columns but however they did
it, the columns letters did not adjust.

 

[Guest]

Thanks for your help. But columns are not hidden. I am getting this file
second hand, at some point someone deleted the columns but however they did
it, the columns letters did not adjust.

 

[Guest]

Thanks for your help. But columns are not hidden. I am getting this file
second hand, at some point someone deleted the columns but however they did
it, the columns letters did not adjust.

 

[Guest]

Thanks for your help. But columns are not hidden. I am getting this file
second hand, at some point someone deleted the columns but however they did
it, the columns letters did not adjust.

 

[Roger Govier]

Hi

Judging by the replies you have had, and the common response you have
given to each one, if the columns are not hidden, are you saying that
all columns are visible, but there is only data in A to G and then again
from AU to say BD

=AVERAGE(A1:BD1) will return the correct result, because Average ignores
cells which have blank values
Equally
=AVERAGE(1:1)
will give you the correct average of all cells that contain numeric data
in row 1.