Scrolling shortcuts

%3CLINGO-SUB%20id%3D%22lingo-sub-3249995%22%20slang%3D%22en-US%22%3EScrolling%20shortcuts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3249995%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20constantly%20scrolling%20over%20and%20back%20(ctrl%2Barrow)%20to%20a%20point%20on%20a%20spreadsheet.%20Just%20a%20thought%20(and%20no%20clue%20if%20this%20is%20in%20the%20right%20forum%20or%20place%20just%20needed%20to%20get%20it%20off%20my%20chest)%20but%20wouldn't%20it%20be%20nice%20if%20you%20could%20add%20a%20number%20of%20%22tabs%22%20to%20the%20scroll%20bar%20to%20jump%20to%20a%20designated%20point%2C%20something%20as%20simple%20as%20how%20you%20add%20tabs%20the%20ruler%20in%20MS%20word.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3249995%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3251838%22%20slang%3D%22en-US%22%3ERe%3A%20Scrolling%20shortcuts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3251838%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1326896%22%20target%3D%22_blank%22%3E%40DGolden1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESpreadsheet%2FWorkbook%20design%20can%20be%20tricky%2C%20especially%20when%20you're%20processing%20lots%20of%20data.%20Designing%20for%20easy%20and%20convenient%20navigating%20from%20section%20to%20section%20is%20particularly%20tricky.%20Most%20internet%20documents%20on%20the%20topic%20just%20talk%20about%20keyboard%20shortcuts.%20This%20attached%20is%20one%20I've%20found%20useful%2C%20although%20it's%20more%20about%20the%20integrity%20aspect%20of%20spreadsheet%20design%2C%20but%20a%20part%20of%20that%20is%20how%20all%20of%20the%20parts%20fit%20together%2C%20which%20relates%20to%20getting%20around......%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3251628%22%20slang%3D%22en-US%22%3ERe%3A%20Scrolling%20shortcuts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3251628%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3Byes%20I%20do%20use%20the%20Ctrl%20and%20the%20arrow%20keys%2C%20I%20have%20specific%20columns%20set%20up%20to%20enable%20me%20to%20land%20or%20stop%20at%20a%20designated%20section.%20I%20have%20grouped%20data%20too%2C%20to%20hide%20info%20when%20not%20in%20use%20%2C%20which%20does%20the%20job%20for%20now.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3250562%22%20slang%3D%22en-US%22%3ERe%3A%20Scrolling%20shortcuts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3250562%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1326896%22%20target%3D%22_blank%22%3E%40DGolden1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20checking...are%20you%20aware%20that%20you%20can%20use%20(on%20a%20Mac)%20the%20key%20combination%20of%20Command%20%2B%20Right%20arrow%20to%20jump%20to%20the%20end%20of%20a%20row....Command%20%2B%20Down%20to%20go%20to%20the%20bottom%20of%20a%20column%3F%20I%20think%20on%20a%20Windows%20PC%20the%20comparable%20key%20combo%20is%20something%20like%20Ctrl%20%2B%20arrow....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20find%20those%20keyboard%20shortcuts%20every%20bit%20as%20convenient%20as%20the%20tab%20settings%20in%20Word.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am constantly scrolling over and back (ctrl+arrow) to a point on a spreadsheet. Just a thought (and no clue if this is in the right forum or place just needed to get it off my chest) but wouldn't it be nice if you could add a number of "tabs" to the scroll bar to jump to a designated point, something as simple as how you add tabs the ruler in MS word.

3 Replies

@DGolden1 

 

Just checking...are you aware that you can use (on a Mac) the key combination of Command + Right arrow to jump to the end of a row....Command + Down to go to the bottom of a column? I think on a Windows PC the comparable key combo is something like Ctrl + arrow....

 

I find those keyboard shortcuts every bit as convenient as the tab settings in Word.

@mathetes yes I do use the Ctrl and the arrow keys, I have specific columns set up to enable me to land or stop at a designated section. I have grouped data too, to hide info when not in use , which does the job for now.

@DGolden1 

 

Spreadsheet/Workbook design can be tricky, especially when you're processing lots of data. Designing for easy and convenient navigating from section to section is particularly tricky. Most internet documents on the topic just talk about keyboard shortcuts. This attached is one I've found useful, although it's more about the integrity aspect of spreadsheet design, but a part of that is how all of the parts fit together, which relates to getting around......