Related Posts
Additional Posts in Excel Genius
Best pdf to excel converter?
What's the F4 analogy in Office 365?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
Best pdf to excel converter?
What's the F4 analogy in Office 365?
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Download the Fishbowl app to unlock all discussions on Fishbowl.
Copy and paste embed code on your site
Send download link to your phone
OR
Scan your QR code to download
Fishbowl app on your mobile
control g. type in the cell. for example, AH1
yea, i prefer control G. more intuitive. G means "Go To"
Ctrl home will also get you to the top left corner of the sheet (and control end for the bottom right of the active sheet)
If all columns in the sheet happen to have blanks in the same rows, you could also simply delete these rows using find -> go to special -> blanks.
Ctrl A then Ctrl . Will get the 4 corners as well
Ctrl + Fn (function key) + left arrow jumps to top left cell, Ctrl + Fn (function key) + right arrow jumps to bottom right cell
Never cared to look for a solution, so would be great if there is one. Page up/page down can cover a lot of ground efficiently in those cases. Can also insert blank column, ctrl up, arrow one over, and ctrl down.
I put an x at the top and bottom in the column to the right and then drag down, if you're looking to drag a formula.
And by drag down I mean highlight the two cells at the top and then Ctrl down once to get to the end
Press the right arrow to move to column with either data in every cell or all blanks... then press ctrl up