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.
Control+R
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.
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 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.
Table of Contents How to Deselect Cells in Excel After adding the deselecting cells feature in Excel, this becomes so …
Table of Contents Select cell without using Ctrl Key By following these simple steps we can do it. At first, …
Table of Contents Where’s the Format Painter Button? It’s there on your Home Tab. If you look at the clipboard …
![Apply Strikethrough in Excel [Shortcut + Command]](https://xlsxtemplates.com/wp-content/uploads/2022/05/Apply-Strikethrough-in-Excel-Shortcut-Command.png)
Table of Contents Shortcut Key to Apply Strikethrough to a Cell Let’s say you’re in hurry and don’t want to …
Table of Contents Key Points To Consider Using Formula Bar You can hide or unhide the formula bar. You can …
Convert Date into Day Sub date2day() Dim tempCell As Range Selection.Value = Selection.Value For Each tempCell In Selection If IsDate(tempCell) …
Sub CustomHeader() Dim myText As String myText = InputBox(“Enter your text here”, “Enter Text”) With ActiveSheet.PageSetup .LeftHeader = “” .CenterHeader …
Sub DateInHeader() With ActiveSheet.PageSetup .LeftHeader = “” .CenterHeader = “&D” .RightHeader = “” .LeftFooter = “” .CenterFooter = “” .RightFooter …
Sub OpenCalculator() Application.ActivateMicrosoftApp Index:=0 End Sub In Windows, there is a specific calculator and by using this macro code you …
Sub UnmergeCells() Selection.UnMerge End Sub Unmerge Cells code simply uses the unmerge options which you have on the HOME tab. …
Sub RemoveTextWrap() Range(“A1”).WrapText = False End Sub This code will help you to remove text wrap from the entire worksheet …
Sub AutoFitRows() Cells.Select Cells.EntireRow.AutoFit End Sub You can use this code to auto-fit all the rows in a worksheet. When …
Sub AutoFitColumns() Cells.Select Cells.EntireColumn.AutoFit End Sub Use above Excel macro code to auto fit rows in all your sheet at …
Sub InsertMultipleColumns() Dim i As Integer Dim j As Integer ActiveCell.EntireColumn.Select On Error GoTo Last i = InputBox(“Enter number of …
Sub InsertMultipleRows() Dim i As Integer Dim j As Integer ActiveCell.EntireRow.Select On Error GoTo Last i = InputBox(“Enter number of …
