keystroke shortcut needed

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

Could anyone tell me what is the shortcut to select the used up cells in a
column?
 
hi
not sure what you're after but i dont' think that there is a keyboard short
cut to do this.
look here
http://office.microsoft.com/en-us/excel/HP100738481033.aspx

but to try to answer your question.....
select the column.
hit F5 (goto)
on the goto dialog, click special button (lower left)
select column differences.
ok out.
may or may not be what you're after. if not....experiment with goto.
lot of neat select stuff there. one might fit your needs. or get close.

regards
FSt1
 
CTRL+SHIFT+*
Selects the current region around the active cell (the data area enclosed by
blank rows and blank columns).

CTRL+SHIFT+DownArrow
Selects the cells in the same column with data
 
Jacob, It works perfectly. Anyway FSt1's answer is a work around if I did not
get Jacob's post. Thanks everyone
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Keyboard shortcut to select a column? 7
autocorrect question 1
Type a symbol useing shortcut keys rather the insert a symbol 2
My Word shortcut keys for Windings won't work in Excel 5
Shortcut Keystroke for the AutoSum button or Sum function? 2
Windows 10 How to create individual shortcut for each user 1
2007 View Code ThisWorkbook 2
Shortcut key minimize/maximize 1

Back
Top