Glide Training Logo

Should I use Clear, Delete or Delete in Excel?

  

Written by Jane Hames

Yes, the title of this post does sound as though I’ve made a mistake! It is, however, entirely deliberate as I am going to explain the difference between Delete on the keyboard, the Delete command on the ribbon and Clear in Excel.

I meet many people on my training workshops who have been caught out by using the wrong one, but once you understand the difference between them, it really is very simple.

So, here goes:

Delete on the keyboard

The Delete key on the keyboard carries out the Clear command. It clears the contents of the cells, columns or rows you have selected. So it clears text, formulae, numbers and dates. It does NOT clear the formatting and it does NOT delete the cells that you have selected.

The Clear command on the ribbon

clear on ribbon

The Clear command gives you the option to clear just the formatting, just the contents (the same as Delete on the keyboard), just hyperlinks or just comments. Clear All will clear all the things listed, but it will NOT delete the cell or cells you have selected.

The Delete command on the ribbon

copy on ribbon

The Delete command on the ribbon is useful for removing cells, columns or rows from a sheet. When used, it will delete the selection which will leave a gap on the sheet. The rows, columns or cells that remain will move across, up or down to fill in the gap.


previous post: Love ’em or hate ’em: Automatic Formatting Features in Word

next post: Autofill is creating a series and I just want to copy data!

Why choose Glide?

Our Unique Approach

Our Unique Approach

We work on a bespoke, requirements-led basis rather than offer a set range of courses. We will work with you to identify your specific requirements and objectives before any training is delivered. That way you can be sure that training will always deliver exactly what you're looking to achieve.

View details »

Our Low Prices

Our Low Prices

We deliver all our on-site training at our customers' premises. Not only does that avoid any travel inconvenience for your team, but also it means we don't have the overheads required to maintain a dedicated training centre - and in turn we are able to pass these savings on to you.

View details »

Our Expertise

Our Expertise

Our trainers have designed and delivered IT training for a wide range of organisations and people including accountants, lawyers, data analysts, sales consultants and buyers. Clients benefit from our our ability to find creative solutions to their problems based on many years of experience.

View details »

Balderton Logo
Kreston Reeves Logo
National Institute of Health Research
England Rugby
Caravan and Motorhome Club Logo
Bird and Blend Logo
Ropetackle Logo
RBLI Logo
Farnborough Airport Logo
Kroll Logo
The Apprenticeship College Logo
Shoreham Port Logo
Adur and Worthing Councils Logo
Balderton Logo
Kreston Reeves Logo
National Institute of Health Research
England Rugby
Caravan and Motorhome Club Logo
Bird and Blend Logo
Ropetackle Logo
RBLI Logo
Farnborough Airport Logo
Kroll Logo
The Apprenticeship College Logo
Shoreham Port Logo
Adur and Worthing Councils Logo