Data entered needs to cover 2 vertical cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Could I please get some help with the following little problem I have?
I need to enter an address that will cover 2 vertical cells while leaving
the cells either side as 2 separate cells.
For example, reading from left to right across the worksheet - 1st 2
vertical cells different company’s name, next cell same delivery address,
(this is the one I want as one cell) 3rd cell telephone numbers separate
cells.
Many thanks in advance.
Kind regards,
Dawn
 
You could "merge" the cells BUT this is NOT advised as it causes problems
when/if you try to analyse your data. You would better be advised to keep
the cells separate.

Why do you want to do this?
 
Hi Dawn,

If your need is only for visual purposes you could
place a Text Box over those two cells.

HTH
Martin
 
Hi Toppers,
Thank you for taking the time to respond to my query.
I will try and explain what I am hoping to achieve with this worksheet.
It is basically a delivery sheet for our driver to know where to deliver our
products to.
Vertical columns have headers with the name of the restaurant, telephone
number, delivery address etc. across the top reading left to right.
The centre section will have the quantity of products ordered and this is
the only section that will be added up using the auto sum function.
What is happening is, our driver delivers orders for two different
restaurants to a third party address. (A courier then takes them to where
they have to go, this is then out of our control)
Because 2 restaurants are using the same courier and they are directly
beneath each other on my worksheet, I thought I could enter the delivery
information in one merged cell instead of putting it in twice.
I have a few of these scattered across different sheets on various days so
it would be helpful to do. I hope all this makes a bit more sense.
Do you think it would be too messy to do in this instance?
Toppers, thanks again and I do appreciate what you all do to help us out
there.
Kind regards
Dawn
 
Hello Martin,
I appreciate you taking time to help me, and yes I tried your suggestion and
it worked perfectly.
Only problem here is I will not be the only person using the worksheet.
Others are not very computer literate (not that I am a genius by any means)
and if I do as you suggest and someone else comes across it, it might cause
confusion. Many thanks all the same.
Gosh, I hope I don’t sound ungrateful because I am very pleased with this
information and I will keep it in mind for future reference you can be sure
of that.
Cheers Dawn
 
Why don't you want the address in those 2 vertical cells?

Is it because it's unappealing, display-wise,
OR
Because you don't want to have to type the address twice?

I can't argue about the first, aesthetic reason, but if it's the second ...
you do realize that a simple, easy to create link will display that first
address in other cells.

If the first address is in C10, and you want the same in C11, just enter
=C10
into C11, and you'll have the address duplicated there.
 
Another option would be to enter the delivery address in each row, and
then use conditional formatting to hide the duplicates.

To copy the entry from the line above, the keyboard shortcut is Ctrl+'
I wouldn't use formulas to link to the address above, because that could
cause problems if you sorted the list.

To add the conditional formatting, assuming the delivery address is in
column B:

Select the cells, from B2, down to the last address (B2 is the active
cell, and its address is in the Name box, to the left of the Formula bar)
On the toolbar, click the dropdown arrow for borders, and click All Borders
Choose Format>Conditional Formatting
From the first dropdown, choose Formula
In the formula box, type: =AND(B2=B1,B2=B3)
Click Format, and select White font colour, and on the Border tab,
remove the top and bottom border, then click OK

Click Add, to create a second condition
From the first dropdown, choose Formula
In the formula box, type: =AND(B2=B1,B2<>B3)
Click Format, and select White font colour, and on the Border tab,
remove the top border, and add sides and bottom border, then click OK

Click Add, to create a third condition
From the first dropdown, choose Formula
In the formula box, type: =AND(B2=B3,B2<>B1)
Click Format, and do not select a font colour, and on the Border tab,
remove the bottom border, and add sides and top border, then click OK
 
Hello to everyone,
Boy, I had no idea this was going to create so much interest let alone the
many and varied ideas.
This is great because it is giving me ideas and help with other things I
want to do down the track.
To try and keep it simple, the reason I wanted to merge the cells and only
put the data in once (in the newly created bigger cell) is that the address
takes up 4 carriage returns and I have only allowed space for 2.
I could increase the size of all the horizontal cells for these two only,
but then it would move everything else down and create another page.
I was trying to avoid having extra pages at this stage.
What I have done for now is, I put the first two lines of the address in the
top cell and the last two in the bottom cell. It is OK but I just thought
merging these two would be easy. Looks like it might not be as simple as I
had thought.
I just thought I would throw this out there and see if anyone has done this
before with any success.
I do appreciate you all for taking the time to offer your knowledge here.
Very many thanks and keep up the great job.
No doubt I will be here in the near future looking for ideas.
Kindest regards
Dawn
 
Back
Top