b3ta.com qotw
You are not logged in. Login or Signup
Home » Question of the Week » Off Topic » Post 1461988 | 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.

(, Sun 1 Apr 2001, 1:00)
Pages: Latest, 836, 835, 834, 833, 832, ... 1

« Go Back | See The Full Thread

I hope that makes sense

(, Wed 7 Dec 2011, 14:22, 1 reply, 12 years ago)
can I be honest

(, Wed 7 Dec 2011, 14:23, Reply)
If you'd like

(, Wed 7 Dec 2011, 14:24, Reply)
no, not really...

(, Wed 7 Dec 2011, 14:24, Reply)

Basically it sets a placeholder next to each row. So Row 1 will be called 1, row two will be called 7, row three 13.
Then instead of inserting blank rows you label a bunch of spare rows at the bottom of your document. So the first five rows at the bottom will be called 2,3,4,5&6 the next 8,9,10,11&12. That way you can sort it based on the placeholder column and the blank rows slot in.
(, Wed 7 Dec 2011, 14:27, Reply)
That makes much more sense, it is though abit of a bodge I'd suggest
I'm surprised that there isn't a "proper" way
(, Wed 7 Dec 2011, 14:35, Reply)
It is a bodge, but spreadsheets aren't designed to have blank rows.

(, Wed 7 Dec 2011, 14:37, Reply)

« Go Back | See The Full Thread

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