Two quick Office 2010 tips

21 09 2011

Today’s tips might reflect the kind of project I’m working on. Today I’m going to give two tips on how to work better in Excel 2010 –_-

Tip1

Here is how to make your own keyboard-commands in excel:

1. Find an action you perform a lot but often have to click to access (insert row in my case)

2. Right-click on the command in the ribbon and select “Add to Quick Access Toolbar”. My command landed at spot nr 5 in the list

3. If your command is at place 5 in the list, Alt+5 now performs this command. In my case, Alt+5 inserts a new row.

Tadaa! Effectiveness

 

Tip2

This is more of a forgotten feature than a tip. When working in Office 2010, you have access to something called the Clipboard. This tool allows you to save up to 25 copied texts, images, cells, etc. To open the clipboard, click at the little arrow in the copy menu under the Home ribbon.

image

This might be helpful when performing tasks where you need to paste three different texts or number sequences over and over in a document. Or when you just want to be able to copy-paste without losing your previous snippets.

image

That’s it for today. You’ve been great, tip your waitress!

Advertisements

Actions

Information

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: