Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-06-2016, 05:11 AM
Daniel Arbeit Daniel Arbeit is offline Navigation Strg+Arrowkeys Windows 7 64bit Navigation Strg+Arrowkeys Office 2010 64bit
Novice
Navigation Strg+Arrowkeys
 
Join Date: Jun 2016
Posts: 5
Daniel Arbeit is on a distinguished road
Default Navigation Strg+Arrowkeys

Hello,



with Strg+Arrowkey you can jump to the start or the end where data is in cells.

When you insert a Formular this doesn't work anymore - so i thought it's the Formular and tried to kopy the whole column and inserted it with only values (now there is no Formular in the cells -> like it was written manually). Suprisengly it still did not work.

Maybe you have a hint.



Thanks,
Daniel
Reply With Quote
  #2  
Old 06-06-2016, 09:02 PM
BobBridges's Avatar
BobBridges BobBridges is offline Navigation Strg+Arrowkeys Windows 7 64bit Navigation Strg+Arrowkeys Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

"Strg" must be short for something in German, Daniel. It sounds like you're describing what happens with <Alt-End,<arrow>>; if the active cell contains data, it moves in the direction of the arrow until it comes to an empty cell, and vice versa.

If that's what you're talking about, you'll have to tell more than "doesn't work". What does it do...exactly?
Reply With Quote
  #3  
Old 06-06-2016, 10:58 PM
Daniel Arbeit Daniel Arbeit is offline Navigation Strg+Arrowkeys Windows 7 64bit Navigation Strg+Arrowkeys Office 2010 64bit
Novice
Navigation Strg+Arrowkeys
 
Join Date: Jun 2016
Posts: 5
Daniel Arbeit is on a distinguished road
Default

Sorry "Strg" means "Ctrl".
E.g.:

The cell A1 is selected i press Ctrl+Arrowkeydown and it jumps to A2 (the last cell where there is still data without interrupt by empty cells). Next Ctrl+Arrowkeydown it jumps to A4 (begin of data) then A6 (end of data).

In the colomn C and D this doesn't work. It jumps from C1/D1 to C9/D9 without stopping at the data inbetween (it should stop at C4/D4).

From Microsoft:
"CTRL+ARROW KEY moves to the edge of the current data region in a worksheet."
https://support.office.com/en-us/art...9-9b7213f0040f
Reply With Quote
  #4  
Old 06-07-2016, 01:06 AM
xor xor is offline Navigation Strg+Arrowkeys Windows 10 Navigation Strg+Arrowkeys Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

From the picture in your original post I read it as you have formulas in C2:C9. If that is correct Excel doesn't stop before C9 because there are no real empty cells between C2 and C9.
Reply With Quote
  #5  
Old 06-07-2016, 01:41 AM
Daniel Arbeit Daniel Arbeit is offline Navigation Strg+Arrowkeys Windows 7 64bit Navigation Strg+Arrowkeys Office 2010 64bit
Novice
Navigation Strg+Arrowkeys
 
Join Date: Jun 2016
Posts: 5
Daniel Arbeit is on a distinguished road
Default

Xor thank's for the hint, got it now. The cells are not truely empty and there is no way to do this by a formular.

You can do it by VBA however:

Sub Empty_Cells()
Dim SomeRange As Range
Set SomeRange = Range("D29") 'COMMENT this means D2 : D9 without spaces, forum makes the smiley xD
For Each Cell In SomeRange
If (Cell.Value = "") Then Cell.ClearContents
Next
End Sub
Reply With Quote
  #6  
Old 06-07-2016, 02:42 AM
xor xor is offline Navigation Strg+Arrowkeys Windows 10 Navigation Strg+Arrowkeys Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Not by formula. If you have your formula in C9 and copy and paste as values in D9 then try in an empty cell to enter =ISBLANK(D9)

You may be able to do what you want by means of VBA.
Reply With Quote
  #7  
Old 06-07-2016, 03:13 AM
Daniel Arbeit Daniel Arbeit is offline Navigation Strg+Arrowkeys Windows 7 64bit Navigation Strg+Arrowkeys Office 2010 64bit
Novice
Navigation Strg+Arrowkeys
 
Join Date: Jun 2016
Posts: 5
Daniel Arbeit is on a distinguished road
Default

Yes you are right ISBLANK Returns false meaning it's not truely blank/empty for Excel. This only seems to work by Object.ClearContents by VBA.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Navigation pane BeverlyB Word 1 09-29-2014 12:10 PM
Navigation pane BeverlyB Word 2 09-18-2014 12:01 PM
Navigation Strg+Arrowkeys Navigation Pane windseaker Word 2 04-25-2014 10:34 AM
Navigation Pane savo Word 2 04-17-2013 07:14 AM
Navigation Strg+Arrowkeys too much Navigation eNGiNe Word 5 02-06-2012 12:58 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:02 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft