?

Hi friends,

?

just a quick query, you can use ctrl+c and ctrl+v for copy and paist in Microsoft Excel.

I Do quite a lot where I need to use paist special so that I can just copy formulas, I can’t seem to find a shortcut to do this other than using the right windows key, does anyone know a way to do this 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, https://portal.nhs.net/help/joiningnhsmail

?

In excel;

?

Go to the cell you wish to paste what you copied.

Do shift f10 and wqarrow down to paste special and right arrow to what you wish to do and hit enter.

?

There are many choices.

?

H t h

?

?

Hi friends,

?

just a quick query, you can use ctrl+c and ctrl+v for copy and paist in Microsoft Excel.

I Do quite a lot where I need to use paist special so that I can just copy formulas, I can’t seem to find a shortcut to do this other than using the right windows key, does anyone know a way to do this 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,

?

Thanks, I was just wondering if there was one key press e.g. if you do ctrl+v it just paists, if you use shift+f10, you have additional steps.? Just wanted to paist formula’s for example, that is the main one.

?

?

?

In excel;

?

Go to the cell you wish to paste what you copied.

Do shift f10 and wqarrow down to paste special and right arrow to what you wish to do and hit enter.

?

There are many choices.

?

H t h

?

?

Hi friends,

?

just a quick query, you can use ctrl+c and ctrl+v for copy and paist in Microsoft Excel.

I Do quite a lot where I need to use paist special so that I can just copy formulas, I can’t seem to find a shortcut to do this other than using the right windows key, does anyone know a way to do this 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,

*

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,

?

Hello Steven:

?

In Word, you can set the default paste option. See the below link.

?

?

I could not find an equivalent in Microsoft Excel. However, if you press Control+ Alt+v, you will be immediately presented with the paste special dialog and in my copy of Excel (Office 365), paste formulas is the first option when pressing down arrow in this dialog. While this is not a single keypress, it is much faster than the applications dialog. Below is a link to a Microsoft article on pasting in Excel for more information.

?

?

Rick

?

?

Thanks, I was just wondering if there was one key press e.g. if you do ctrl+v it just paists, if you use shift+f10, you have additional steps.? Just wanted to paist formula’s for example, that is the main one.

?

?

?

In excel;

?

Go to the cell you wish to paste what you copied.

Do shift f10 and wqarrow down to paste special and right arrow to what you wish to do and hit enter.

?

There are many choices.

?

H t h

?

?

Hi friends,

?

just a quick query, you can use ctrl+c and ctrl+v for copy and paist in Microsoft Excel.

I Do quite a lot where I need to use paist special so that I can just copy formulas, I can’t seem to find a shortcut to do this other than using the right windows key, does anyone know a way to do this 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,

*

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,

?

That is fantastic, thanks so much for your help, that is going to make it much easier!

Cut out a lot of the steps and make it just two steps.

It is actually probably better than what I was describing as it does give the alternative options should I need them.

?

Thanks again!

?

?

?

Hello Steven:

?

In Word, you can set the default paste option. See the below link.

?

?

I could not find an equivalent in Microsoft Excel. However, if you press Control+ Alt+v, you will be immediately presented with the paste special dialog and in my copy of Excel (Office 365), paste formulas is the first option when pressing down arrow in this dialog. While this is not a single keypress, it is much faster than the applications dialog. Below is a link to a Microsoft article on pasting in Excel for more information.

?

?

Rick

?

?

Thanks, I was just wondering if there was one key press e.g. if you do ctrl+v it just paists, if you use shift+f10, you have additional steps.? Just wanted to paist formula’s for example, that is the main one.

?

?

?

In excel;

?

Go to the cell you wish to paste what you copied.

Do shift f10 and wqarrow down to paste special and right arrow to what you wish to do and hit enter.

?

There are many choices.

?

H t h

?

?

Hi friends,

?

just a quick query, you can use ctrl+c and ctrl+v for copy and paist in Microsoft Excel.

I Do quite a lot where I need to use paist special so that I can just copy formulas, I can’t seem to find a shortcut to do this other than using the right windows key, does anyone know a way to do this 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,

*

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,

*

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,