I Used F4

I don’t like spread sheets.  Actually, that’s a lie, I do, I really do.  I just wish I was a capable of using them to their full potential.  Ask me to change the colour of a cell, I can handle that, but Pivot tables? What? Computer says Noooo.

Today I got bored of hitting Insert…Row a million times so I Googled ‘how do I insert multiple rows’.

I cannot believe Microsoft still (after how many years?) hasn’t given us the option to choose how many cells we want to insert.  Why is it only one at a time? Or is it just me…?

Anyway, the internet is full of useful people with useful solutions to boring problems.  From the Productivity Blog at technet a blogger (Suzanne100) provided a good workaround for copying cells and inserting to the location you need them.  There were also some helpful comments.  My favourite and the one I will use the most going forward is to go about it the usual way (right click + insert row), then just hit F4 as many times as you like to repeat the operation.

One of these days I will take some time to learn Excel properly.  Until then I shall probably remain a bit of a muppet:



One thought on “I Used F4

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 )

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