| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use Tab to get to next line
I have a spreadsheet that is 4 columns wide, I want to be able to tab to each
cell and when I reach the 4th cell in each row when I push tab I want it to go to the next row Is that possible? I have tried hiding the remaining columns, deleting the remaining columns and had no luck |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use Tab to get to next line
Hi Erika,
Try Tab Tab Tab Enter Tab Tab Tab Enter etc. HTH Martin "Erika" wrote in message ... I have a spreadsheet that is 4 columns wide, I want to be able to tab to each cell and when I reach the 4th cell in each row when I push tab I want it to go to the next row Is that possible? I have tried hiding the remaining columns, deleting the remaining columns and had no luck |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use Tab to get to next line
Alternatively, if you select the range first like A1:D10 then you can Tab is
each cell, across rows first. -- Jim "Erika" wrote in message ... |I have a spreadsheet that is 4 columns wide, I want to be able to tab to each | cell and when I reach the 4th cell in each row when I push tab I want it to | go to the next row | | Is that possible? I have tried hiding the remaining columns, deleting the | remaining columns and had no luck | | |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use Tab to get to next line
Thanks for your help, I did try to explain to the person that I was working
with that the enter key would work however that didn't work for him. I found a way to do it with using locked and unlocked cells and adding sheet protection. "Jim Rech" wrote: Alternatively, if you select the range first like A1:D10 then you can Tab is each cell, across rows first. -- Jim "Erika" wrote in message ... |I have a spreadsheet that is 4 columns wide, I want to be able to tab to each | cell and when I reach the 4th cell in each row when I push tab I want it to | go to the next row | | Is that possible? I have tried hiding the remaining columns, deleting the | remaining columns and had no luck | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change color of line and point markers on a line graph | Charts and Charting in Excel | |||
| Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) | |||
| Vertical scroll bar jumps scrolls line 1 to line 2705? | Excel Worksheet Functions | |||
| A 2 line text showing up in the Cell in Excel prints in 1 line | Excel Discussion (Misc queries) | |||
| coloring overy other line without doing so line by line | Excel Worksheet Functions | |||
Linear Mode
