Excel Tips: Fill Down

Excel is a tool many use everyday and few are really ever taught how. Most often we are using Excel to track data by categories or similar criteria. We end up having to do a bunch of copy and pasting or, even worse, re-typing! Here are a few simple ways to fill in your sheet and save you typing or copy/paste time.

Fill Down or Fill In <ctrl d> or <cmd d>:

This first method is a simple one for those who love keyboard shortcuts. Simply highlight the word you want and the rows you want to place it in and hit <ctrl> & <d> and it will fill in the cells (it is <cmd> & <d> for Mac):

This works if you skip cells too. Do this by choosing the word or number you want and then hold down <ctrl> and select all the cells you want this information in. Then once again hit <ctrl> & <d> and it will fill in the cells:

Fill Down: Another method is to drag the word down. By clicking the box in the corner of the cell and dragging it down to where you the data to go.

Or you could simply double click on the box in the corner and it will fill all the way down to the last empty row. In this case, it would stop in the cell before the word “number”.

Published by Joe Lawrence

Joe is passionate about developing others using the lessons he has learned from education, mentors, military and life. His personal mission is to serve others through mentorship so they can grow into their full potential as leaders.

Leave a Reply

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

<span>%d</span> bloggers like this: