Solved

How to delete an excel cell and auto shift left/Keyboard shortcut for deleting a cell and shift row left

Posted on 2014-02-16
7
6,271 Views
Last Modified: 2014-02-17
Anybody know how to delete an Excel cell and auto shift a row left upon deletion / Keyboard shortcut for deleting a cell and shift row left?
0
Comment
Question by:Mark_Co
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 19

Expert Comment

by:regmigrant
ID: 39863615
you can record a macro to do it for you: enable the developer tab if you haven't already - right click ribbon, customise ribbon, select the developer tick box in the right hand pane.

Select the cell you want to delete
On developer tab click Record Macro and give it a name and a shortcut key (ctrl+d for example)
right click, delete, shift cells left
Stop recording

now you can select any cell and hit ctrl-d
0
 
LVL 81

Expert Comment

by:byundt
ID: 39863896
ATL + H + D +D +L, Enter is keyboard shortcut in Excel 2013 for deleting a selected cell, and shifting the rest of the row to the left. Do it slowly.

In Excel 2003, the equivalent is ALT + E + D +L, Enter.

The comma in the above shortcuts means to release the ALT key before hitting Enter.
0
 
LVL 32

Expert Comment

by:Rob Henson
ID: 39864222
Alternative keystroke routine is:

Ctrl + Minus Key, L & Enter.

You may be able to do away with pressing L and just press enter, depends on the default selection in the Deletion pop up. The various combinations of cell selections I have checked, the default is Shift Left, maybe because it is the first in the list.

Thanks
Rob H
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:Mark_Co
ID: 39865725
What about for Excel 2011 for Mac? I couldn't get those shortcuts to work. They just entered in strange characters instead.
0
 
LVL 19

Expert Comment

by:regmigrant
ID: 39865768
the macro approach should still work :)

in Excel for windows pressing alt makes the ribbon display a series of shortcut keys over each group in the ribbon, alt + h gives a shortcut to every visible item on the home tab. the sequence given above is just a matter of following those shortcuts - so alt h d brings up the 'shift cells' dialog then l selects shift cells left and enter confirms.

the mac should have equivalent shortcuts probably using the 'mac' key or whatever you call that one with the squiggles.
0
 
LVL 81

Accepted Solution

by:
byundt earned 500 total points
ID: 39866048
Control + hyphen, Enter will work in Macintosh Excel 2011.

The , means to release the Control and hyphen keys before hitting Enter.

You can find other keyboard shortcuts by searching for "Excel Keyboard Shortcuts" in the Excel help in Excel 2011.
0
 

Author Closing Comment

by:Mark_Co
ID: 39866570
YES! Thank you all so much. This one worked and was the simplest solution.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Looking for macro to do version saving of workbooks in Excel 2016. 6 39
Office 2016 Excel Issue 4 26
Delete texts with font color 16 30
Dynamic Filter ? 4 21
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now