copy&paste formulas

S

sprytlejake

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I want to copy and paste formula from column to column, but I want to keep some of the same cells in the formula each time. I know there's a special key command for this, but I can't remember the combination. Can someone help me?
 
X

XinXin

I guess you are talking about the absolute reference v.s. relative reference. For instance, if you want to keep the column name unchanged while coping, use $A1 instead of A1.

Thanks,
XinXin Liu
Macintosh Business Unit, Microsoft

This posting is provided "AS IS" with no warranties, and confers no rights.
 
C

CyberTaz

Further to the other reply, see Excel Help of the topic:

Switch between relative and absolute references

HTH |:>)
Bob Jones
[MVP] Office:Mac
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas in Chart Titles Axis Titles 4
copy and paste from exel 6
excel - exporting bar graph 3
copy and paste worksheet 4
Copy cell issue - Copies values instead of formulas 2
unable to paste data into Excel 3
How can I easily repeat a series of key strokes 1
Copy Paste issue with formatting 1

Top