LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 903
Default jump around a spreadsheet

Hi Joel,
My guess is that you are not looking for hyperlinks
or going to a named cell/range. If you want to go to
a specific cell you can type in the address into the name
box Gord mentioned, the defined name is further refinement.

My guess is something more along the lines of jumping
from one column to another. See
Worksheet_SelectionChange (#ws_sc)
http://www.mvps.org/dmcritchie/excel/event.htm#ws_sc

Another way would be to protect cells so that one cannot
enter data into them, but that keeps you from inserting and
deleting.

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
You can give a cell or range a defined name and jump to that using F5 and
click
on the name.

Set up a bunch of these names to select from.

InsertNameDefine will get you started.


Gord Dibben MS Excel MVP


On Fri, 24 Aug 2007 16:50:00 -0700, Joel
wrote:

Hi I was wondering if there was a way of placing anchors on a spreadsheet
so
i could jump from certain points. thank you

Joel



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
my row numbers jump from 93 to 279. Why? Clare Setting up and Configuration of Excel 3 April 2nd 23 08:08 PM
Jump certain columns with tab Eric Excel Discussion (Misc queries) 4 July 2nd 07 01:50 AM
How to jump to end of text only? Joe Bloggs Excel Discussion (Misc queries) 3 August 12th 06 08:32 PM
HOW TO JUMP TO THE LAST CELL IN A ROW? Mark Excel Discussion (Misc queries) 3 October 10th 05 03:40 PM
When entering data into excel spreadsheet cell, the page just jump jodj Excel Discussion (Misc queries) 1 March 1st 05 05:51 PM


All times are GMT +1. The time now is 09:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"