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.

shift_f9_1

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

shift_f9_2

 

Select the range A11:M15 and press Enter

shift_f9_3

 

Now press <Shift>+F9

shift_f9_4

 

Now use the format painter to format you new output:

 

shift_f9_5

 

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: