Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to change default Open/Files of Type to "Microsoft Excel Files | Excel Discussion (Misc queries) | |||
Accessing imported Excel files after Office 2003 SP3 upgrade | Excel Discussion (Misc queries) | |||
imported data isn't in columns | Excel Discussion (Misc queries) | |||
Excel - change default 'next worksheet' shortcut key to left hnd s | Setting up and Configuration of Excel | |||
My columns run from right to left instead of left to right. Help? | Setting up and Configuration of Excel |