display content of merged cells
How can I display the content of merged cells in the adiacent empty cells?
e.g. if I put some long unwrapped text in A1 I can see it in A2 and A3,as
long as they are empty; but if I merge A1 and A2 i cannot see anymore the
extra text in A3 even if empty.
Thank you for any help!
Sounds like another good reason for not merging cells. The archives of this
group have countless other reasons.
> How can I display the content of merged cells in the adiacent empty
> cells? e.g. if I put some long unwrapped text in A1 I can see it in
> ...Formatting for Answers to Questions
I am sending out a questionnaire. Different people will provide different
lengths of answers. How do I create a form that will expand if required.
Use a text form field--you can even set the maximum length. More precise
instructions would depend on what version of Word you're using. In Word
2007, you'd use a legacy text form field, which is available in the
Developer tab (Word Options, Popular, Show Developer Tab). Use the Legacy
Tools button to choose Text Form Field. This presumes that you're going to
use this as a protected form in which the only place for text ent...Excel VBA / Data Sorting / Maniputaltion
i have a long list, which i imported from other data base.
The problem is:
1. In each cell, besides data (data is in alphabates) there are som
numeric characters which i dont want .
How can i get rid of all those unwanted numbers from data, from all th
2. The data is in every second row, ie. one row is empty.
How can i Delete those empty/blank rows from the list
Message posted from http://www.ExcelForum.com
1. I think we will need to see a sample of your data
2. Sort the data
Message posted from http://www.ExcelForum.com
I am sending the sample data file...
...Sorting with merged cells in the worksheet
I've got a spreadsheet which has a section (A24:J42) that has six columns.
Columns B-F have been merged in this data section, but not so in A1:J23. When
I try sorting the data section I am only presented with columns (as a whole)
to sort. Obviously, I'm getting the message "merged cells must be identical
I've looked through past postings about this, and done some Internet
searching, and the best I can find is how to unmerge the merged cells and the
sort will work.
Yup! It works just fine, but the problem is my data section in columns B-F
contain...Linking axes scale values to cells
For almost any type of chart the auto scale functions work fine. For OHLC
stock charts however the auto scale always sets the minimum scale value to
zero. If plotting a high priced stock, the chart is compressed into a small
area at the top of the chart rendering it useless. If fixed values are used
they must be constently reset as the stock price changes in order to avoid
having the bars walk off the chart area. I can search the data with
MAX(range) and MIN(range) in order to pick out the upper and lower limits
IS THERE ANY WAY TO LINK THE AXES SCALE VALUES TO THE CELL...Can Excel email someone when a cell goes + or
So sort of like Conditional formatting where it changes colour - instead it
adds rules to send an automatic email... Is this reaching for the stars?
Start here Reload Internet
Regards Ron de Bruin
"Reload Internet" <Reload Internet@discussions.microsoft.com> wrote in message
> So sort of like Conditional formatting where it changes colour - instead it
> adds rules to send an automatic email... Is this reaching for the stars?
I bet VBA...delete cell that doesn't contain a specific word
I'm trying to delete a cell in excel if the content of the cell doesn't
have a specific word. For example if I only wanted cells if it
contained the word 'John' in it.
Then the cell: I love excel - would be deleted but the cell: I love
excel more than John - would not be deleted.
I'm sure it's probably a simple solution but I'm not really sure how to
Any help would be much appreciated.
Try this on a spare copy of the sheet
Assuming the text cells are all in col A
Select the range, then do a Data > Filter > Autofilter
In the autofilter dr...=(IF(ISTEXT('Data Report'!$L2:$L4),'Data Report'!N3,J11)) Response
I have 3 cells that may or may not contain text my statement is the following:
=(IF(ISTEXT('Data Report'!$L2:$L4),'Data Report'!N3,J11)). What I need to
happen is to have N3 posted in the cell of this formula if any of the three
cells have text in them. I feel I am close but not quite there. The
response I get is works only if all L2:L4 is FALSE,FALSE,FALSE or TRUE,TRUE,
Help is appreciated.
> I have 3 cells that may or may not contain text my stateme...Seeing blank fields
In a report there is a field that has values in about half the records. I
want the report to show either a bottom line border or a border around the
whole field only when the field is blank. Can this be done? If so, how?
On Mon, 11 Feb 2008 06:01:48 -0500, "OldManEd" <firstname.lastname@example.org>
>In a report there is a field that has values in about half the records. I
>want the report to show either a bottom line border or a border around the
>whole field only when the field is blank. Can this be done? If so, how?
Try something like this in ...adding 1 to each following cells with a prefix
How do I automate the editing in situation such as the column content
There is prefix M00 but the cells of the rest is plus one from the
first. If it's just numbers, I know =A1 + 1 and copy-and-paste would
do it but it won't work with a prefix.
Thanks for the help,
Put M001 in your first cell, select that cell and then click on the small
black square in the bottom right corner of that cell's border and drag it
down as far as you want... Excel will automatically increment the number
part for you.
Rick (MVP - Excel)
"cpliu" <spamfreeli...Changing Calender Format
I am new to Outlook 2007. The bubbles around the appointments in the the
on-screen month version of the day/week/month view consume a lot of space. at
the default 8 point font, 3 appointments are the maximun that will show up on
within the box for a day. The 2003 format (without bubbles) allowed more
appointments to show for the same screen space.
Does anyone know how to turn the bubbles off?
...How can I paste a table of data into Excel from a MSIE / web browser?
Is there any way to paste out of a table on a web page,
*straight* into msExcel2002, but without taking microsoft all the
friggin Micro$oft formatting with it.
I just want the data, but I also want the table
Copying out of Firefox into Excel and table structure
is lost - it just splurges out in a single line; and copying out of
MSIE (latest) and either all sorts of formatting comes with it, or the
table structure is lost.
So at present I paste out of MSIE into Excel, save as tab-delimited
text. Close. Re-open. Have to scroll down to find the correct format
out of drop-down li...Populating data from one CRM field to another. (CRM 3.0)
I have a custom field in Accounts. This field is called "discount" and it
holds a number from 0-100.
I have created a matching feild in Opportunities. When ever some one opens
an Opportunity I want the discount field to be populated with the value from
the discount field from the Account that the Opportunity belongs to.
I have some ideas but I know I need a lot of help. For starters I figured I
would use an OnLoad from Opportunities to check the Discount field from the
Account and make opportunity discount field equal that value.
crmForm.all.CFCRevSoftwareNet.DataValu...Macro to Delete Blanks in Col and Move Remainder of Range Up
Win7 and Excel 2007 with ASAP Utilities
Named range in a column with data filled by Paste-Special-Values and
sorted A-Z by a Macro.
All cells are text. Some cells are blank and sort to the top of the range.
I would like to delete the blank cells and have the remaining values
moved up but cannot write the required Macro.
Any suggestions would be appreciated.
Try recording it and if you still can't get it post back with ALL of your
Microsoft MVP Excel
"Zaidy036" <ericNOSPAM@bloch.com...How to start the cell edit by keyboard
I have the simple question about the excel. Let's suppose I have the
cell with the text in excel worksheet. I need to edit this text inside
the cell. Currently I have to double-click by the mouse to get the
cursor into this cell to edit it. Please, is there any hotkey which
enables to make the same by keyboard only.
Thanks in advance
"Petr Both" <email@example.com> wrote in message
> Hi everybody,
> I have the simple question about the excel. Let's suppose I have the
> cell with ...MAXIMUM NUMBERS IN CELL
When entering more than 15 numbers in a cell, Exel automatically changes the
integers after 15 to a zero.
Example: 123456789123456789 entered into cell returns
Is there any way around this?
Excel supports only 15 digits, but if you don't want to do any calculations
on these numbers, then you can enter them as strings. A preceding ' will
convert numbers to string. e.g.
is treated as a text string.
Message posted via http://www.officekb.com
...Need help with cells
I need help. I want to be able to type in a numberin cell A1 and the
description to appear on cell B1. Just by typing the number.
Look in the Excel help for the Vlookup command. You will need to have a
table of the numbers with their descriptions saved somewhere.
"mariflor" <firstname.lastname@example.org> wrote in message
>I need help. I want to be able to type in a numberin cell A1 and the
> description to appear on cell B1. Just by typing the number.
> thank you
I can't seem to ge...Data is lost...XP
I got excel file from mail.This file use second excel file
to get some data . When I open excel file that I got, I
can see data but XP ask me do you want tu update or
not ,When I select one of them,some of my data is lost ...
On the orther side ,When try same thing in office97 , ask
me yes no, When I select yes or no,I can see data in excel
file I got from mail. What is problem in XP ?
I need help this is a bug ?????????????????????????
...USING EDIT FIND to locate cell references
If I put various cell references inside a formula, is there an easy wa
to find the reference without going into each and every cell. Fo
example if cell C6 is "=IF(ISERROR(T9/Q9),"",T9/Q9)" and I want to fin
all references to T9 can I somehow convert cell C6 to be say the text o
the formula and then do a Edit Find on all cells in the worksheet?
I hope that i explained myself. Thanks
Ron Wilson's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2729
View this thre...Formula help, compare amount in two cells
Thanks in advance for any help:
I want to compare the amounts in two separate columns. If
the amount in cell c4 is less than the amount in cell c6,
then subtract c4 from c6 and put the result in c5 and
color it red.
I know this is simple but I just can't get it to work.
Any help is really appreciated.
In C5 put
Then click on C5 and do Format > Conditional Format > Formula Is > =$C$5>0
and select Format > Patterns > and select Red color > OK > OK
Vaya con Dios,
"29kilo" <email@example.com...Using cell value in range reference
I have a value of 20 in cell A1, how can I use this value in a formula.
E.g. COUNTA("D11:D" & A1) - (I feel it should be similar to this )
Microsoft MVP Excel
"Sandy" <sandy_stephen@DELETEhotmail.com> wrote in message
>I have a value of 20 in cell A1, how can I use this value in a formula.
> E.g. COUNTA("D11:D" & A1) - (I feel it should be similar to this )
> ...Calendar and Data Entry
I need to build a dynamic calendar (by month) for employees (changing) in
which they will enter different codes (Vacation, Illness, Training, etc).
Can anyone please help on getting started? Is MS Access the best tool?
Thanks a lot.
There are literally dozens of them. You can start with mine which is an
Access form that works (with conversion as required) in any version of
There are some on Stephen Lebans site:
and the Access Web:
http://www.mvps.org/access/forms/frm0052.h...Pulling data into Extender Window
We recently set up an Entender window in the AR Customer Master to capture
additional information that we need for reporting. The information is
currently in several of the GP Fields such as Country Code, Comment2, etc.
We would like to somehow integrate the information that is currently in those
fields into the Extender Fields so that we don't have to re-key information
on over 1,000 customers. Is there a way to do this??
To do it within GP, you would need to export the data and then import it
using the Extender import tool.
To do it outside of GP would require the followi...cells within cell
In an existing worksheet I have cells hemmed in, not able to add additional
rows or columns. I need 4 more cells in the column but do not have room to
Is there a way to click on a single cell that pops-up a mini-column of 4
cells? I would want numbers inserted in the pop-cells to be summed into the
An example would be if I clicked on B2, a mini-column with four cells would
pop-up. When I add numbers to the pop-up mini-column, those numbers would
sum in B2.
You can't have a "mini-column" but one workaround might be:
Insert a secon...Get column of named cell
I have a named cell - StaffHeader1 - I want to refernce just the Column
property of this cell in another piece of vba - how do I do that ?
So in my code I am going to do this;
iColumn = Column(StaffHeader1)
Sheet6.Cells(3, iColumn + 1).Value = iStaffName
Any help appreciated
Check your other post.
> I have a named cell - StaffHeader1 - I want to refernce just the Column
> property of this cell in another piece of vba - how do I do that ?
> So in my code I am going to do this;
> iColumn = Column(StaffHeader1)