Exceljet

Quick, clean, and to the point

Delete to end of line

Windows shortcut

CtrlDelete

Mac shortcut

⌃Delete

Inside a cell, this shortcut delete text starting from the cursor to the end of the current line of text.

See all shortcuts

Related videos

The videos below demonstrate this shortcut.

Shortcuts for editing cells

In this lesson, we review shortcuts you can use to edit cells more efficiently.

What is an array?

The term "array" comes from programming, but you'll hear it often in the context of more advanced Excel formulas. In this video, we'll answer the question "what is an array?"

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.

Topics

Key functions

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts. Read more.

I was searching around for about 45 minutes, trying to find a simple way to count the number of cells in a range which had any number in them. I saw MANY attemps: VisualBasic, Regular expressions which required a huge overhead of code to load, dizzyingly complicated MOD and STR and LENGTH functions strung together in mind-bending combinations, and then... I found yours. Simple, elegant, and ultimately malleable to other purposes. I copied, pasted, modified, and BAM! I was done and it worked *perfectly*! -Dana

Delete to end of line

Related videos

Download 200+ Excel Shortcuts

Excel video training