CODEWITHSUNDEEP
excel
BuZz
BuZz

Reputation: 17495

Excel : calculate a column only

How can I select a column from a cell in Excel, and then calculate this column only ? I know only SHIFT + F9 that calculates te whole sheet, and F9 that calculates the whole workbook.

Thank you guys ;)

Upvotes: 6

Views: 14373

Answers (1)

JMax
JMax

Reputation: 26601

I don't think you can do it with only standard Excel (does anybody have a good tip?).

You can create a simple macro that will do it for you:

Sub Recalc()
Selection.Calculate
End Sub

And assign a shortcut to it. This will recalculate the selection only.

Upvotes: 10

Related Questions