text alignment in cells

[Jim new user]

I have been using Quattro Pro, and am learning Excell now.

I have entered data in four cells in a row vertically
down the same column (i.e. A1, A2, A3, A4). I selected
those four cells, and clicked to have them all right hand
justified. This works like I expected and everything is
OK.

Now, when I enter data in cell A5 or A6, etc., and I
assume it will be left margin justified by default, it
automatically jumps to right hand justify.

I have even looked at the cell horizontal justification
before entering any data, and it tells me it
is "General". But still, when I enter data it right hand
justifies.

How do I stop this?? Is there some setting telling Excel
to assume my justification settings for cells beyond the
block I initially selected?

Help and thanks.

 

[Frank Kabel]

Hi Jim
if you enter numbers (and have a general format applied) the default is
right justified. For text it is left justified

 

[DDM]

Jim, you don't say what version of Excel you're using, but in Excel 2003 you
can turn that behavior off by selecting Tools > Options > Edit; uncheck
Extend data range formats and formulas; OK. Wording on checkbox may be
slightly different in earlier versions.

 

[Guest]

Thanks for the help.

I am using Excel 2000. I found the box you are talking
about (it is "Extend list formats and formulas").

Could you help on another problem?

I need to view two parts of the same sheet at the same
time. Help tells me to put my mouse at the top of the
vertical scroll bar, and point to the split box, then
drag.

When I open a blank (new) spreadsheet, the slpit box is
visible. However, when I open any of my existing
spreadsheets, the scroll bar is visible, and works OK,
but there is no split box. Any ideas?

Thanks again!!
Jim

 

[David McRitchie]

Hi Jim,
Each sheet would have it's own split, if it has a split.

The split box is above the up direction graphic at top of the
vertical scrollbar (or left of the horizontal scrollbar). If there
is no split box then it is probably already
split and you would have to scroll down to find it.
Window (menu), unsplit

You can split either from the split box, or you can choose a cell,
or a row or a column PAST the point that you want to split and
then use Window (menu), split

 

[Ragdyer]

Then of course, there's always the other option, of opening a number of new
windows of the same sheet.

<Window> <NewWindow> (as many times as the number of views desired)
Then,
<Window> <Arrange>
And choose the configuration of your liking.

When you're done, and wish to return to a single window, simply do,
<Ctrl> <W> to close each open window.
--
HTH,

RD

 

[CLR]

I look at multiple Excel spreadsheeta and other files at the same time all
the time.......I got tired of splitting screens, etc..........so at home I
now have two monitors and at work I have three........the multiple monitor
setups are GREAT!!!!..........especially for debugging code........

hth
Vaya con Dios,
Chuck, CABGx3

 

[Gord Dibben]

You won't see the Split Box if the existing sheets have Freeze Panes enabled.

Gord Dibben Excel MVP