Re: Removing empty cells

Removing the blanks would either affect the cells below, or those to the
right. In either case, the data will be inappropriate.
Why do you want to remove the blanks?
--
David Biddulph

"rehaylock" <rehaylock@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:13AD441F-14F9-4D3B-8704-3BFFFDFF6C7F@xxxxxxxxxxxxxxxx
A colleague has a ss with all possible (20) academic subjects across the
top
row and pupils' names down the first column.

Inevitably there are blanks as Sally only does French German and English
whereas Amy does Physics Chemistry and Biology.

How can my colleague remove the blank cells?

I know there's a solution to this, but cannot remember what it is - I had
a
disk crash and lost the file with the solution!!! (I now have proper
back-ups...)

Thanks,

Richard


.

Relevant Pages

  • Re: Global Delete - two questions
    ... I check the Analyses Toolpak and click OK ... Therefore I cannot attempt to execute the rest of your instructions. ... Would there be blanks in other cells as well as just entire rows? ... If a row has some blanks but not the entire row, you could use a macro to find ...
    (microsoft.public.excel.misc)
  • Re: Data Validation
    ... I do not believe I have mis-understood the purpose of 'ignore blanks', ... If the source list is a named range that contains blank cells, ... I don't know why your users are allowed to enter a EUR unless you ...
    (microsoft.public.excel)
  • Re: Help combining multiple columns into one
    ... but doing that little bit extra allows me to select all blanks ... The source sheet (the one that contains all the data spread out over ... even though the cells LOOK blank... ... Vlookup returned a 'false'. ...
    (microsoft.public.excel.misc)
  • RE: Removing blank rows in a worksheet
    ... It won't work if the first & third DATA rows each have 5 contingous cells ... "Louise" wrote: ... > blanks in a data row'. ... >>> A colleague of mine has a report in Excel but somebody else has created it ...
    (microsoft.public.excel.worksheet.functions)
  • Re: SUMIF & MEDIAN with blanks & text
    ... working correctly where blanks exist? ... Empty cells where a criteria is met are being included in the calculation ... you need to add a test in those formulas that makes sure the cells are ... Median Qual it's reporting: 0.00 Median Qual: 2.50 ...
    (microsoft.public.excel.worksheet.functions)
Quantcast