top of page
Image by Jess Bailey

Get finance and accounting tips delivered right to your inbox

4 common ways to paste in Excel

One of the most common functionalities that I use in excel is utilizing the paste feature.

Most people think of a simple Copy & Paste when they hear this…


but there is so much more to it.


Today we’re going to talk about 4 different ways in which I copy and paste data almost anytime I use an excel file


1. PASTE REGULAR


The simplest application of pasting is when you hit Paste, or Control + V

Paste regular
PASTE REGULAR

Here, excel will paste everything tied to the range you copied - IE your formula + values


2. PASTE VALUES


The next most common paste I use is pasting values.


PASTE VALUES
PASTE VALUES

This is especially relevant when I don’t want the formulas or formatting to carry over, or create a circular reference.


I utilize this keyboard shortcut by hitting ALT + H + V + V.


3. PASTE FORMATTING


This one may be my favorite.


Here, you can paste just the formatting on a range, without affecting the values for formulas:


PASTE FORMATTING
PASTE FORMATTING

Here I utilize the keyboard shortcut ALT + H + V + R


4. PASTE AS PICTURE


This one I use all the time when preparing presentations between excel and powerpoint:


PASTE AS PICTURE
PASTE AS PICTURE

Once I paste as a picture, I can then cut that picture, and plop it right into powerpoint.


I utilize the keyboard shortcut ALT + H + V + U



OTHER WAYS TO PASTE


These are just 4 of my favorite ways to paste in excel…but there are countless other options.


To see them all, simply copy something, and hit the down arrow under the paste button on the home ribbon:


OTHER WAYS TO PASTE

You can also hit the Paste Special button to see a list of all options:


Paste special

As you can see, I’m a huge fan of utilizing keyboard shortcuts with these paste options.


You’ll see me talk time and time again about how much more quickly you can move through everything in excel when you master the keyboard.


With these 4 pasting techniques + keyboard shortcuts, you’ll be able to fly through any project.
90 views

Related Posts

See All

Comentarios


bottom of page