Macworld Forums: Deleting the contents of cells in Excel for X - Macworld Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Deleting the contents of cells in Excel for X

#1 User is offline   Kyan Icon

  • Member
  • PipPip
  • Group: Members
  • Posts: 259
  • Joined: 12-January 03

Posted 08 May 2005 - 05:13 AM

Can anyone PLEASE tell me how to delete the contents of a block of cells I've selceted in Excel?
I;m coming very recently from Windows and am used to selecting a range of cells and hitting delete to empty them. How do i do this in the Mac version?
I am at a loss. I took me forever to figure out how to move from sheet to sheet, too. The help section is less than helpful on this...
0

#2 User is offline   shades Icon

  • Member
  • PipPip
  • Group: Members
  • Posts: 344
  • Joined: 28-June 02

Posted 08 May 2005 - 09:46 AM

Not sure what version of XL you are using, but I'm using XL 2004 on OS X 10.3.9. I select the cells and hit the Delete key (directly under the Help key and to the left of the END key). Works fine.
0

#3 User is offline   moose_n_squirrel Icon

  • Veteran
  • PipPipPip
  • Group: Members
  • Posts: 2,965
  • Joined: 16-September 04

Posted 08 May 2005 - 10:14 AM

You're running into one of those unintentional (?) roadblocks resulting from a long ago decision by Apple. You probably noticed that what is called the Backspace key on Windows is called Delete on the Mac and it causes much confusion because on Windows, Backspace and Delete mean two entirely different things while the Mac mashes them into one key.
If you want to delete all the contents of all selected cells, you have two choices. If you are using a Mac desktop, try the Delete key in the middle keypad, as Shades said (NOT the one next to the plus sign on the main keyboard). If you are using a PowerBook/iBook, press FnDelete. Fn is the button at the lower left corner of a Mac laptop keyboard. Try FnDelete any time the keyboard Delete isn't doing what you want.
The other way to do it is use the Clear Contents command. It's also on the right-click menu. Don't listen to the Mac extremists...if you like using a multi-button mouse, plug one in. Mac Office makes extensive use of the right mouse button.
0

#4 User is offline   Kyan Icon

  • Member
  • PipPip
  • Group: Members
  • Posts: 259
  • Joined: 12-January 03

Posted 08 May 2005 - 10:27 PM

Thank you very much! Yes, it is the missing delete key which is the problem.
I have an iBook, btw. Thanks again!
0

#5 User is offline   bchawes Icon

  • Newbie
  • Pip
  • Group: Members
  • Posts: 2
  • Joined: 07-June 05

Posted 07 June 2005 - 03:48 AM

try: apple "B"
0

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

2 User(s) are reading this topic
0 members, 2 guests, 0 anonymous users