You all probably recognise this problem:
You have selected a large area of cells and want to make sure you have included everything you wanted to select. Of course you can do the tedious chore of pulling the scrollbar with your mouse to find the other corners of your selection. Or you might hit the tab key to move through the selected cells.
But there is a much simpler way which enables you to quickly step through the corners of the selection. Just hit control+. (control+period) repeatedly.
Regards,
Jan Karel Pieterse
www.jkp-ads.com
Home of the Name Manager
Cool! Did you know Ctrl; and Ctrl: ?
Ctrl; enters today’s date in a selected cell
Ctrl: enters the time in a selected cell
(both give just the value; no formulas)
Yes, I use those very frequently.
I’m a keyboard kind of guy, if I can avoid the mouse I will.
To clear all from cells in a selection: Alt+E A A.
Ctrl + . – that’s gold!
Using Excel 2000 Premium Ctr + . doesn’t do anything.
Works for me, in every version (incl. 2000 Premium):
Ctrl+Period cycles active cell among the corners of the highlighted range.
Works for the period on the main keyboard and for the dot on the numeric keypad.
– Jon
Aha! Amazing reappearing secret words! “you have selected”; “your selection”; “selected cells”. Thanks Jon for giving me the key that eventually broke the ‘code’: “Highlighted Range” – it’s all very clear to me know. :rolleyes: :embarassed: