Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tim Tim is offline
external usenet poster
 
Posts: 408
Default Enter Key + Dragging Cells / Moving Cells

Hey guys,

just wondering if you can help me with this.
the TAB key moves cells selector right, and the enter key moves cell
selector DOWN....but the enter key isn't moving it down, it just stays. how
can i fix this?

and

when ive selected a series, or one cell, or whatever.
the icon doesnt change at all.
how do i fix this??


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default Enter Key + Dragging Cells / Moving Cells

Tim,

Q1. Tools|Option|Edit tab
Ensure 'Move selection after edit' is checked and select the direction to
move from the dropdown.

Q2. Which Icon?

Mike

"Tim" wrote:

Hey guys,

just wondering if you can help me with this.
the TAB key moves cells selector right, and the enter key moves cell
selector DOWN....but the enter key isn't moving it down, it just stays. how
can i fix this?

and

when ive selected a series, or one cell, or whatever.
the icon doesnt change at all.
how do i fix this??


  #3   Report Post  
Posted to microsoft.public.excel.misc
Tim Tim is offline
external usenet poster
 
Posts: 408
Default Enter Key + Dragging Cells / Moving Cells

Mike
your a gem mate.

ive got office 2007...so it wasnt there.
however, it got me looking in the right place.

the answer to my 2nd question was right next to the first one in the window

for those needing an answer to this:
ribbon button (top left)excel optionsadvanced"after pressing enter, move
selection" (choose down)

then below it:
"enable fill handle and cell drag-and-drop"
winner
thank you again!!

"Mike H" wrote:

Tim,

Q1. Tools|Option|Edit tab
Ensure 'Move selection after edit' is checked and select the direction to
move from the dropdown.

Q2. Which Icon?

Mike

"Tim" wrote:

Hey guys,

just wondering if you can help me with this.
the TAB key moves cells selector right, and the enter key moves cell
selector DOWN....but the enter key isn't moving it down, it just stays. how
can i fix this?

and

when ive selected a series, or one cell, or whatever.
the icon doesnt change at all.
how do i fix 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
Dragging cells Tommy Excel Discussion (Misc queries) 1 September 10th 08 11:27 PM
Moving between cells when enter is pressed woalmoore Excel Discussion (Misc queries) 3 July 18th 08 04:24 PM
Arrow Keys Moving Window Frame instead of Moving Between Cells nemmex Excel Discussion (Misc queries) 2 April 9th 07 09:08 AM
Odd behaviour in dragging data across and up and down cells Isaac The Arian Excel Discussion (Misc queries) 0 July 4th 06 02:34 AM
Copy and dragging cells Alex Jacinto Excel Worksheet Functions 1 November 10th 04 09:19 PM


All times are GMT +1. The time now is 09:26 PM.

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

About Us

"It's about Microsoft Excel"