Previous in Forum: What are Some Great Practical Applications for this Project?   Next in Forum: Parts Detection in High Temperatures
Close
Close
Close
6 comments
Power-User
Engineering Fields - Biomedical Engineering - New Member Fans of Old Computers - TRS-80 - New Member

Join Date: Aug 2009
Location: Omaha, Nebraska (fly-over country USA)
Posts: 392
Good Answers: 7

Simple (?) Excel 2016 Question

02/18/2019 9:27 PM

Seems like I did this once before - don't know what keys I held or how I got out of it before.....

Generally when I've used the spreadsheet the right/left arrow keys stepped me from one cell to another. Now it moves the entire spreadsheet right/left with the cursor in the same cell.

I can't find a setting, or even know what to call it to look it up!! Stopping, restarting the program does not help. Not sure what I switched on......

__________________
The most exciting phrase to hear in science, the one that heralds new discoveries, is not "Eureka" but rather "Hmmmmm...that's funny" - Isaac Asimov 1920-1992
Register to Reply
Pathfinder Tags: Excel
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

Comments rated to be Good Answers:

These comments received enough positive ratings to make them "good answers".
3
Associate

Join Date: Jul 2011
Posts: 45
Good Answers: 15
#1

Re: Simple (?) Excel2016 Question

02/18/2019 9:53 PM

Google "excel use arrow keys to shift spreadsheet" and read about Scroll Lock.

Hope this helps.

Register to Reply Good Answer (Score 3)
Power-User
Engineering Fields - Biomedical Engineering - New Member Fans of Old Computers - TRS-80 - New Member

Join Date: Aug 2009
Location: Omaha, Nebraska (fly-over country USA)
Posts: 392
Good Answers: 7
#2
In reply to #1

Re: Simple (?) Excel2016 Question

02/18/2019 10:06 PM

PERFECT!!!!

Still not sure HOW I enabled this??? I never use that 'on-screen keyboard'

I think if you hold something down for too long whilst thinking of your next step???

Turning off scroll lock without the keyboard key

Windows 10 users

  1. Press the Windows key.
  2. Type on-screen keyboard and press Enter.
  3. When the on-screen keyboard appears, click the ScrLk button
__________________
The most exciting phrase to hear in science, the one that heralds new discoveries, is not "Eureka" but rather "Hmmmmm...that's funny" - Isaac Asimov 1920-1992
Register to Reply
Guru
Hobbies - DIY Welding - Wannabeabettawelda

Join Date: May 2007
Location: Annapolis, Maryland
Posts: 7424
Good Answers: 430
#3
In reply to #2

Re: Simple (?) Excel2016 Question

02/18/2019 10:54 PM

Yes . . . . <sigh> Microsoft works in mysterious ways.

Register to Reply
Power-User

Join Date: Oct 2012
Location: Wherever my motorcycle has taken me!
Posts: 384
Good Answers: 24
#4
In reply to #3

Re: Simple (?) Excel2016 Question

02/20/2019 5:30 AM

Yes they do, they've totally destroyed the Microsoft Solitaire Collection with a recent update.

__________________
Common sense is an oxymoron and the world is full of morons. (I am not one of them)!!!
Register to Reply
Guru
Engineering Fields - Civil Engineering - Member

Join Date: Mar 2011
Location: ''but, don't we get PAID to ask questions?...''
Posts: 1661
Good Answers: 17
#5
In reply to #2

Re: Simple (?) Excel2016 Question

02/20/2019 11:47 AM

On my keyboard, the Scroll Lock key is directly above the Home key, so it could be an easy mistake to make on a similar keyboard...

So, mind your meandering digits, in any case...

__________________
''illigitimi non carborundum...''(i.e.: don't let the fatherless (self-deluding,sabotaging, long-term-memory-impaired, knee-jerking, cheap-shotting, mono-syllabic, self-annointed, shadow-lurking, back-biting, off-topic-inquisitors) grind you down...)
Register to Reply
Power-User
Engineering Fields - Biomedical Engineering - New Member Fans of Old Computers - TRS-80 - New Member

Join Date: Aug 2009
Location: Omaha, Nebraska (fly-over country USA)
Posts: 392
Good Answers: 7
#6
In reply to #1

Re: Simple (?) Excel2016 Question

02/21/2019 11:22 PM

Nicely done!!!!

And without criticism of Microsoft!!! Thumbs up!!

__________________
The most exciting phrase to hear in science, the one that heralds new discoveries, is not "Eureka" but rather "Hmmmmm...that's funny" - Isaac Asimov 1920-1992
Register to Reply
Register to Reply 6 comments
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

Comments rated to be Good Answers:

These comments received enough positive ratings to make them "good answers".
Copy to Clipboard

Users who posted comments:

avasco73 (1); Brave Sir Robin (1); MR. Guest (1); Sid_Sidow (2); wmerryall (1)

Previous in Forum: What are Some Great Practical Applications for this Project?   Next in Forum: Parts Detection in High Temperatures

Advertisement