Learn Keyboard Shortcut To Drag Down in excel

drag down

To drag down in excel values from above cell to the active cell you need to press the keyboard shortcut Control + D. You can use this key for a single cell, or you can also drag values to a range of cells by selecting all those cells.

1-drag-down

Control+R

2-press-shortcut-for-drag-down

In the above example, we have selected the range A1 to A8 and now when you press the shortcut key it drags down the values up to the cell A8.

Apart from this, if you want to drag values to the right side you can use the keyboard shortcut Control + R.

Free Excel Templates

yearly-calendar-portrait

Yearly Calendar Portrait

Our yearly calendar templates for Excel are extremely easy to …

smart-goals-worksheet

Smart Goal

A SMART Goal is Specific, Measurable, Attainable, Relevant, and Time-bound (smart goals acronym). Download our printable …

moving-checklist

Moving Checklist

Movers and Packers Checklist:  Whether you are moving out of …

Service_Business_Accounting-balance-full

Service Business Accounting

In business, there are three different common business classification you …

We Create Your Life Easy With Our Free Excel Templates & Spreadsheet Dashboards

Use free Excel Templates, Tools and Dashboards to create and draft a professional looking dashboards and computation sheet for your personal and business use. You can Explore Calendars, Activity Planners, Invoice Templates, Sales Forecast Sheets, Budget templates and various business information delivering Templates in Excel and Spreadsheet at XLSX Templates. 

These templates, dashboards and tools are useful in various occasions. You can also customize these templates as per your requirement. Modification of fields and data source helps in making the template more relevant.

Learn Microsoft Excel : Blogs and Articles

Learn about various tips and tricks in Microsoft Excel and Spreadsheet. Create best templates and dashboards using free tricks and tutorials in excel and spreadsheet. These tutorial posts are useful for everyone who wants to master the skills in excel and spreadsheet.