| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
skipping cells
You can give the range a name and ENTER your way through the cells in the order
you wish. See Bob Phillips's site for methods of naming a range. http://www.xldynamic.com/source/xld.xlFAQ0008.html Don't be put off by the title "Tab to selected cells". There is a method of using the ENTER key. Gord Dibben MS Excel MVP On Tue, 27 Jun 2006 10:03:56 -0500, just1creation wrote: i would like a certain cell not recognized even if i click on that cell. i don't want anything in that cell, just to be blank. say i was on A1 and when i press enter i would like to skip to A3... Gord Dibben MS Excel MVP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
| Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
| Help adding text values | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
| Skipping Blank Or Null Cells In a Lookup Function | Excel Worksheet Functions | |||
Threaded Mode
