ExcelBanter - How can my cursor move to an input cell without going to formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can my cursor move to an input cell without going to formulas (https://www.excelbanter.com/excel-worksheet-functions/264214-how-can-my-cursor-move-input-cell-without-going-formulas.html)

Michel

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

Gord Dibben

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

All times are GMT +1. The time now is 02:50 AM.