Excel 2008

[dan88]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

How do you delete multiple cells at one time.
I use to hold CTRL and click or scroll through all the cells i wanted to delete, and simply press delete. Now it only deletes the top left cell!?

What do i do?

 

[CyberTaz]

Are you using a laptop or a Mac with one of the abbreviated keyboards? If
so, the delete key by itself will delete only the content of the active cell
in the selected range. Hold the fn key while pressing the delete key to
clear the content of all selected cells.

Ctrl+Click brings up a contextual (shortcut) menu which contains a Clear
Contents as well as a Delete command but the pointer has to be in the
selected range when you use that method. Also, the 2 commands execute
decidedly different actions ‹ one deletes the cell content, the other
deletes the entire cell. It isn't really clear which you're trying to do.

The commands are also available from the Edit menu, and all keyboard
shortcuts can be found if you search Excel Help using that topic.

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