When you forget to hold Ctrl key for inputting same value to a range…

Ctrl+D or Ctrl+R is ready to help🙂

Ctrl+Enter is one of my favorite shortcuts.  It helps me to input a value or a formula to a range simultaneously.  As usual, Ctrl+Enter won’t let me down.  But many times, I just type too fast and forget to hold Ctrl when hitting Enter, like the screenshot below:

Excel Tips - Ctrl D to fill Down 1

Sound familiar to you too?  What would you do then? Go back and repeat the intended action of Ctrl+Enter?

This is what I would do (sometimes)  :P

Excel Tips - Ctrl D to fill Down 2


  • Ctrl+D (Fill Down) works for vertical range
  • Ctrl+R (Fill Right) works for horizontal range
  • Ctrl+D then Ctrl+R (sequence does not matter) works for a rectangular range
  • This trick does not work for non-continuous range however.
This entry was posted in Excel Tips and tagged , . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s