Help!

display columns alphabetically

 
  

Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> New Users RSS
Next:  Create a cell with only PART of another cells dat..  
Author Message
Grocer
External


Since: Sep 21, 2009
Posts: 2



PostPosted: Mon Sep 21, 2009 10:51 am    Post subject: display columns alphabetically
Archived from groups: microsoft>public>excel>newusers (more info?)

Columns used to display alphabetically left to right. It changed to now
displaying numerically left to right. How do I change back to alphabetically?
Back to top
NBVC
External


Since: Sep 21, 2009
Posts: 1



PostPosted: Mon Sep 21, 2009 3:10 pm    Post subject: Re: display columns alphabetically [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Go to Tools|Options and then in the General tab, uncheck R1C1 reference
style.


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=136818
Back to top
Grocer
External


Since: Sep 21, 2009
Posts: 2



PostPosted: Mon Sep 21, 2009 3:10 pm    Post subject: Re: display columns alphabetically [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Perfect, thanks for easing my frustration!

"NBVC" wrote:

>
> Go to Tools|Options and then in the General tab, uncheck R1C1 reference
> style.
>
>
> --
> NBVC
>
> Where there is a will there are many ways.
>
> 'The Code Cage' (http://www.thecodecage.com)
> ------------------------------------------------------------------------
> NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
> View this thread: http://www.thecodecage.com/forumz/showthread.php?t=136818
>
>
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> New Users All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum