Putting columns back in alpha order

C

CLytle

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?
 
E

Elkar

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
 
D

David Biddulph

CLytle said:
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?
Click to expand...

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.
 
B

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
 
C

CLytle

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.
 
C

CLytle

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.
 
C

CLytle

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.
 
C

CLytle

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.
 
R

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.
 
Top