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...
njmills19Below is an example of a nice simple spreadsheet you can build upon. The formula below was used in cell H2 to calculate the remaining total.
=B2-SUM(C2:G2)
The file is also attached for you to see and work off.
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're very welcome njmills19. As David Moore suggested you can copy formulas down easily by dragging the bottom right corner when you see the cross hair as pictured below.
- 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.
