- Excel - Context Help
- Excel - Open Workbook
- Excel - Close Workbook
- Excel - Delete Worksheet
- Excel - Hiding Worksheet
- Excel - Copy Worksheet
- Excel - Create Worksheet
- Excel - Save Workbook
- Excel - Move Around
- Excel - Entering Values
- Excel - Backstage
- Excel - Explore Window
- Excel - Getting Started
- Excel - Home
Editing Worksheet
- Excel - Undo Changes
- Excel - Add Text Box
- Excel - Insert Comments
- Excel - Special Symbols
- Excel - Zoom In-Out
- Excel - Spell Check
- Excel - Find & Replace
- Excel - Copy & Paste
- Excel - Rows & Columns
- Excel - Move Data
- Excel - Delete Data
- Excel - Select Data
- Excel - Insert Data
Formatting Cells
- Excel - Apply Formatting
- Excel - Borders and Shades
- Excel - Merge & Wrap
- Excel - Text Alignments
- Excel - Setting Colors
- Excel - Rotate Cells
- Excel - Text Decoration
- Excel - Setting Fonts
- Excel - Setting Cell Type
Formatting Worksheets
- Excel - Conditional Format
- Excel - Freeze Panes
- Excel - Set Background
- Excel - Insert Page Breaks
- Excel - Header and Footer
- Excel - Page Orientation
- Excel - Adjust Margins
- Excel - Sheet Options
Working with Formula
- Excel - Builtin Functions
- Excel - Using Functions
- Excel - Formula Reference
- Excel - Copying Formulas
- Excel - Creating Formulas
Advanced Operations
- Excel - Keyboard Shortcuts
- Excel - Pivot Charts
- Excel - Simple Charts
- Excel - Pivot Tables
- Excel - Data Tables
- Excel - Workbook Security
- Excel- Translate Worksheet
- Excel - Email Workbooks
- Excel - Printing Worksheets
- Excel - Cross Referencing
- Excel - Adding Graphics
- Excel - Using Macros
- Excel - Using Templates
- Excel - Using Themes
- Excel - Using Styles
- Excel - Data Validation
- Excel - Using Ranges
- Excel - Data Sorting
- Excel - Data Filtering
MS Excel Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
Copying Formulas in Excel 2010
Copying Formulas in MS Excel
Copying formulas is one of the most common tasks that you do in a typical spreadsheet that repes primarily on formulas. When a formula uses cell references rather than constant values, Excel makes the task of copying an original formula to every place that requires a similar formula.
Relative Cell Addresses
MS Excel does it automatically adjusting the cell references in the original formula to suit the position of the copies that you make. It does this through a system known as relative cell addresses, where by the column references in the cell address in the formula change to suit their new column position and the row references change to suit their new row position.
Let us see this with the help of example. Suppose we want the sum of all the rows at last, then we will write a formula for first column i.e. B. We want sum of the rows from 3 to 8 in the 9th row.
After writing formula in the 9th row, we can drag it to remaining columns and the formula gets copied. After dragging we can see the formula in the remaining columns as below.
column C : =SUM(C3:C8)
column D : =SUM(D3:D8)
column E : =SUM(E3:E8)
column F : =SUM(F3:F8)
column G : =SUM(G3:G8)