b3ta.com qotw
You are not logged in. Login or Signup
Home » Question of the Week » Off Topic » Post 1519566 | Search
This is a question Off Topic

Are you a QOTWer? Do you want to start a thread that isn't a direct answer to the current QOTW? Then this place, gentle poster, is your friend.

(I helped save b3ta! rob, Sun 1 Apr 2001, 1:00)
Pages: Latest, 836, 835, 834, 833, 832, ... 1

« Go Back | See The Full Thread

Excel question
how do I delete the contents of some cells, but leave the formula behind? kthx
(I helped save b3ta! Naked Ape call me Caitlyn, Thu 2 Feb 2012, 15:34, 5 replies, latest was 14 years ago)
CALL CHOMPYMAN!

(Bazongaloid, Thu 2 Feb 2012, 15:34, Reply)
The formula that's in the cells?
Or are these formulas referring to the cells you're deleting?
(I helped save b3ta! Agnostic Antichrist Baltimora, Thu 2 Feb 2012, 15:36, Reply)
formulas in the cells
I want to copy a row down and retain the formulas but not the current values
(I helped save b3ta! Naked Ape call me Caitlyn, Thu 2 Feb 2012, 15:37, Reply)
Just normal copy and paste should update the formulas accordingly

(I helped save b3ta! sporters I’m sincerely gratitude to you, Thu 2 Feb 2012, 15:38, Reply)
Hightlight the formula and the row below, CTRL+D will copy the formulas down

(I helped save b3ta! Agnostic Antichrist Baltimora, Thu 2 Feb 2012, 15:38, Reply)
There's a little black square in the bottom right of a highlighted cell
drag it down.

you downs.
(PsychoChomp, Thu 2 Feb 2012, 15:39, Reply)
yes i know all of this...
did it by hand
(I helped save b3ta! Naked Ape call me Caitlyn, Thu 2 Feb 2012, 15:42, Reply)
Enough of your masturbation talk
Now sort your Excel out
(I helped save b3ta! sporters I’m sincerely gratitude to you, Thu 2 Feb 2012, 15:43, Reply)
find your internal NakedApe OS, click file>delete OS
then reboot
(Quintno EXPERIMENT RUINED CANCELLED, LEFT 4EVER, Thu 2 Feb 2012, 15:41, Reply)
If the cells contain formula they should automatically update from the source data

(I helped save b3ta! sporters I’m sincerely gratitude to you, Thu 2 Feb 2012, 15:37, Reply)
Open your worksheet.
Highlight the cells you want to change.
Press "Delete".
Kick yourself for taking advice from anyone on here.
(I helped save b3ta! crackhouseceilidhband Fuck off back to Mumsnet, Thu 2 Feb 2012, 15:37, Reply)
Why do you need to do that?
Just recalculate.
(PsychoChomp, Thu 2 Feb 2012, 15:39, Reply)
Done it all now

(I helped save b3ta! Naked Ape call me Caitlyn, Thu 2 Feb 2012, 15:41, Reply)
Aren't you clever?

(PsychoChomp, Thu 2 Feb 2012, 15:46, Reply)
yep, I'd like some sort of online medal validation please

(I helped save b3ta! Naked Ape call me Caitlyn, Thu 2 Feb 2012, 15:47, Reply)


(I helped save b3ta! sporters I’m sincerely gratitude to you, Thu 2 Feb 2012, 15:48, Reply)

« Go Back | See The Full Thread

Pages: Latest, 836, 835, 834, 833, 832, ... 1