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

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 ....

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).

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

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.

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.

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....