Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 21
Default How can my cursor move to an input cell without going to formulas

I have a workbook with working figures. I would prefer to have my cursor move
automatically to input cells by ignoring the cell where I have formulas. How
can I do it. Thks for your help
--
Michel

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default How can my cursor move to an input cell without going to formulas

Unlock all cells.

Lock the formula cells.

Protect the worksheet.

Use Tab key to move to unlocked cells.


Gord Dibben MS Excel MVP

On Thu, 20 May 2010 09:26:01 -0700, Michel
wrote:

I have a workbook with working figures. I would prefer to have my cursor move
automatically to input cells by ignoring the cell where I have formulas. How
can I do it. Thks for your help


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
macro to move cursor one cell right Kodak1993 New Users to Excel 3 September 23rd 08 02:00 AM
Automatically move cursor when cell value changes scotty New Users to Excel 3 January 23rd 07 12:03 AM
Automatically move cursor when cell value changes Gary''''s Student New Users to Excel 0 January 19th 07 08:20 PM
HOW CAN I GET MY CURSOR TO MOVE TO NEXT CELL BY PRESSING TAB Melissa Jordan Excel Discussion (Misc queries) 3 November 27th 06 11:55 PM
How do I get tab to move the cursor one cell over rather than 8? Mysti4God Excel Worksheet Functions 2 August 11th 06 07:04 PM


All times are GMT +1. The time now is 07:47 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"