Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How tell what cell you're in?

0 views
Skip to first unread message

Rick Charnes

unread,
Nov 19, 1998, 3:00:00 AM11/19/98
to
This WordPerfect expatriate can't figure out how to tell in Word97 what
cell you're in when you're in a table. I'm looking for a reference to 'A8'
or E4' or whatever somewhere in the status line, and I don't see it. Can
someone help? Thanks.


Suzanne S. Barnhill

unread,
Nov 19, 1998, 3:00:00 AM11/19/98
to
There is a TableCellHelper macro in the macros8.dot (normally located in
c:\program files\microsoft office\office\macros or on your Word/Office CD if
it didn't get installed) that I am told will provide this information. Still
not as functional as WP or Excel, however.

--
Suzanne S. Barnhill
Words into Type
sbar...@zebra.net

Get free answers to your software questions via email at
http://www.allexperts.com

Rick Charnes

unread,
Nov 20, 1998, 3:00:00 AM11/20/98
to
So without some macro you basically have to count cells from the top and
left simply to find out what cell you're in? Incredible. What is it that
for everything in life that's so advanced and superior and feature-ful if
you pick up the rock you find all the worms crawling out?

Eeewwwww...

Suzanne S. Barnhill <sbar...@zebra.net> wrote in article
<ePllW2AF#GA....@uppssnewspub05.moswest.msn.net>...

Scott Matthewman

unread,
Nov 20, 1998, 3:00:00 AM11/20/98
to
Rick Charnes <rick.c...@state.ma.us> wrote in message
news:01be148f$58d3b1a0$3166f392@mis04...

>So without some macro you basically have to count cells from the top and
>left simply to find out what cell you're in? Incredible. What is it that
>for everything in life that's so advanced and superior and feature-ful if
>you pick up the rock you find all the worms crawling out?

Not that I'm trying to defend Microsoft or anything, but... ;-)

Like you, I moved from WP to Word and, yes, tables are the major difference.
Word's approach to tables is by and large a lot more flexible than the model
WP uses; cell widths, column widths and even table widths can vary from row
to row. So to a certain extent, row and column "numbers" in those situations
don't always mean what you might think they mean.

Plus, when you merge cells in a Word table, you'll find that it can throw
out the numbering scheme in an annoying, if completely logical, manner. One
of the document templates that we're developing at the moment has a large
table on page 1 that covers the whole page with lots of merged cells in
order to replicate the layout of the original QuarkXPress document. When it
came to writing a VBA routine that pulls data form an ASCII text file and
puts it into the correct locations, working out the best way to navigate
round was hellish - but the extra flexibility was worth it.

As an example, say you want a table that looks like this:

+--------+-----------------+
| | |
+--------+--------+--------+
| | |
+------------------+-------+

With WP you'd have to set up three columns, then merge the appropriate
columns. With Word, you can start with two columns and drag the cell
boundaries (or use the pencil). This is a simplistic example, but when you
get to an m-by-n sized table, Word's flexibility does help.

On the other hand, most of the time we all use tables in the 'conventional'
manner, with all cells in each column exactly the same width, and maybe one
or two merged ones. In those cases, Word's flexibility can be
counter-productive, although Word97 seems much better than its predecessors
in this respect.

Just my 2p-worth,

Scott

Suzanne S. Barnhill

unread,
Nov 20, 1998, 3:00:00 AM11/20/98
to
Also sort of in defense of Microsoft, you have to realize that Word has from
the outset been envisioned as part of an office suite, and the sort of
operations for which you usually need to use cell references are what Excel
is designed for. If you could do them in Word, you wouldn't need Excel, so
it was not in Microsoft's best interests to add them. WordPerfect, on the
other hand, since it originated as a standalone program, has attempted to
retain market share by adding a lot of spreadsheet functionality to a word
processing application and therefore is ahead of Word not only in cell
references but also in calculations in tables, etc.

John Land

unread,
Nov 20, 1998, 3:00:00 AM11/20/98
to
Then the least that MS could have done is provide a sequential ID number for
cells, with the readout in the status bar, don't you think?

John Land, Esq.


Terry Farrell

unread,
Nov 21, 1998, 3:00:00 AM11/21/98
to
John,

Nope. Excel is so vastly superior that I'd rather use it for any task that
requires any form of spreadsheet type function.

Terry


John Land <la...@fr.com> wrote in message
news:u1xSQJRF#GA....@uppssnewspub04.moswest.msn.net...

Terry Farrell

unread,
Nov 25, 1998, 3:00:00 AM11/25/98
to
Scott,

well, actually you could vertically align text in a cell... you had to
adjust the Paragraph Formatting, Space Before setting to achieve vertical
centring.. it worked OK in most instances but it was not intuitive!

Terry


Scott Matthewman <sc...@direct-image.co.uk> wrote in message
news:#$GeqIKG#GA....@uppssnewspub04.moswest.msn.net...
>John,
>
>I begrudgingly have to agree with Terry. Word's tables are best thought of
>as a visual aid rather than a calculation tool. Just be thankful you didn't
>migrate form WordPerfect a version or so ago, when you couldn't set
vertical
>alignment in cells!
>
>Scott
>
>Terry Farrell <TerryF...@email.msn.com> wrote in message
>news:O28nDoYF#GA....@uppssnewspub04.moswest.msn.net...

Scott Matthewman

unread,
Nov 25, 1998, 3:00:00 AM11/25/98
to
0 new messages