scrolling in table

L

lydia

i have an extremely large table which is formatted in 6
point arial, legal landscape. i'm doing revisions and
have blown it up to 150% to be able to read it on the
screen. however, this means that scrolling from the end
of cell to the one below moves the cursor the first cell
in the row, necessitating a lot of scrolling. at 150
percent, of course, the column does not fit on the screen
(small monitor, can't be fixed). any suggestions? tia.
 
J

Jezebel

The obvious answer is: don't use this format. If you're having trouble so
much trouble writing it, the end result will be unreadable. Choose a format
that works for the material you're dealing with.

People often insist that they must use a particular format because "it's a
requirement" -- this is almost never true. Even the prickliest of
bureaucrats will accept a readable document in preference to an unreadable
one, whatever the requirements may say.
 
G

Guest

you know that, i know that, but the boss will only work
in word and there's that pesky 1024 limit in excel. so
there you go. nothing i have been able to say or do will
detach the boss and word. and it is unreadable!
 
J

Jezebel

bugger...

Surely there's a compromise. If you're dealing with text, then Word is not a
bad solution: the problem here is trying to use a table for text that
shouldn't be in a table. As David Ogilvie once put it, when all else fails
try half a bottle of good red wine and a long walk. Then take a chunk of
your text and let your imagination run free. There always IS a good solution
there somewhere.
 
L

lydia

thanx though. i'm taking the wine and the walk. it's
been a bad experience all around - why won't people
listen to the people who actually know what they're doing!
 
J

Jezebel

Why? It's the Peter Principle. If you know what you're doing you get
promoted... until you reach a level where you no longer know what you're
doing. Most managers have reached their level of incompetence.
 
K

Klaus Linke

lydia said:
i have an extremely large table which is formatted in 6
point arial, legal landscape. i'm doing revisions and
have blown it up to 150% to be able to read it on the
screen. however, this means that scrolling from the end
of cell to the one below moves the cursor the first cell
in the row, necessitating a lot of scrolling. at 150
percent, of course, the column does not fit on the screen
(small monitor, can't be fixed). any suggestions? tia.
Click to expand...


Hi Lydia,

Maybe you can talk your boss into buying some wheel mice with tilt wheels?
Tilting the wheel left/right scrolls left/right, which might help a bit to
keep your sanity.

You might also try some tricks like coloring the text in the different
columns in different colors, so you can orient yourself quicker.
Some keyboard shortcuts like Alt+Shift+Down, Alt+Shift+Up to select the
current row (if you can't click to the left of the row because it's not on
the screen) might also help.

Regards,
Klaus
 
Top