| Poll question |
|
Have you ever had to recover documents when you shut down properly?
|
| User of the Moment |
Viewing profile :: Etoile
Joined: 2163 Days
Posts: 1
Location:
|
|
| Copying values (not formulae) & missing
out the blanks |
Author:
nebstah1 ::
Posted:
Fri Jan 27, 2012 10:19 am
Hi guys,
I'll try to explain my problem clearly:
I have a number of adjacent columns filled with basic formulae (e.g.
=SUM(a1:a5)). The formulae are in rows 1, 21, 41, 61 and so on. The remaining
rows are blank.
I want to copy the values from the rows with formulae and miss out the blank
rows. I'd like to paste these values into a neat table with no blank cells.
I've managed to do this by copying all the columns, pasting special (just text
& numbers), then applying a filter to remove the blanks. This takes a long
time and I'm sure there must be a quicker way to do it.
I'd be very grateful if someone can help,
Thanks,
Ben
|
| Jersey Shore Season 5 Episode 4 |
Author:
yhuawo1 ::
Posted:
Fri Jan 27, 2012 10:16 am
The series' cast has also been credited with introducing unique lexicon and
phrases into American popular culture. The University of Chicago and the
University of Oklahoma are among the educational institutions that have had
classes or conferences about the show. In 2010, the cast of Jersey Shore was
named on Barbara Walters' 10 Most Fascinating People list, and the series has
since been exported to dozens of countries worldwide. It has been announced
that the show will return on January 5, 2012 for season 5.
Jersey Shore Season 5 Episode 4
|
| Vampire Diaries Season 3 Episode 13 |
Author:
yhuawo1 ::
Posted:
Fri Jan 27, 2012 10:16 am
Triangle between the female protagonist Elena Gilbert (Nina Dobrev) and Stefan
(Paul Wesley) and Damon (Ian Somerhalder), all of whom have dark pasts. Later
light is thrown on the mysterious past of the town involving Elena's malevolent
doppelgänger Katherine who seeks revenge against the town, Stefan, Damon, and
Elena. The pilot episode attracted the largest audience of any series premiere
since the network began in 2006.[2] The first season averaged 3.60 million
viewers.
Vampire Diaries Season 3 Episode 13 | Watch Vampire Diaries Season 3 Episode 13 Online
|
|
| Welcome |
Welcome to OOoForum.org, the OpenOffice.org Forum!
Register
|
| Stats |
Our users have posted a total of 374249 articles.
We have 240494 registered users.
The newest registered user is charles37.
In total there are 97 users online:
97 Guests
|
| This site is sponsored by: |
 |
|