ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Default left-to-right columns for imported files (https://www.excelbanter.com/excel-discussion-misc-queries/177716-default-left-right-columns-imported-files.html)

hmm

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?

Tyro[_2_]

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?




hmm

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?






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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com