Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel cell swap!
#1
I discovered a neat way to switch cells instead cutting, pasting, copying etc..
Select the cell. Hold down SHIFT. Drag the cell to another location. Make sure to see the I beam. Release mouse.

See video:


[Image: 2flIEiT]
Matthew Hains
Passionate about Computer Applications Technology
Reply
#2
Works with full columns as well - Shift to move, Ctrl to copy Smile
Reply
#3
Why did I not know this before? Smile

[Image: 2flIEiT]
Matthew Hains
Passionate about Computer Applications Technology
Reply


Possibly Related Threads...
Thread Author Replies Views Last Post
Question Having a problem with: graphs acting weird in Excel karinheroux 3 614 07-11-2017, 14:27
Last Post: Matthew
  Using a cell reference in criteria in Countif ClaireS 7 880 02-11-2017, 10:05
Last Post: ClaireS
  Need advice on: the function in Excel booysenjonelle@gmail.com 1 430 12-10-2017, 13:06
Last Post: Matthew
  Keyboard shortcut - copy cell above Grant 4 650 16-09-2017, 09:22
Last Post: Matt



Users browsing this thread: 1 Guest(s)