ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

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

Updated on May 1, 2013

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

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

Comments

    0 of 8192 characters used
    Post Comment

    • TurtleDog profile imageAUTHOR

      TurtleDog 

      5 years ago

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

    • mamb786 profile image

      Md Abdul Muneem Billah 

      5 years ago from Paba Natun Para, Sapura, Rajshahi, Bangladesh

      Very helpful article. Thank you for sharing.

    • TurtleDog profile imageAUTHOR

      TurtleDog 

      6 years ago

      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.

    • profile image

      chaz 

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

    working

    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://hubpages.com/privacy-policy#gdpr

    Show Details
    Necessary
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
    Features
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Marketing
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Statistics
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)