Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
hmm hmm is offline
external usenet poster
 
Posts: 175
Default Default left-to-right columns for imported files

When I open a CSV or TXT file in Excel 2007, the columns are arranged from
right-to-left. Every time I open a different file, I have to press the Page
Layout -- Sheet Options -- Sheet Right-to-Left button, in order to toggle
off this option.

How can I make left-to-right the default for such imported files?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,091
Default Default left-to-right columns for imported files

I use Excel 2007. It opens csv and txt from left to right. Page Layout has
to do with printing files, not importing them. As a matter of fact, I don't
see a Sheet Right-to-Left button in the Sheet Options Dialog. Perhaps you
could expand.

Tyro

"hmm" wrote in message
...
When I open a CSV or TXT file in Excel 2007, the columns are arranged from
right-to-left. Every time I open a different file, I have to press the
Page
Layout -- Sheet Options -- Sheet Right-to-Left button, in order to
toggle
off this option.

How can I make left-to-right the default for such imported files?



  #3   Report Post  
Posted to microsoft.public.excel.misc
hmm hmm is offline
external usenet poster
 
Posts: 175
Default Default left-to-right columns for imported files

In Excel 2007, the Page Layout tab has several panels. One of them is Sheet
Options. One item in this panel (at least in Office with right-to-left
language support, such as I have) is a toggle button called Sheet
Right-to-Left. This button controls the direction in which columns appear on
on the screen (not only in the print layout).

Every time I open a CSV (or TXT) file, column A is to the extreme right. I
must press the Sheet Right-to-Left button to deactivate this option. My
question is how can I make Excel default to left-to-right, so I do not have
to press the button each time.

Thanks.

Thanks.

"Tyro" wrote:

I use Excel 2007. It opens csv and txt from left to right. Page Layout has
to do with printing files, not importing them. As a matter of fact, I don't
see a Sheet Right-to-Left button in the Sheet Options Dialog. Perhaps you
could expand.

Tyro

"hmm" wrote in message
...
When I open a CSV or TXT file in Excel 2007, the columns are arranged from
right-to-left. Every time I open a different file, I have to press the
Page
Layout -- Sheet Options -- Sheet Right-to-Left button, in order to
toggle
off this option.

How can I make left-to-right the default for such imported files?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change default Open/Files of Type to "Microsoft Excel Files Tammy Excel Discussion (Misc queries) 2 January 14th 08 11:06 PM
Accessing imported Excel files after Office 2003 SP3 upgrade kmitch Excel Discussion (Misc queries) 0 November 9th 07 01:13 PM
imported data isn't in columns Brendan Excel Discussion (Misc queries) 2 January 25th 07 01:27 PM
Excel - change default 'next worksheet' shortcut key to left hnd s KiwiCarol Setting up and Configuration of Excel 3 October 2nd 06 09:32 PM
My columns run from right to left instead of left to right. Help? Marleneburton Setting up and Configuration of Excel 1 March 21st 06 08:31 AM


All times are GMT +1. The time now is 04:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"