Hello @eagleview5267, You are most welcome. We are glad it helped simplify things for you. Sometimes, keeping it simple really is the best approach! 😊 Keep learning Excel with ExcelDemy! Regards ExcelDemy
Hello @Kevin-g3g1v, You can drag and fill numbers in Excel using VBA or shortcuts. For shortcuts, you can use CTRL + D to fill down or CTRL + R to fill right. To automate this with VBA, use the following code. Sub DragFillRows() Dim ws As Worksheet Set ws = ThisWorkbook.Sheets("Sheet1") ' Change to your sheet name ' Define the range to fill Dim fillRange As Range Set fillRange = ws.Range("A1:A10") ' Change to your desired range ' Fill the range based on the first cell fillRange.FillDown End Sub Regards ExcelDemy
Hello @Kevin-g3g1v, To autofill from one row above the active cell down a specific number of rows. Select the active cell where you want to start. Use this formula in VBA: ActiveCell.Offset(-1, 0).Copy Destination:=ActiveCell.Resize([number_of_rows], 1) This copies from one row above the active cell and fills down the specified number of rows. To do it manually; Copy the data above, select the cells below, and use the autofill handle to drag it down. Regards ExcelDemy
Hello @gouravrathorr, if you want to use the above Table, you can download it from here: www.exceldemy.com/wp-content/uploads/2022/04/Excel_Table_Automatically_Add_New_Row-1.xlsm Then insert a new row by following the methods described in the video: To use a new row inserted in a table from an above table, you can set up your Excel so that any new row added to the table above is automatically included in your references or formulas. This can be done using structured references, which automatically adjust to include new rows. If you want you can follow the article also: www.exceldemy.com/excel-table-automatically-add-new-row/ Regards ExcelDemy
Hello @kaioumhossain6511, To merge rows in Excel, you’ll need to merge the cells across the row instead, as Excel does not directly support merging entire rows. To merge rows in Excel, you can use the "Merge & Center" option. 1. Select the cells you want to merge, 2. Go to the Home tab >> click Merge & Center under the Alignment group. For additional merging options, click the dropdown next to Merge & Center to choose options like Merge Across or Merge Cells. Regards ExcelDemy
Hello @lisasmith7601, We also used Microsoft Excel 365. Downloaded Excel file works but it doesn't works in your environment so it seems you might not have completed all the necessary steps in the "Options" settings for Excel 365. If not, may be this is the reason the method isn't working as expected. Please double-check the specific steps in the video from 00:48 to 1:36 related to the "Options" settings. Those are crucial for enabling the automatic row addition feature in Excel 365. To enable the feature where Excel automatically adds a new row to a table: 1.Click on File >> select >> Excel Options >> navigate to the >> Proofing section, 2. Then check >> Include new rows and columns in table and Fill formulas in tables to create calculated columns. Let us know if you need further assistance! Regards ExcelDemy
Hello @Kevin-g3g1v , Yes it is possible. You will need to use VBA along with task schedular. You can use this VBA code to add a new row automatically in an Excel table every day: Sub AddRowDaily() Dim ws As Worksheet Set ws = ThisWorkbook.Sheets("Sheet1") ' Change to your sheet name Dim tbl As ListObject Set tbl = ws.ListObjects("Table1") ' Change to your table name ' Add a new row at the end of the table tbl.ListRows.Add End Sub To automate this, you need to use Windows Task Scheduler to run the macro daily. Schedule the Task: 1. Open Task Scheduler on your computer. 2. Select Create Basic Task. 3. Name the task and select Daily for the trigger. 4. Choose the time you want it to run. 5. Select Start a Program and browse for your Excel application (usually located in C:\Program Files\Microsoft Office oot\OfficeXX\EXCEL.EXE, where XX depends on your Office version). 6. In the Add arguments box, type /x "Path\to\your\file.xlsm" (replace with your actual file path). 7. Click Finish. This will run the macro daily at the specified time. Regards ExcelDemy
Hello @carst1bahs, You're right! The VBA macro will add a new row only when the workbook is open and active. To automate this without needing the sheet to be activated, you could consider using a background process like Windows Task Scheduler to run the macro even when Excel isn't in focus. However, for this to work seamlessly, the file must be open, so make sure to check your schedule and Excel settings to ensure the task runs as expected. Regards ExcelDemy
Was that an AI video??? The speaker's broken English seemed to have flaws in the common broken English mistakes. It seemed liked it was a compilation of several broken English accents.
Great video though! Gave different methods for doing this that I found very useful. The method I'm using breaks sometimes. Will try some of the other ones shown here.
Dear @timkropf4648, Thanks for your appreciation. If you are facing any problem regarding any methods you can post it in our ExcelDemy Forum: exceldemy.com/forum/ Regards ExcelDemy
very helpful. thank you!
Thank you this was easy and I was trying to make things harder than they needed to be!
Hello @eagleview5267,
You are most welcome. We are glad it helped simplify things for you. Sometimes, keeping it simple really is the best approach! 😊
Keep learning Excel with ExcelDemy!
Regards
ExcelDemy
I really enjoyed the video, would appreciate it if you could upload more.
Is it possible to drag numbers of rows by VBA or a short-cut? 🙏🙏🙏
Hello @Kevin-g3g1v,
You can drag and fill numbers in Excel using VBA or shortcuts.
For shortcuts, you can use CTRL + D to fill down or CTRL + R to fill right.
To automate this with VBA, use the following code.
Sub DragFillRows()
Dim ws As Worksheet
Set ws = ThisWorkbook.Sheets("Sheet1") ' Change to your sheet name
' Define the range to fill
Dim fillRange As Range
Set fillRange = ws.Range("A1:A10") ' Change to your desired range
' Fill the range based on the first cell
fillRange.FillDown
End Sub
Regards
ExcelDemy
@@exceldemy2006 Thanks again!!! Can I point an active cell , drag and autofill from one row above the active cell, down certain numbers of rows? 🙏🙏🙏
Hello @Kevin-g3g1v,
To autofill from one row above the active cell down a specific number of rows. Select the active cell where you want to start.
Use this formula in VBA:
ActiveCell.Offset(-1, 0).Copy Destination:=ActiveCell.Resize([number_of_rows], 1)
This copies from one row above the active cell and fills down the specified number of rows.
To do it manually;
Copy the data above, select the cells below, and use the autofill handle to drag it down.
Regards
ExcelDemy
@@exceldemy2006 Thanks a lot!!!
Hello @Kevin-g3g1v,
You are most welcome. keep learning Excel with ExcelDemy!
Regards
ExcelDemy
I want to use table new row inserted from above table.
Hello @gouravrathorr,
if you want to use the above Table, you can download it from here:
www.exceldemy.com/wp-content/uploads/2022/04/Excel_Table_Automatically_Add_New_Row-1.xlsm
Then insert a new row by following the methods described in the video:
To use a new row inserted in a table from an above table, you can set up your Excel so that any new row added to the table above is automatically included in your references or formulas. This can be done using structured references, which automatically adjust to include new rows.
If you want you can follow the article also:
www.exceldemy.com/excel-table-automatically-add-new-row/
Regards
ExcelDemy
THANKS A LOT!!! How about add more than 1 row, 100 rows?
FIND it, 1:💯 😀
Hello @Kevin-g3g1v,
Congratulations! Glad to hear that you found the solution. Feel free to reach out to ExcelDemy!
Regards
ExcelDemy
How to add merge raw
Hello @kaioumhossain6511,
To merge rows in Excel, you’ll need to merge the cells across the row instead, as Excel does not directly support merging entire rows.
To merge rows in Excel, you can use the "Merge & Center" option.
1. Select the cells you want to merge,
2. Go to the Home tab >> click Merge & Center under the Alignment group.
For additional merging options, click the dropdown next to Merge & Center to choose options like Merge Across or Merge Cells.
Regards
ExcelDemy
Good job
Thanks a lot
Dear, You are most welcome! Stay connected.
But this doesn't work in 365. : ( If I down load the file to my computer, it works. I don't always want to download it. So frustrating.
Hello @lisasmith7601,
We also used Microsoft Excel 365. Downloaded Excel file works but it doesn't works in your environment so it seems you might not have completed all the necessary steps in the "Options" settings for Excel 365.
If not, may be this is the reason the method isn't working as expected. Please double-check the specific steps in the video from 00:48 to 1:36 related to the "Options" settings. Those are crucial for enabling the automatic row addition feature in Excel 365.
To enable the feature where Excel automatically adds a new row to a table:
1.Click on File >> select >> Excel Options >> navigate to the >> Proofing section,
2. Then check >> Include new rows and columns in table and Fill formulas in tables to create calculated columns.
Let us know if you need further assistance!
Regards
ExcelDemy
@@exceldemy2006 thanks!
Hello @lisasmith7601,
You are most welcome. keep learning Excel with ExcelDemy!
Regards
ExcelDemy
Is it possible to add one row automatically every single day?
Hello @Kevin-g3g1v ,
Yes it is possible. You will need to use VBA along with task schedular.
You can use this VBA code to add a new row automatically in an Excel table every day:
Sub AddRowDaily()
Dim ws As Worksheet
Set ws = ThisWorkbook.Sheets("Sheet1") ' Change to your sheet name
Dim tbl As ListObject
Set tbl = ws.ListObjects("Table1") ' Change to your table name
' Add a new row at the end of the table
tbl.ListRows.Add
End Sub
To automate this, you need to use Windows Task Scheduler to run the macro daily.
Schedule the Task:
1. Open Task Scheduler on your computer.
2. Select Create Basic Task.
3. Name the task and select Daily for the trigger.
4. Choose the time you want it to run.
5. Select Start a Program and browse for your Excel application (usually located in C:\Program Files\Microsoft Office
oot\OfficeXX\EXCEL.EXE, where XX depends on your Office version).
6. In the Add arguments box, type /x "Path\to\your\file.xlsm" (replace with your actual file path).
7. Click Finish.
This will run the macro daily at the specified time.
Regards
ExcelDemy
@@exceldemy2006 THANK YOU SO MUCH!!!
Hello @Kevin-g3g1v,
You are most welcome. Thanks for your appreciation. Keep exploring Excel tutorials with ExcelDemy!
Regards
ExcelDemy
Only if the sheet is activated.......
Hello @carst1bahs,
You're right! The VBA macro will add a new row only when the workbook is open and active. To automate this without needing the sheet to be activated, you could consider using a background process like Windows Task Scheduler to run the macro even when Excel isn't in focus. However, for this to work seamlessly, the file must be open, so make sure to check your schedule and Excel settings to ensure the task runs as expected.
Regards
ExcelDemy
Was that an AI video??? The speaker's broken English seemed to have flaws in the common broken English mistakes. It seemed liked it was a compilation of several broken English accents.
Great video though! Gave different methods for doing this that I found very useful. The method I'm using breaks sometimes. Will try some of the other ones shown here.
Dear @timkropf4648,
Thanks for your appreciation. If you are facing any problem regarding any methods you can post it in our ExcelDemy Forum: exceldemy.com/forum/
Regards
ExcelDemy