The Code Cage - Microsoft Office help Free Microsoft Office Help for all Applications!  

To stop seeing these ads and get other benefits check This page!

Go Back   The Code Cage Forums > Newsgroups - Microsoft Topics > Newsgroup - Excel Forum > Excel New Users
  Chat In Use Now! Microsoft Office Chat Online now!


Excel New Users Post questions in this forum if you are new to using Microsoft Excel and need that little bit more of an explanation etc.

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 21st September 2009, 06:53 PM
Grocer
Newsgroup Contributor


My Top Tip Count:

 
Posts: n/a
Chats:
Default display columns alphabetically

------ Register to get rid of these "In Post" ads! ------


Columns used to display alphabetically left to right. It changed to now
displaying numerically left to right. How do I change back to alphabetically?
Reply to this post


Did you find this post helpful? Yes | No

The Code Cage Advertisment
Advertisement

To stop seeing these ads and get other benefits check This page!
  #2 (permalink)  
Old 21st September 2009, 06:56 PM
NBVC's Avatar
The Code Cage Staff
MS Office Version: MS Office 2003, 2007
MS Office Skill Level: Proficient with Excel


My Top Tip Count: 2

 
Join Date: Dec 2008
Location: Mississauga Canada
Posts: 434
Thanks to others: 10
Thanked 14 Times in 14 Posts
Chats: 235
Rep Power: 7
NBVC has a spectacular aura aboutNBVC has a spectacular aura about
2 Top Tips
Canada
Default Re: display columns alphabetically

------ Register to get rid of these "In Post" ads! ------


Go to Tools|Options and then in the General tab, uncheck R1C1 reference style.
__________________
Where there is a will there are many ways.

The Code Cage
Reply to this post


Did you find this post helpful? Yes | No
  #3 (permalink)  
Old 21st September 2009, 07:11 PM
Grocer
Newsgroup Contributor


My Top Tip Count:

 
Posts: n/a
Chats:
Default Re: display columns alphabetically

------ Register to get rid of these "In Post" ads! ------


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/members/nbvc.html
> View this thread: display columns alphabetically
>
>

Reply to this post


Did you find this post helpful? Yes | No
The Code Cage Advertisment
Advertisement

To stop seeing these ads and get other benefits check This page!
Reply

Bookmarks

Tags
alphabetically, columns, display


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump

The Code Cage Affilliates


To stop seeing these ads and get other benefits check This page!



All times are GMT +1. The time now is 01:03 AM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2
No part of this board may be copied or reproduced either in part or full without the express permission of The Code Cage Team.
We are not associated with nor employed by Microsoft in any way, we simply provide resources!
All MS office icons are registered trademarks of the application the represent