Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Reply
 
Thread Tools Search this Thread Display Modes
Old Oct 14, 2010, 12:27 PM   #1
crypticlineage
macrumors regular
 
Join Date: Jun 2010
Excel delete function question

In Excel for office 08, the delete key will not clear contents of the selected cells, only of the first one. Everytime I need to right click and select clear contents.

Also, if I wanted to delete the selected cells and move the bottom cells up, I would have to use the right click and choose delete option.

Why doesn't the delete key work like it's supposed to?

Last edited by dejo; Oct 14, 2010 at 12:31 PM. Reason: Thread moved. Mention of inappropriate thread removed.
crypticlineage is offline   0 Reply With Quote
Old Oct 14, 2010, 12:31 PM   #2
GGJstudios
macrumors Westmere
 
Join Date: May 2008
Quote:
Originally Posted by crypticlineage View Post
In Excel for office 08, the delete key will not clear contents of the selected cells, only of the first one. Everytime I need to right click and select clear contents.

Also, if I wanted to delete the selected cells and move the bottom cells up, I would have to use the right click and choose delete option.

Why doesn't the delete key work like it's supposed to?
It's working as designed. The delete key alone isn't supposed to clear contents from a range of cells or delete a cell.
GGJstudios is offline   0 Reply With Quote
Old Oct 14, 2010, 12:37 PM   #3
Panch0
macrumors 6502a
 
Join Date: Feb 2010
Location: Northern Virginia, USA
Quote:
Originally Posted by crypticlineage View Post
In Excel for office 08, the delete key will not clear contents of the selected cells, only of the first one. Everytime I need to right click and select clear contents.

Also, if I wanted to delete the selected cells and move the bottom cells up, I would have to use the right click and choose delete option.

Why doesn't the delete key work like it's supposed to?
Because it's more of a Backspace than a Delete. Try Fn + Delete. I don't know it that actually works in Excel, but in most cases, Fn+Delete is the traditional "Delete"
Panch0 is offline   0 Reply With Quote
Old Oct 14, 2010, 12:38 PM   #4
crypticlineage
Thread Starter
macrumors regular
 
Join Date: Jun 2010
so am I supposed to right click everytime? What if I have to go through 5000 cells? Clearly there must be a way to set this option? At the very least fn+delete or some such combination should do it, no?

Thanks for moving my thread to the right place.
crypticlineage is offline   0 Reply With Quote
Old Oct 14, 2010, 12:39 PM   #5
GGJstudios
macrumors Westmere
 
Join Date: May 2008
Quote:
Originally Posted by Panch0 View Post
Because it's more of a Backspace than a Delete. Try Fn + Delete. I don't know it that actually works in Excel, but in most cases, Fn+Delete is the traditional "Delete"
Fn+Delete does clear contents of a cell or range of cells, but won't delete a cell.
GGJstudios is offline   0 Reply With Quote
Old Oct 14, 2010, 12:46 PM   #6
crypticlineage
Thread Starter
macrumors regular
 
Join Date: Jun 2010
Yes, the fn+delete deletes a range of cells.

However, my other problem remains, being able to shift cells up, down or left right when I delete. I wonder if there is another key combination for that.

Thanks for the tip.
crypticlineage is offline   0 Reply With Quote
Old Oct 14, 2010, 12:49 PM   #7
Panch0
macrumors 6502a
 
Join Date: Feb 2010
Location: Northern Virginia, USA
Quote:
Originally Posted by crypticlineage View Post
so am I supposed to right click everytime? What if I have to go through 5000 cells? Clearly there must be a way to set this option? At the very least fn+delete or some such combination should do it, no?

Thanks for moving my thread to the right place.
Searching Excel help for "keyboard"... The first hit is "Create a custom Keyboard shortcut". Tools/Customize Keyboard should help you set up a key combination for the Edit/Delete function.
Panch0 is offline   0 Reply With Quote
Old Oct 14, 2010, 12:54 PM   #8
GGJstudios
macrumors Westmere
 
Join Date: May 2008
Quote:
Originally Posted by crypticlineage View Post
Yes, the fn+delete deletes a range of cells.
No, it clears the contents, but doesn't delete the cells.
Quote:
Originally Posted by crypticlineage View Post
However, my other problem remains, being able to shift cells up, down or left right when I delete.
That's because fn+delete doesn't delete the cells. It only clears the contents, leaving the cells still there, but empty.
GGJstudios is offline   0 Reply With Quote
Old Oct 14, 2010, 12:56 PM   #9
crypticlineage
Thread Starter
macrumors regular
 
Join Date: Jun 2010
YES! YES! YES! Of course....

I set up Cmd+D as my delete key, and viola, it deletes the range of selected cells and moves bottom cells up. Exactly what I wanted.

Thanks.
crypticlineage is offline   0 Reply With Quote
Old Oct 15, 2010, 12:23 PM   #10
Gregg2
macrumors 601
 
Join Date: May 2008
Location: Milwaukee, WI
or you could use the menu
Gregg2 is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Question about Excel versions Live2Fish Mac Applications and Mac App Store 5 Dec 13, 2013 12:55 PM
Clear Pivot Function in Excel Mac lostnhre Mac Basics and Help 1 Jan 26, 2013 06:02 PM
Excel / Google Spreadsheets function to live-update number of Twitter followers? jent Mac Applications and Mac App Store 1 Nov 20, 2012 03:19 PM
MS Excel on OS X Question faru Mac Basics and Help 2 Oct 10, 2012 12:31 PM
iPhoto's over-zealous "delete duplicates" function Annalea Mac Applications and Mac App Store 3 Sep 27, 2012 01:56 PM

Forum Jump

All times are GMT -5. The time now is 08:00 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC