Copying formulas in all columns of an Excel spreadsheet
I have an Excel template for tracking expenses.
For each expense entry, there are columns for date, amount, how paid (check, credit card, etc), to whom paid, type of expense, and cumulative total of all expenditures.
By clicking on how paid, to whom paid
and category, I can get the total amount spent for this column.
I have filled in about 180 rows, and entries in subsequent rows are no longer covered by the formulas.
How do I extend this so the formulas are extended as I add rows to this spreadsheet?
Solutions to the Problem Copying formulas in all columns of an Excel spreadsheet
Here is one manual way:
Click on a cell with a Formula and release mouse button (you just selected the cell)Next hold down option keyMove Mouse pointer over cell (bottom edge) and when you see a grab hand with a + sign inside Hold down mouse key.Drag down and many rows as you need.Repeat with column with next formula.
Disclaimer: The opinions & answers are solely mine and mine alone, and do not necessarily reflect upon my position as a Community Moderator.
Make Sure that your Computer Meets the System Requirements
This error can be due to some configuration requirements for you system. If your PC hardware is not up to par, then make sure you upgrade where necessary before continuing:
Microsoft Windows Requirements :
- 1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
- 1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)
- 16 GB available hard disk space (32-bit) or 20 GB (64-bit)
If your computer meets the minimum requirements above, then continue on…
Another Safe way to Repair the Problem: Copying formulas in all columns of an Excel spreadsheet:
How to Fix Copying formulas in all columns of an Excel spreadsheet with SmartPCFixer?
1. You can Download Error Fixer here. Install it on your system. When you open SmartPCFixer, it will perform a scan.
2. After the scan is done, you can see the errors and problems which need to be repaired.
3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in SmartPCFixer. Like dll downloading, windows updating and print spooler error repair.
Related: How Can You Update & Download NVidia 6100, 6800 GS/XT Display Driver v.260.89 WHQL,Where to Download NVidia GeForce 8800 GT WHQL-certified driver v.196.21,How to Update & Download NVidia GeForce Go 7400 Display Driver v.260.19.12,[Solved] Download NVidia GeForce GTX 460M Driver v.331.82,Download NVidia Quadro Plex Model IV VGA Driver v.304.43 Certified,Way to Download RealTek RTL8100C(L) Driver v.5.01,Way to Download RealTek RTL8100E Drivers v.694,Way to Update & Download RealTek RTL8101L Auto Installation Program v.6.110 driver,Method to Update & Download RealTek RTL8111G PXE and RPL ROM code v.2.58 driver,How to Update & Download RealTek RTL8411B(N) Driver v.10.003,Best Way to Update & Download ASUS A53SV nVidia Graphics Driver v.126.96.36.19986,Method to Herunterladen ASUS K75VJ Intel Rapid Storage Technology Treiber v.188.8.131.520,How Can You Update & Download ASUS CG8580 Intel Chipset Driver v.184.108.40.2069,Method to Update & Download ASUS K41VD Intel INF Update Driver v.220.127.116.115,Way to Update & Download ASUS Pro70T NB Probe v.3.0.0026 driver
Read More: [Solution] Consider Replacing Battery in windows 7 home premium,[Solution] Ctl_Shift_Enter for a long SUM(VLOOKUP...) formula,Troubleshoot:Count more than one word,[Solved] Crash when saving\/open file or placing image,Troubleshooting:Copying Spreadsheet with Formulas to Another Spreadsheet WITHOUT Cell Values Error,Closing Internet Explorer causes error,Compare 2 Tables and Calculate the PROFIT Faster,Computer goes to Windows Boot Manager after Start,Connect to one of my network computer remotely when don't allow exception box Marked,computer locking up randomly