Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 40
Default finding a cell from numerical coordinates

is it possible to locate a cell from coordinates such as 50, 75 or 100,98?
I'd really like to be able to do this.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,346
Default finding a cell from numerical coordinates

No need to post the question twice so soon.

In 2007 press Alt+1, Formulas tab and check R1C1 reference style

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Chip" wrote:

is it possible to locate a cell from coordinates such as 50, 75 or 100,98?
I'd really like to be able to do this.

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,346
Default finding a cell from numerical coordinates

Hi,

In 2007 press Alt+1, Formulas tab and check R1C1 reference style

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Chip" wrote:

is it possible to locate a cell from coordinates such as 50, 75 or 100,98?
I'd really like to be able to do this.

  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 40
Default finding a cell from numerical coordinates



"Shane Devenshire" wrote:

No need to post the question twice so soon.


That was a mistake, the page apparently locked up, the hourglass curser
wouldn't stop, I closed the window, and didn't see the message posted, so did
so a second time. then there is no way to delete a post.


In 2007 press Alt+1, Formulas tab and check R1C1 reference style

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Chip" wrote:

is it possible to locate a cell from coordinates such as 50, 75 or 100,98?
I'd really like to be able to do this.

  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 15,768
Default finding a cell from numerical coordinates

No need to post the question twice so soon.

No need to post the same reply twice so soon.

--
Biff
Microsoft Excel MVP


"Shane Devenshire" wrote in
message ...
No need to post the question twice so soon.

In 2007 press Alt+1, Formulas tab and check R1C1 reference style

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Chip" wrote:

is it possible to locate a cell from coordinates such as 50, 75 or
100,98?
I'd really like to be able to do this.





  #6   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,346
Default finding a cell from numerical coordinates

Glad this helped, thank for the feedback.

We never know if the user has gotten nerveous because they haven't seen a
response in 10 seconds or if there is some problem with the site.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Shane Devenshire" wrote:

Hi,

In 2007 press Alt+1, Formulas tab and check R1C1 reference style

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Chip" wrote:

is it possible to locate a cell from coordinates such as 50, 75 or 100,98?
I'd really like to be able to do this.

Reply
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
How do I get the coordinates of the active cell in Excel? Jim Stuart Excel Discussion (Misc queries) 9 April 3rd 23 01:25 PM
finding a cell from numerical coordinates Chip New Users to Excel 3 July 8th 09 10:14 PM
Finding a numerical value within a cell Cecilia Excel Worksheet Functions 5 December 4th 07 11:58 PM
Conditional Formatting; finding numerical data in mixed text. Philonis Excel Discussion (Misc queries) 2 June 5th 07 11:57 PM
finding the coordinates of the maximum point on a graph eastham85 Charts and Charting in Excel 2 January 16th 05 01:34 PM


All times are GMT +1. The time now is 08:17 AM.

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

About Us

"It's about Microsoft Excel"