excel question

[Linklinker]

Anybody good with excel? I have an issue to clear up. How do I drag and copy a cell with a formula down a column without excel automatically advancing the numbers to match each row.

ex:
n5+n6 if I copy it down to the next cell then it reads
n6+n7 How can I stop it from doing that and force it to just copy the formula I typed in.

my formula =n5:n45/n46

I can drag the cell itself downward and it will display the correct results but any attempt to copy and paste or drag and copy along multiple cells results in my row numbers being advanced.

 

[FalTorPan]

Use a dollar sign ($) before the reference that you want to keep static.

Example: to keep a row reference static, use something like a$1 instead of a1.
Example: to keep a column reference static, use something like $b5 instead of b5.
Example: to keep both references static, use something like $d$7 instead of d7.

 

[Linklinker]

Thank you. That worked very well.

 

[Linklinker]

Another Excel question.

I need to make a chart of the top 5 highest values in a list. How do I do this without sorting it?

 

[USS KG5]

Another Excel question.

I need to make a chart of the top 5 highest values in a list. How do I do this without sorting it?

I have not looked this up but I'd be tempted to copy the worksheet to another worksheet, sort it, use this for a graph then hide the source sheet.

 

[Jadzia]

Another Excel question.

I need to make a chart of the top 5 highest values in a list. How do I do this without sorting it?

write a vba script to find those 5 highest values, and create a chart from what it outputs. That would work dynamically, so if you change the numbers, the chart would automatically update.