Excel tip: Help, my columns are displayed backwards

Date: 3 january 2007

Just got a question that migh be interesting to show here about columns that are displayed backwards. The columns are in reverse alphabetical order and start at the upper right hand corner. The row numbers are on the right side of excel instead of the left.
Example sheet, displayed from right to left:

Solution

In fact, this is a (per sheet) setting in Excel.
In the Excel menu choose: Tools » Options
In the options-dialog that shows select the "International" tab and uncheck "View current sheet right-to-left".

« back

	Home Screenshots 10 Languages Why use it? Download Pricing Contact Us

	Download Download ASAP Utilities (recommended) License Agreement (EULA) Upgrade to the latest version Version history Compare version changes Alternative download options System requirements Upgrade once a year (Home&Student ed.) Buy Order your license(s) Payment Methods Pricing and volume discounts Help with the ordering system \| Shopper FAQ Sales, upgrades and Refunds Policy When to buy a license, when is it free? License Agreement (EULA) Example of the ordering process + help What is it? What is ASAP Utilities Screenshots of ASAP Utilities 10 Languages to choose from The primary goals of ASAP Utilities Mission Statement and Company Values About the author of ASAP Utilities System requirements Examples of how to use ASAP Utilities Why use it? Top reasons to use ASAP Utilities Quick Start: Practical Tricks to Save Hours in Excel with ASAP Utilities Features Descriptions of all tools in ASAP Utilities Added worksheet functions Fully expanded list of all menu items A few example screenshots of ASAP Utilities Quick Start: Practical Tricks to Save Hours in Excel with ASAP Utilities Today's featured time saving tool (October 8th) Reviews Testimonials, feedback from users Reviews from the press Clients, who uses ASAP Utilities? User Guide Download the PDF User Guide How to install ASAP Utilities Detailed step by step installation How to uninstall ASAP Utilities Quick Start: Practical Tricks to Save Hours in Excel with ASAP Utilities News Latest news Today's featured time saving tool (October 8th) Reviews from the press RSS Feed Receive our Newsletter Unsubscribe from our Mailing List Tips on our blog Excel tips Excel tips Excel keyboard shortcuts overview Headlines from the best Excel weblogs Links to interesting websites Recommended Excel books Excel version screenshots Support 1. FAQ: Questions and answers 2. Version history 3. Bug report guidelines 4. Sitemap 5. Help with the ordering system \| Shopper FAQ 6. Contact us EN-US Descriptions of all tools in ASAP Utilities: 1. English 2. 中文(简体) (Chinese (Simplified)) 3. Deutsch (German) 4. Español (Spanish) 5. Français (French) 6. Italiano (Italian) 7. 日本語 (Japanese) 8. Nederlands (Dutch) 9. Português do Brasil (Portuguese (Brazil)) 10. Русский (Russian)
	Home Excel tipsHelp, my columns are displayed backwards
	Excel tip: Help, my columns are displayed backwards Date: 3 january 2007 Just got a question that migh be interesting to show here about columns that are displayed backwards. The columns are in reverse alphabetical order and start at the upper right hand corner. The row numbers are on the right side of excel instead of the left. Example sheet, displayed from right to left: Solution In fact, this is a (per sheet) setting in Excel. In the Excel menu choose: Tools » Options In the options-dialog that shows select the "International" tab and uncheck "View current sheet right-to-left". « back
	Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us ©1999-2024 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands Empowering Excel Users Worldwide for 25 Years