The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel courses in london - Delete

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

excel courses in london - Delete

Resolved · Low Priority · Version Standard

ReplyThu 22 Mar 2007, 16:18Delegate jocelyne said...

Delete

how do i delete a cell

For upcoming training course dates see: Pricing & availability

ReplyFri 23 Mar 2007, 09:22Trainer Rich said...

Delete cells in excel

Hi Jocelyne,

Normally you just select the cell (by using arrow cursor keys to get to the cell, or click on it with your mouse), and then press DELETE on the keyboard.

Or right click a cell and choose Clear Contents.

Note these options do not clear the formatting for the cell.

Right click on a cell and choose Delete... to see more delete options such as an entire row or column.

I hope this helps. If this response has answered your query, please mark the question as resolved.

Kind regards,
Rich

Excel articles

· What You Need To Know About LOOKUP Functions In Excel 2007/2010
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· How To Use Freeze Panes In Excel 2007
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· Tap the Power of Recorded Macros with MS Excel Courses

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

View all Excel hints and tips

How can I create a form in Access?

» Forum post: Access Training

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions