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

Comments Format:






Change Mode
Close

Subscribe to Discussion:

CR4 allows you to "subscribe" to a discussion
so that you can be notified of new comments to
the discussion via email.

Close

Rating Vote:







Add Vote
6 comments
Rate this Comments: Nested
Sid_Sidow
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
avasco73
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)
No more Good Answers.
Sid_Sidow
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
Brave Sir Robin
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
wmerryall
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
MR. Guest
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
Sid_Sidow
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

Got Something to Say?
Ask a Question
Start a Discussion

Search this Forum
General Discussion:
Go

CR4 Sections
Aerospace
BioMech & BioMed
Chemical & Material Science
Civil Engineering
Communications & Electronics
Education and Engineering Careers
Electrical Engineering
General
Instrumentation
Manufacturing
Mechanical Engineering
New Technologies & Research
Software & Programming
Sustainable Engineering
Transportation

Site Directories
Forum Directory
Blog Directory
User Group Directory
RSS Feeds

CR4 Rules of Conduct
CR4 FAQ
Site Glossary

Who's Online (42 right now)
Show Members
Advertisement