moderated Re: Microsoft Excel


Hi Steven,

Select the whole Column where you want the formula to be placed,
Press F2, type in the formula and press CTRL + Enter.

Now the formula will be applied to whole column.


On Wed, Apr 1, 2020 at 10:10 AM Hicks Steven (CORNWALL IT SERVICES) via Groups.Io <> wrote:

Hi friends,


I Have a formula in cell b2.

I Want that same formula to apply to the whole column b.

Is there an easy way to do that please?



This message may contain confidential information. If you are not the intended recipient please inform the
sender that you have received the message in error before deleting it.
Please do not disclose, copy or distribute information in this e-mail or take any action in relation to its contents. To do so is strictly prohibited and may be unlawful. Thank you for your co-operation.

NHSmail is the secure email and directory service available for all NHS staff in England and Scotland. NHSmail is approved for exchanging patient data and other sensitive information with NHSmail and other accredited email services.

For more information and to find out how you can switch,

Join to automatically receive all group messages.