how do you remove a selected cell that is not saved on a clipboard
I need to know how to remove a selected cell that is not saved on a clipboard
and cannot be posted elsewhere in a table
Are we talking about Access or Excel because Access has fields and you
posted your question to the Microsoft Access newsgroup. Scroll a wee bit
further down to get to the Excel newsgroup.
2010 Microsoft MVP (Access)
"I feel I have been denied critical, need to know, information!" - Tremors
"Dee haskins" <Dee email@example.com>...Copy text from cell and paste it in a separate text box (contents to be linked)
With some cells in a colum selected (say 10 selected cells in a
column: contiguous range) I would like a macro to copy the contents of
these cells and paste the contents of each cell in separate text
Now here it comes. The pasted contents in the text field should be
linked to the cell contents, i.e. whenever the cell's contents is
changed, the contents of the text field should reflect this. Is this
Help is much appreciated. Thank you very much in advance.
Again, Detail and before/after examples.
Don Guil...cell referencing from a Combo Box
I'm trying to make the result given in a combo box make data appear i
the cells (or text boxes) to the left and right of the combo box. Th
data being drawn from is a range of cells in a column that is part of
table with the same arrangement as the combo box/cell arrangement.
just want to be able to choose data from that table, and by choosin
one element in a row, have the rest of the row appear around it.
I've been trying to find a formula that will allow a cell to refer t
the result in the combo box, and give its result as the cell dat
adjacent to that given in the combo box, as th...Adding in another conditional format on the same cell
I have a cell containing "conditional format" when 2 weeks before the due
date ...the cell colour changes to "orange"....it turns red when it reaches
the "due date" .....
Now.......i need to add in another condition ....when i add in another
column e.g. "B" and the font colour will change to "yellow" ....i think its
something to do with....if equal to....then it would change to this
colour.... Can someone teach me the formula pls? urgent....thanks everyone....
What exactly are you trying to add as another condit...IF on a range of cells
I am working in Excel 2003 with two lists, dates and prices in columns A and
I am trying to use IF worksheet function to find if any prices in the prices
column match a certain figure (say $24), if a match is found I want to
return a corresponding date from the adjacent column, i.e. column A.
For example, if I am searching for $24 in prices list and it is found in B37
then I want to return the date from A37.
Is it possible? If yes then how? Despite my years of extensive experience
with Excel, I haven't been able to figure that out.
Than...Enter the cell value without leaving the cell
Is there a way to use the keyboard to enter a cell value without exiting the
cell when you press the ENTER key? I use the mouse to click the green check
mark in the formula bar, but I would prefer to use the keyboard to
accomplish the same task.
CRTL - ENTER
"Chris Hedlund" <firstname.lastname@example.org> wrote in message
> Is there a way to use the keyboard to enter a cell value without exiting
> the cell when you press the ENTER key? I use the mouse to click the green
> check mark in the formula bar, bu...AD Security Groups break Authentication
I seem to be having a strange problem with my Active Directory user
We have a Windows 2008 AD domain, with our only domain controller
located at a remote data center. All of our locations have connectivity
to the data center through a private MPLS network, with varying speeds.
Users at my largest office seem to lose the ability to properly
authenticate to AD if they are added to too many security groups. At
first we thought it was a specific group causing the problem, but any
new group will reproduce the issue. There doesn't seem to be any magic
n...Non-breaking hyphen bug or feature?
With Word 12.2.4, I notice that when text with non-breaking hyphens is
copied into a plain-text editor, the hyphens are left out. This is a
problem when a news release is submitted to a Web site, for example, and
the release is displayed without the hyphens.
I guess there is no way around this except not to use non-breaking
What 'text editor' are you using? Some text editors do not support
non-breaking hyphens and even with those which do it may vary depending on
the font being used � not all fonts include the non-breaking hyphen among
...How do I print comments and or Hyperlinks setup in cells in Excel.
we want to be able to print the comments and or hyperlinks, connected to a
particular cell and the data validation information.
For one particular cell?
I'd just copy|paste into notepad and print from there.
Debra Dalgleish/JE McGimpsey have a data|validation documenter available at:
And Debra has a way to extract comments an put them into a word document at:
And for hyperlinks, you could do something like:
Dim myHyperLink As Hyperlink
...Cell Number Format
Is there a way to format a cell's number from 1.2 to 1,200,000? I
know how to format millions to ones but how do I convert from ones to
millions? (I don't want to have to multiply in another cell).
I could be wrong but, suspect there is no way to achieve what you want using
You could use the sheet change event to multiply numbers entered by one
million and format the result as you wish using code below. Just right-click
on the tab of the appropriate worksheet, click view code and paste. Note.
this will multiply value in column C only. You will need to modify ...SUM rows in column if cell in different column is empty
I have a spreadsheet that has many rows of data. I'm trying to get a
total for a column ("G") in a cell ("A2") but only on rows where the
cell in another column ("J") for that row is empty.I tried SUMIF and
couldn't get it to work. Can this be done with some kind of formula?
Any help would be appreciated.
(there's no email, no snail mail, but somewhere should be gmail in my addy)
<email@example.com> wrote in message
news:firstname.lastname@example.org...Summarize project time from different sheets in one without losing references when sorting the cells.
hi I have a a lot of sheets in one excel-file, about 25 upwards , and
in these I fill in the time for each project each person is involved
in. What I want is a sheet with a summary for all the projects. Every
project has a six digit code.
Can I create a formula that searches through the entire project for
example project 440011 and return the value to the sheet where I
summarize all the time?
The problem is that I want the projects to be sorted by the six digit
code but when I sort them in each persons sheet the references in the
summarized sheet will be wrong.
Does anyone understand what ...Excel 2007 noncontiguous cell highlight color=light,light blue. How do I make it darker, or like Excel 2003 ( I'm extremely shade blind-PLZ HELP !! )
I have extreme shade blindness & need massive help. In Excel 2003, if I
select 5 noncontigious cells the last cell retains it's color while the 1st
4 become a darker color, like emerald green, charcoal or something, which I
can see and keep track of which cells I've selected. In Excel 2007 this
color is a blue so light that frankly I can't see it. How do I change this
color(& I guess in Excel 2010 also) back to the way it was in Excel 2003, or
something dark that I can see? Thanks, Dave
For 2007 and Windows XP.......have no idea about other versions of
Excel or ...Possible to enter data in both sides off a diagnal bordered split?
I'm trying to enter data on both sides a cell that has a formatted border
split diagonaly. Is it possible to enter data in both sides off a diagnal
bordered split cell? Color and data.
You can't colour the two sides differently. To make text appear on each
side you could:
Type the heading for the left side
Press Alt+Enter, to create a line break
Type some spaces, then type the right heading
Or, on the Drawing toolbar, select AutoShapes>Lines
Select the Freeform tool, and draw a triangle over each side.
Colour the triangles, and enter the heading text in each.
godwint@charter....Precision as displayed for certain cells only
Is this possible? Precision as displayed is exactly what I need, but only in
certain cells, not the entire sheet like you get when you select the option
under the calculations tab of the options dialog.
I have a bunch of formulae that work on various numbers that result in a
figure that is formatted to currency. Of course, these are rounded to two
decimal places. But, any further calculations on that number are done on the
whole decimal, not the rounded currency value. For example, I have a cell
whose final output in currency is $3.21, and when I multiply that by ten, I
get $320.88 sin...Show average line by series on a line chart
I have a line chart to show actual percentages by month for three different
values I am tracking, I would like to show the average for each item as well
on this chart as a line across the chart so that for each month one can see
if the actual percent is above or below the average for the year, is there a
way to do this easily, I have a cell from the data table that shows overall
year average for each value.
Judy Rose Cohen
Apply this three times:
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Te...On-line Banking
The Royal Bank of Canada (RBC) is not listed as one of the
banking institutions in Money 2004, for Canada, for
on-line banking. Is it listed under some other name?
In microsoft.public.money, mac donald wrote:
>The Royal Bank of Canada (RBC) is not listed as one of the
>banking institutions in Money 2004, for Canada, for
>on-line banking. Is it listed under some other name?
This search will show some past discussions on RBC:
http://groups.google.com/groups?as_q=&num=50&as_scoring=d&hl=en&ie=UTF-8&oe=UTF-8&btnG=Google+Search&as_epq=&as_oq=rbc+roy...suppress duplicate lines
I have an excell sheet with many lines. A sort them on a given criteri
and I would like to supress lines that are duplicates based on thi
criteria. How can I do it easely :confused
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
What doe suppress mean?
If yes, then Chip Pearson has a bunch of techniques for dealing with duplicates
If you mean hide, you should be able to modify some of those techniques, too.
ccd wro...auto adjust height of cells
Operating System: Mac OS X 10.5 (Leopard)
Is there a way to have Excel automatically adjust the height of a cell depending on how much text is in it?
Not the height of a cell, but the height of a row. The height is adjusted
automatically when you increase or decrease font size on any cell in a row
assuming the row's height has not been manually adjusted.
To have the height of the row adjusted automatically based on volume of text
content you need to apply Format> Cells> Alignment - Wrap Text.
I found a very helpfull hint to find formula-cells. The trick is to
use the get.cell function. I would like to learn a little bit more
about that function. What does 48 or 6 mean in get.cell(48;.... or
I can't find documentations at the net ?
Get.Cell(num, cell reference) is a function from XL4 to return information about the formatting, location or contents of a cell.
48... if cells contain a formula it returns True; if a constant it returns False.
6 ... returns the cell formula
Peter Noneley has a free download at...
http://homepage.ntlworld.com/no...Copying and Filling Cell With Functions
I have an Excel page that has refrences to another worksheet ie =May!B2 I
want to create a generic spreadsheet that I can just copy for each month but
when I do I get ='[May Commissions Sheet.xls]May'!B2 is there a way to advoid
this? And also when I try and do a fill instead of trying to copy I get
=May!B3 or I tried typing in cell M2, =May!B2 and in cell M3, =May!C2 and
then tried to do a fill that way for Excel to get an idea of what i was
trying to do and it ends up putting =May!B4 in M4 and =May!C4 in M5 and
=May!B6 in M6 etc. Can anyone help me cause I am about to lose i...Change cell color on update
How do I change a cell's color if it has been modified? I
am sure I Use conditional formatting, but not sure how. I
have a contacts spreadsheet and I need to send it around
to other memebers of my company for them to update, when I
get it back, I need to know what has been modified. How
to do this?
Switch on Track Changes
Complete the dialogue box
Message posted from http://www.ExcelForum.com
Have a look at Tools / Track Changes. This will highlight any changed cells
and what the changes are.
Andy....Stop next cell being selected on Enter
I have a sheet which has only 3 input cells, but only one input cell is
required for a user in a given state. I've disabled the "move selection after
enter" function in tools/option/edit and when they enter a value and press
enter the active cell stays the same - which is what I want.
When I protect the sheet, the active cell jumps to the next unprotected
cell. How can I stop it doing that?
I don't know why Excel reacts this way, but when the worksheet is protected,
make sure that the user is allowed to select both locked and unlocked cells.
They still won't be abl...Carriage return in a text cell
Is it possible to enter a carriage return in a text cell so that two
individual items appear on separate lines when the text is wrapped?
Press Alt and Enter together.
"Opinicus" <email@example.com> wrote in message
> Is it possible to enter a carriage return in a text cell so that two
> individual items appear on separate lines when the text is wrapped?
Alt + Enter
This is one line
Alt + Enter
This is nex...Conditional Format on "Active Cell"
I have a spreadsheet where the rows in Column A are descriptions and Columns
B thru H are Mon thru Fri.
As you arrow down entering dollar amounts by day for each description I
would like the Description is say A44 to bold or change color when the cell
in say H44 is active.
Is this possible?
I'd suggest you take a look at Chip Pearson's RowLiner add-in:
But if you just want to change the color of the cell in column A:
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Dim rArea As Range