How To Scroll Lotus Emails Or Excel SpreadSheets Using Keyboard (No Mouse)

Introduction

Has the mouse for your computer suddenly stopped working? You have no back up mouse and you desperately need to scroll in all directions on Lotus or Excel without the use of a mouse.

Yes? Go to Step 1 below and keep reading

No? Keep reading.....

Maybe you are burned out of the mouse when using Excel spreadsheets or Lotus email? You can't stand one more moment with your hand on the mouse and you simply want to scroll the computer screen using just the keyboard arrows?

Yes? Go to the first step below

No? Ok.... keep reading anyway.... I'd appreciate your time if read my post. I need all the help I can get :-) This article will have you scrolling simply by using keystrokes. No mouse or scroll bars required. Even if you have absolutely no need to learn this trick right now, you never know, it cold come in handy if you if disaster strikes and you have no way of moving that cursor around on your PC computer screen. C'mon... keep reading... please ....

Step 1

Look at your PC computer keyboard. There is a light on they keyboard that has an arrow above it. The arrow pointing down, points right to a line running perpendicular to the arrow. All this should be located in the upper right corner just above the number pad. If you don't normally do any scrolling using your keys, this light is likely not lit (off).

Step 2

Find a short row of three buttons just to the upper left of the number pad.   There is a "Scroll Lock" button right in between the "Print Scrn" and "Pause" button.  Go ahead and press the "Scroll Lock" button.   The light will go on

Step 3

Once this light is on you can pan your favorite spreadsheet, email, address book, etc left or right or scroll up or down using the up, arrows on your keyboard.

You'll notice, for example, on an Excel spreadsheet, keeping the "Scroll Lock" button off allows you to move one cell at a time with the arrows. Activating the "Scroll Lock" allows you to pan or scroll the whole spreadsheet irrespective of which cell you are in.

Same thing with Lotus Notes.  With it 'off' your arrows will allow you to move letter by letter or line by line throughout an email. "On" you can pan or scroll the entire email regardless of which letter or sentence your cursor is on.

Keep Reading Fun Poll and Great Lotus Link and More Below

So Lotus eight and one half was recently updated at work and I noticed that I struggled to find the spell checker. I finally figured out where the little bugger was .... check out this post in case you move to this version or have struggled yourself with Lotus 8.5

Locating The spell check on Lotus 8.5

After checking out that link, keep reading below. As I mentioned there is a quick and fun poll to take, as well as information about getting a new mouse and other great computer / PC troubleshooting, tips, and advice to help keep your day running smoothly.

Broken Mouse Poll

So How Did Your Mouse Break Anyway

See results without voting

How to Add Commas To Numbers on Excel

OK, you are working on your Excel worksheet and you are plugging in a ton of numbers. The longer the number gets, the harder it is to read at first glance right? Especially when you are looking at a bunch of numbers on a spreadsheet / worksheet.... geez, they can really add up.

To make more sense of the numbers you can add commas so that, for example 100000 now looks like 100,000 (with the comma inserted to divide the number into parts of one thousand).

You could manually enter the commas but why not just have Excel do it for you. Here is another post I wrote that will show you how to add these automatically on Excel.

Excel Put Commas In Numbers For You

That post should help.... .keep reading for more great posts that should help keep you and your PC running....

More by this Author


Comments 4 comments

chaz 4 years ago

The receiver for my wireless mouse broke a couple weeks ago. Ever since then, I've been using the keyboard almost exclusively. My biggest gripe? Excel is the only programme that makes use of the Scroll Lock function--but I don't use Excel. Scrolling the screen up and down only one line at a time in Microsoft Word is not possible unless you use the MouseKeys accessibility option in Windows that makes use of the numeric keypad to move the cursor around. I can use PageUp/Down, but what if I don't want to move the screen a whole page at a time? Generally, I just need to see a few pages up. Not possible.

Does anybody know of any way of enabling the Scroll Lock key to work in any programme? I think it might be possible, but I'm not a programmer so I don't know.


TurtleDog profile image

TurtleDog 4 years ago Author

Hey! That is a great question and tough to answer. I suspect that there isn't a solution though for me the only way I've ever done it is to either use the computer keyboard's up and down arrows to allow the cursor to move one line at a time or press the "num lock" button on the keyboard then use the arrows on the numeric keypads 2 (down), 6 (left), 8 (up) and 4 (left). This is probably just a work-around to the solution you are trying to solve but it is the most efficient thing I can think of regardless.

Another thought too.... you mention that your mouse receiver has been broken for weeks. You could get one pretty cheap I've seen Logitec mouse with built in nano receivers on Staples on line for under $20 and corded (USB connected) mouse for under $10 on amazon. You could probably find the usb corded one for like 5 or 6 bucks.

Of course, that's easy for me to say. I'm not sure what country you are in or what kind of accessbility you have to this equipment. I had someone from Bermuda once (who I, of course foolishly assumed was living in the states ;) tell me that even the simplest things like batteries cost a fortune after shipping etc.

Anyway! Good luck.


mamb786 profile image

mamb786 4 years ago from Paba Natun Para, Sapura, Rajshahi, Bangladesh

Very helpful article. Thank you for sharing.


TurtleDog profile image

TurtleDog 4 years ago Author

Thanks Mab786 and thank you for the fan mail! Appreciate it

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working