Hi,
I got a datasheet with 8,000-10,000 rows of data. The previous author insert charts, created from such data. However, he scattered those charts somewhere in the datasheet, not at the end, not at the beginning. Each time I need to see the charts, I have to scroll down massive page, continuously searching for it.
Is there any shortcut key, or menu command where I can quickly spot the chart?
Thanks
(this is not a spam, I repost after s/o complaining when I posted in Tips & Tute).
Last edited by tungle; 03-24-2011 at 11:38 AM. Reason: solved
Use CTRL+G to Goto> Special... > Objects.
In xl2007/2010 you can also use the Selection task pane to see objects on the sheet.
Home > Editing > Find&Select > Selection Pane
tks Andy, quick & helpful reply
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks