Unable to delete cell range.

[LuckyHipster]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel New to excel and following a video tutorial. I am using auto-fill to create a range of numbers. The cells are selected and I try to delete all the content in the range by pressing the delete button per the tutorial but only the first cell in the range is deleted. Please help a newbie.

 

[CyberTaz]

Are you using a laptop or a condensed keyboard by any chance?

If so, the key labeled 'delete' is the equivalent of 'backspace' & does
delete only the content of the active cell in the range. You need to hold
the 'fn' key while you press it to get the 'Delete' operation to delete the
content of all cells. If using a Full keyboard use the key usually labeled
'del' in the Navigation Key group.

Alternatively, use the Edit menu or Control/Right-Click in the selected
range & select the preferred command from the contextual menu.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[LuckyHipster]

Yes I am using a laptop and I followed your instruction. It worked perfectly. Thank you Bob.

>

Are you using a laptop or a condensed keyboard by any chance?