Tag Archives: paste

Your First 10 Excel Keyboard Shortcuts (aka The Basics)

Never used a keyboard shortcut? Want to save time in Excel? Here’s where to start:

1. Ctrl+Z   Undo

2. Ctrl+Y   Redo

3. Ctrl+C   Copy

4. Ctrl+V   Paste

5. Ctrl+S   Save

[showmyads]

6. Ctrl+N   New Workbook

7. Ctrl+O   Open

8. Ctrl+F   Find

9. Ctrl+P   Print

10. Ctrl+A   Select All

 

Have you got those down now? Good work, you’re on your way. If you’re ready to learn some more, we’ve got plenty more!

HR Dashboard Tip: Copy & paste chart formatting in Excel 2007

Sometimes you want to show several graphs with the same formatting or brand colours in a single HR management dashboard. After fiddling around selecting the exact design for your first chart you realize you have to remember it all and click through all the same options again. But there is another way!
First you need to click on your first, formatted graph and press CTRL+C to copy it. Then select the new, unformatted graph and press Alt H,V,S,T and then Enter. It may seem a bit long for a shortcut, but if you deal with dashboards regularly it can save a lot of time and ensure that your presentation is consistent. If you really can’t remember the shortcut keys, on the left side of the Home tab you’ll find the Paste dropdown. Select paste special and then formats. You’ll still save time.

Excel Keyboard Shortcuts – Function Keys

More Excel keyboard shortcuts – the Function keys

F1 – Excel Help

F2 – Edit active cell

F3 – Brings up the Paste Name box – allowing you to easily refer to any named ranges

F4 – Repeats the last action (or in a formula cycles through absolute reference options)

F5 – Go To

F6 – Flicks through the worksheet, ribbon, task pane, and zoom controls

F7 – Spell checker

F8 – Toggle Extended Selection – keeps highlighting cells until you switch it off

F9 – Calculate now (on active worksheet)

F10 – Just like pressing Alt

F11 – Create chart – uses range around the active cell

F12 – Save As

A-Z of Control Keyboard Shortcuts for Microsoft Excel

Here’s a list of Excel keyboard shortcuts. Just hold control and press the letter and hey presto! We’ll look at some of them in more detail in other posts, but this gives you a quick summary…

A – Select All

B – Bold

C – Copy

D – Fill down

E – N/A

F – Find

G – Go to

H – Replace

I – Italic

J – N/A

K – Insert hyperlink

L – Create table

M – N/A

N – New workbook

O – Open

P – Print

Q – N/A

R – Fill across

S – Save

T – Create table

U – Underline

V – Paste

W – Close workbook

X – Cut

Y – Redo

Z – Undo