Yet again, let me admit that I am a learning lad: always willing to learn something new! Today I came across the use of the Shift F9 combination to make copying and pasting a little bit easier. I will walk you through the process.

Imagine I am setting up a Production of Sales Budget or schedule and I want to copy it somewhere … for demonstration I am copying the schedule and pasting it immediately below!

In cell A11 enter =A5 and drag that down to A15.


Highlight the range A11:A15 press <Ctrl>+C



Select the range A11:M15 and press Enter



Now press <Shift>+F9



Now use the format painter to format you new output:




Ta daa!

This is a small example and to some extent not worth learning! Think bigger and this method could save you a lot of time

Duncan Williamson


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: