Thursday, 22 July 2010

excel go to a particular row


how can make cursor jump row 2378 example instead of having scroll there?

tips.:)
 

use cell or range finder

there white box on left hand side of formula bar (where enter functions , calculations). directly above column a. type cell wish go in box , hit return/enter key. eg type a2378 , hit return. works same named ranges have in sheet. type name of range have named , hit enter , see range highlighted. hope helps.
 


Forums Macs Mac Apps and Mac App Store


  • iPhone
  • Mac OS & System Software
  • iPad
  • Apple Watch
  • Notebooks
  • iTunes
  • Apple ID
  • iCloud
  • Desktop Computers
  • Apple Music
  • Professional Applications
  • iPod
  • iWork
  • Apple TV
  • iLife
  • Wireless

No comments:

Post a Comment