Forum Discussion
HELP, NEW TO EXCEL
Hi, I'm totally new to excel and I need major help. I need to create a spreed sheet in order to keep track of delivery's. Maybe by explaining it will help. I have 50+ customers who are receiving as...
Thank you so very much. Can you explain how to copy formulas for each line? I have about 200 people that I need to add in. I can't figure it out. I feel like an idiot even asking.
You can copy/paste a row in Excel by selecting the row by clicking in the gray row selector on the left of the grid, once the row is selected, copy by selecting copy from the menu bar or the Control+c key combination. Then select the next row down where you want to put the copied data and select Paste from the menu or the Control+v key combo. When you paste a formula, Excel automatically updates the formula to align with the new location.
- Or, alternatively, you can quickly copy a set of formulas by selecting a group of cells, and then hovering your cursor over the bottom rightmost part of the selected cells, Click on the crosshair and drag downward. When using this action, Excel will automatically fill the formulas as you drag down the sheet.