excel for mac copies formulas correctly but

Click on the first cell where you want to paste, and press ControlV.

But when it comes to copying and pasting data throughout different parts of the spreadsheet, most users dont realize just how many possibilities there are.

This is because, when you paste formula results, the formula automatically updates relative to the cell youre pasting it into.

You can prevent this from happening and copy only the actual values using a simple trick.

Right-click any of the cells and select Copy from the pop-up menu.

Right-click the first cell in the range where you want to paste the values.

This removes all of the relative formula complexity that happens when you normally copy and paste formula cells in Excel.

Copy Formulas Without Changing References If you want to copy and paste formula cells but keep the formulas, you can do this as well.

The only problem with strictly pasting formulas is that Excel will automatically update all of the referenced cells relative to where youre pasting them.

You can paste the formula cells but keep the original referenced cells in those formulas by following the trick below.

Highlight all of the cells that contain the formulas you want to copy.

Select the Home menu, click on the Find Select icon in the Editing group, and select Replace.

In the Find and Replace window, type in the Find what field, and in the Replace with field.

Select Close. This will convert all formulas to text with the sign at the front.

Copy all of these cells and paste them in the cells where you want to paste them.

Hold down the shift key and highlight all cells in one column.

Then hold down the Control key and select all of the cells in the pasted column.

With all cells still highlighted, repeat the search and replace procedure above.

This time, type in the Find what field, and in the Replace with field.

Select Close. Once the copy and replace is done, both ranges will contain the exact same formulas, without the references shifted.

This procedure may seem like a few extra steps, but its the easiest method to override the updated references in copied formulas.

Avoid Copying Hidden Cells Another common annoyance when copy and pasting in Excel is when hidden cells get in the way when you copy and paste.

If you select and paste those cells, youll see the hidden cell appear in the range where you paste them.

If you only want to copy and paste the visible cells, select the cells.

Then in the Home menu, select Find Select, and then select Go To Special from the dropdown menu.

In the Go To Special window, enable Visible cells only.

Select OK. Now press ControlC to copy the cells.

Excel For Mac Copies Formulas Correctly But