wrapping text in powerpoiont chartshow do io wrap text in charts so the wording does not run together
...
making all formulas appear in the cells instead of valuesHi all,
How do I make all the existing formulas in a worksheet appear on it, instead
of the resulting values?
I opened a worksheet that have looks this way, but I don't know how it was
done.
Thanks in advance,
Alejandro
I found it out!
tools/options/view/formulas
Thx!
--
Alejandro Caballero Aste
Ministerio de Econom�a y Finanzas
Direcci�n General de Asuntos de Econom�a
Internacional, Competencia e Inversi�n Privada
Tlf 311-5930 Axo 3536
ecaballero@mef.gob.pe
"Alejandro Caballero Aste" <ecaballero@mef.gob.pe> wrote in message
news:%23qJrSVgVHHA.4796@TK2MSFTNGP05...
Copy cell to a new cell #2In Column B I have certain values which start with GB2 e.g GB2-02210. I would
to like to copy these values and paste it in another cell. I would like to do
this with only values which start with GB2. Many thanks
--
Message posted via http://www.officekb.com
I would use Data>Filter>Autofilter and use custom>begins with...
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
"mohd21uk via OfficeKB.com" <u20517@uwe> wrote in message
news:5ede27c5beb13@uwe...
> In Column B I have certain values ...
Create static text from cell referenceHey everyone...
I have two columns of text which I'm combining in a third column using the
formula (for C1, for example) =A1 & char(10) & B1
This gives me the contents of A1 on a line above the contents of B1 and
works fine.
What I NEED to do is somehow create column C as TEXT, not as a REFERENCED
data from columns A and B. How do I create a cell that contains the actual
TEXT content of another cell instead of a REFERENCE to the other cell?
TIA...
Select all the cells in "C" that have content. R-click them and select
"Copy" then r-click again, sele...
Text Highlighting in Yellow (2000) ???This is a multi-part message in MIME format.
------=_NextPart_000_000B_01C600B3.07A33400
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
People,
Is there a way to highlight text in yellow...in Publisher 2000.
This is such a basic text function...available in *Word* for example...& =
they can't provide this?
Thanks,
mark4man
------=_NextPart_000_000B_01C600B3.07A33400
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transiti...
problem with resizingHi!
I'm writing a MDI application. Child window is splitted in three panes. In
the one pane I've got a FormView with some buttons. How to do, that this
FormView was in the center of a pane (even during resizing )? And the second
problem, how to do, that during resizing, splitters dividing window were
always in the same places?
Please, help me. I would be appreciate.
bart
...
Spellcheck includes reply or forward textI gradually have become aware that Outlook is now including the original
message text in spellcheck when I reply or forward. However, the "Ignore
original message text in reply or forward" option is checked on the Spelling
tab in Options. I'm running Outlook 2003. What's up with this?
Bryan
If you're using the option to prefix plain-text replies with a character
(like >) then the original will get checked
"Bryan L" <blinton.nospam@connellinsurance.nospam.com> wrote in message
news:uxpZHuT5FHA.3908@tk2msftngp13.phx.gbl...
>I gradually ha...
Cell flashingDoes anyone know how to format a cell so it will flash or blink ?
It's possible to do so with code but its a bad idea, you'll find such (bad)
code by searching Google.
There is no built in function like Word in Excel and if you do use such code
the results are usually jumpy and erratic, plus the processor is unavailable
to do anything else until the code is stopped from running, ie the machine
is virtually locked up,
Regards,
Alan.
"Skioregon" <Skioregon@discussions.microsoft.com> wrote in message
news:AD31EA15-BC24-4074-85DA-D826B871EE55@microsoft.com...
> D...
use VLookup to copy more than 1 cellI have been using VLookup in Excel 2003 for some time but I would like to
expand the VLookup results. Instead of just copying one cell to paste as the
result of the formula, can I have VLookup copy and paste a series of cells
from same row of the found item?
Thanks and have a great day!!! :)
You can change the result of the VLOOKUP function by changing the 3rd
arguement in the function, which determines which column from the table to
return.
=VLOOKUP(Find_this,In_this_table,#_of_column_to_return,Closest_Match?)
If you want to copy and paste this and have it adapt/change, u...
Go to cell #Hello all,
Is there a way to force a worksheet to always open in cell A1 regardless of
what cell was active when the worksheet was saved. Sometimes different
people save this worksheet with the cursor resting in different places, so
it's annoying when it opens in some odd blank area. Any help on this is
greatly appreciated.
Thanks,
-S
Hi,
You need to write a macro basically
Private Sub Workbook_Open()
Sheets("Sheet1").Activate
Range("A1")
End Sub
This needs to be put in the ThisWorkbook object of the VBA Editor for your
file.
If this helps, pl...
resizing problemsI am using OpenGL in my MFC app. The problem is when I resize the
window from the left or top border the whole scene of my OpenGL moves
even before my OnPaint event handler is called and when my OnPaint is
called after this it repaints the scene so this produces a flicker. If,
however I resize the window from the right or bottom border this
problem doen't occur. Can anybody please tell me what is happening?
Thank you
...
Printing text and pictures on Office for Mac 2004I am using Office for Mac 2004. When I tried to insert a picture in a
word document and choose text wrap, it looks fine in word format. But
when I clicked print prevview, I cannot see the picture, and I cannot
print it. However, if I just insert a picture, there is no problem.
I cannot use the wizard function to print envelope. I have to set my
page in envelope format, and then type in details.
I must have changed some settings by mistake, because I could do those
things before.
Can anyone help??
Check Word | Preferences | Print, and make sure "drawing objects" is
check...
Counting only active cellsIs there a way to count back a certain number of active cells only (eg. 40
possible cells, only 28 are active), and then enter the lowest number within
that range into a cell?
What defines active?:
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Sac73" <Sac73@discussions.microsoft.com> wrote in message
news:207089F2-80B4-46C8-863D-A639CAD16155@microsoft.com...
> Is there a way to count back a certain number of active cells only (eg. 40
> possible cells, only 28 are active), and then enter the lowest number
within
> that range into a cell?
...
Two formulas in on cell based on two numbers in another cell?Hi,
Not sure this is possible but...I have a cell that has a number range in it
and based on an amount in another cell want to calculate a new range. For
example:
Initial Range: A1 = 10 - 12
Calc Amount: A2 = 5
Final Range: A3 = 50 - 60
I think I can get the results by concatenating two formulas I'm just not
sure how to enter the original numbers (A1) or how to distinguish between the
two in the final formula (A3)
Using Excel 2003. Hope this makes sense. Thanks.
I would put the range in two different cells (eg A1 and B1). Then the
multiplication is easy. If you ...
Sheet change event to return sheet name just leftDoes anyone have any idea how I can get the name of a worksheet that I have
just moved from. So if I am in Sheet1 and move to Sheet2, how do I get a
macro to return Sheet1. In all the Events I have looked at they all return
the name of the sheet that I have moved to not the sheet I have left.
Any help will be gratefully received
--
with kind regards
Spike
We need to remember it. In a standard module:
Public OldSheet As String
Public NewSheet As String
In the worksheet code area of every sheet:
Private Sub Worksheet_Activate()
If IsEmpty(OldSheet) Then
OldShe...
Bitmap resize on same DCI am a little be confused!
I have a custom control with a bitmap inside
I create the bitmap with this code
*************************************************
CClientDC dc(this) ;
if (m_dcGrid.GetSafeHdc() == NULL)
{
m_dcGrid.CreateCompatibleDC(&dc) ;
m_bitmapGrid.CreateCompatibleBitmap(&dc,
m_nClientWidth,m_nClientHeight) ;
m_pbitmapOldGrid = m_dcGrid.SelectObject(&m_bitmapGrid) ;
}
************************************************
and in OnPaint i have:
************************************************
CPaintDC dc(this) ; // device context for painting
CDC memDC ;
CBit...
Show a grid pattern not corresponding to the cell sizesI would like to have a standard grid pattern appear on a spreadsheet that has
varying cell sizes. I would like to place this pattern in a specific area,
even though the cell sizes in this area vary in width. If there is a way to
insert the pattern as an image or object and 'send to back', that would be
fantastic. I'm using Excel 2003 in the Office Professional Edition 2003.
...
CStatic derived dialog and auto-resizeHi,
I would like to add auto-resizing feature to my Cstatic derived control. I
mean when I load a bitmap I would like to adjust size
dynamically.
I tried to SendMessage WM_SIZE but it doesn't work.
>I would like to add auto-resizing feature to my Cstatic derived control. I
>mean when I load a bitmap I would like to adjust size
>dynamically.
>I tried to SendMessage WM_SIZE but it doesn't work.
You can resize a window by using the SetWindowPos or MoveWindow APIs.
Dave
--
MVP VC++ FAQ: http://www.mvps.org/vcfaq
...
coping cell contains to different cellsI am running Excel 2007
If I have 3 words in cell A1 all separated by a blank space, how can I copy
the 1st word to A2, 2nd word to A3, and the 3rd word to cell A4...?
I have a 1,000 rows to do.
Thanks...
Select A1 to A1000, click text to Columns
TK wrote:
> I am running Excel 2007
> If I have 3 words in cell A1 all separated by a blank space, how can I
> copy the 1st word to A2, 2nd word to A3, and the 3rd word to cell A4...?
> I have a 1,000 rows to do.
> Thanks...
You're the best...!
"Bob I" <birelan@yahoo.com> wrote in message ...
show active cellHi
I want to show the contents i the active cell in another cell, fo
example cell A1.
Also when i change active cell.
dalla
--
Message posted from http://www.ExcelForum.com
Hi,
Not sure what you mean exactly. But if you want B1 to always show wha
A1 has, in B1 type ...
=A1
Is that what you're looking for
--
Message posted from http://www.ExcelForum.com
One way:
Put this in the worksheet code module (right-click the worksheet tab and
choose View Code):
Private Sub Worksheet_SelectionChange( _
ByVal Target As Excel.Range)
Range("A1").Value = ...
Enter key moves to cell below current, not to beginning of data entry locationVersion: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel
I have a spreadsheet in which I am entering data, one line at a time, using tab to move to the next cell as I go. At the end of the data set, I hit Enter to return to the beginning of the next line - except Excel is moving me to the first cell directly below the last cell I selected. <br><br>For example, if I add data to cells A1 - D1, then hit Enter, instead of going to A2 as expected I end up in D2. I have no idea why this is happening. It doesn't happen with any new files I open, it's just...
Empty string in query calc returns no resultHi all
I've got a query that isn't returning the result I need.
The query is:
SELECT Str$([QuoteNo])+[SupplementaryID] AS Quote, Quotes.RecordID
FROM Quotes
QuoteNo is always populated, but SupplementaryID isn't, sometimes it's an
empty string.
The data in the table looks like this
QuoteNo SupplementaryID RecordID
1000 1
1000 A 2
1000 B 3
The results I want are:
1000 1
1000A 2
1000B 3
What I get is
...
auto resize text without resizing cell in excel
format|cells|alignment tab|check "shrink to fit"
Ferd wrote:
--
Dave Peterson
...
How do i count the number of conditional formatted cells?I want to count the frequency of a number in a series of numbers possibly
using a count if or lookup function. I wish the total number to be displayed
at the bottom, how can i do this?
Kate
Your subject line reads "count the number of conditional formatted cells".
You would need VBA to count CF cells.
http://www.cpearson.com/excel/CFColors.htm
If the subject was not correct, you could use the FREQUENCY Function to return
the frequency of numbers in a range.
Or COUNTIF to return the total number of times a number apears in a range.
=COUNTIF(A1:A100,34) where 34 is the numbe...
CDialog Problem pulling Text into CStringI have a dialog set up that I simply use to pull a
description to search for. I used the class wizard to set
all of this up.
IDD_TEXT1 (text box)
I assigned the variable... CString m_strText to the
Resource using the wizard. There is no length validation
or anything assigned to it other than "tab stop".
When I try and pull the data all I am getting is the first
byte. I can popluate the text box using the data exchange
and it populates fine. However if I even pull that data
back in I get only the first byte of data.
Any Ideas.... I am stumped.
are you using the UpdateD...