0:00
let's look at removing formulas from
0:02
individual cells and also the whole
0:05
worksheet You'll see in this Excel
0:07
worksheet I've got formulas in this
0:09
column and also in this row So the first
0:13
thing we're going to do is remove the
0:15
formulas from either individual cells or
0:17
the whole column So what you need to do
0:19
is select the whole column or an
0:21
individual cell right click hit copy
0:24
right click again in the same area that
0:26
you selected and you want to take past
0:30
special and values You're now left with
0:33
just the values You can use this method
0:35
for rows or columns or individual cells
0:39
If you want to remove all of the
0:40
formulas from your whole worksheet if
0:43
you just navigate to the top left and
0:46
select this area here that'll select
0:49
your whole worksheet And then within the
0:51
area that you've selected again right
0:53
click hit past special and again select
0:57
values This now removes the formulas
1:01
from the whole worksheet
