View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
tghcogo
 
Posts: n/a
Default How can i quickly mark a huge range, like A1 to DV3500?


If its the whole document i.e. the start point and the end point, you
can use the keyboard keys

"Control+Home" followed by "Control+Shift+End"


nb Ctrl+Shft+End will take you to the last cell that has data _or_ has
been formatted. So if you have formatted a whole column or
row........................


--
tghcogo
------------------------------------------------------------------------
tghcogo's Profile: http://www.excelforum.com/member.php...o&userid=10494
View this thread: http://www.excelforum.com/showthread...hreadid=491558