I want some set of questions on Word-2007 to check competency level of the
user. Please help.
Ananta, please refer to my other 2 postings: just check out the WORD part.
If my comments have helped please hit Yes.
"Ananta Gupta" wrote:
> Hello Everyone,
> I want some set of questions on Word-2007 to check competency level of the
> user. Please help.
> Ananta Gupta
> Ananta, please refer to my other 2 postings: just check out the WOR...Average Line in Bar Graph?
Is there a way to create a line in the bar graph that shows the average of all the results?
Take a look at either of these examples,
> Is there a way to create a line in the bar graph that shows the average of all the results?
...I want more!
I need to extend a form that aleady has some 100 lines. For instance, one
column has the date, but only until tomorroq. How do I create more lines
based on the same formula?
I usually select the last row in the range and copy it down a few rows.
If you're using xl2003, you may want to look at Data|List.
And if you're using xl2007, this feature has transformed into Tables.
(Data tab on the ribbon|Data tools Group|What if Analysis|Data table)
> I need to extend a form that aleady has some 100 lines. For instance, one
> column has the da...How to make a hollow line?
Is there some way to make a line shape hollow?
That is, make it have a border (like a rectangle shape) with a center
that I can change with the fill property?
I want to build various structures that connect at odd angles. Lines
are perfect because thay can be attached to anything at any angle, but
I don't want a solid black line and I don't want a lighter color
without a border.
I tried using a shape (rectangle or oval) but using the rotate tool to
get odd angles is not as convenient as connecting lines.
Using Visio Standard 2002 on Win 2000
Draw your rectangle then r...Ungrouping Excel Graphs
I often copy and and paste graphs from Excel into PPT, then ungroup it to be
able to micromanipulate and change all elements, and make all the various
final touches for presentation.. Is this possible to do in PPT2010? If not it
would be a good feature to add back.
2010 works the same way as 2007.
Cut the chart, paste special as EMF. Ungroup the EMF twice. That will get
you to a lot of parts and pieces, but it won't get you completely there,
because not everything will completely ungroup.
This process was worked fine in 2003, but it was utterly hosed in PPT ...I don't want a page of the same label, I want one of each...
I can't find where to tell Pubisher that I want one of each label and not a
page of each label.
I'm using Publisher 2003 (Office 2003)
I see a post that says to enter "<<Next Record>>" but Publisher doesn't see
this as a field, just as text.
This can't be that hard, but I can't figure it out...
Any help would be appreciated.
I see that it prints correctly, but the print preview displayes it wrong....
I think I have it figured out...
"Kelvin" <firstname.lastname@example.org> wrote in message
news:OSpLwThUIHA.5508@TK2MSFTNGP04.phx....Scatter graph, how do I show overlapping points?
I have a scatter graph with a number of points that over lap. How do I show
them so that the reader can tell there are multiple points.
On Mon, 9 Apr 2007, in microsoft.public.excel.charting,
KieranMoran <KieranMoran@discussions.microsoft.com> said:
>I have a scatter graph with a number of points that over lap. How do I show
>them so that the reader can tell there are multiple points.
a) "Jittering", which is the name for putting a small random variation
in the data to break up the exact values. Obviously you want it to be as
small as possible while still exposing t...need to make 3 fields into 1 field
I have an mail list that has been created with 3 address fields. These
fields need to be consolidated into 1 field. Can this be done.
=a1 & " " & b1 etc
"Georgia" <Georgia@discussions.microsoft.com> wrote in message
> I have an mail list that has been created with 3 address fields. These
> fields need to be consolidated into 1 field. Can this be done.
Most programs that use Adresses like them ...Makeing People Save As
I have an excel spreadsheet on a shared drive at work. When people in the
office open the file, is there a way to make them "save as" and not to be
able to type on the original file?
Thanks for any help in advance!!!
"=?Utf-8?B?RXJpYw==?=" <Eric@discussions.microsoft.com> wrote in
> I have an excel spreadsheet on a shared drive at work. When people in
> the office open the file, is there a way to make them "save as" and
> not to be able to type on the original file?
> Th...EXCEL #20
Can anyone tell me how to change the color of the active
cell in a workbook?
I'm Not quite sure what you are asking. Do you want the color of a cell
to change automatically depending on whether or not a certain condition
is met (conditional format) or do you just simple want to select a cell
and change the background color to something other than white?
Look at the buttons across the top of the Excel Window on the toolbar.
There should be a button that has a small paint can icon on it with a
yellow stripe underneath it. Click there and choose the color you want
to change to. The but...graph, data lables value, dont show zero values
Re: graph, data lables value, dont show zero values
I suppose there's a question somewhere.
It sounds like you need to apply a custom number format. Whatever the format
is now (for example, General or 0.00), use it as the first piece of the
number format, then leave the other out. So the format will look something
More on number formats:
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"Madeleine" <...Text want wrap in text box
I can't get the text to wrap in a text box, word wrap is set to true, I put
some text boxes on a sheet today and the text will not wrap, I did this
yesterday and it worked fine, I can copy the ones from yesterday and paste
them on a new sheet and they work, any ideas? I have rebooted but this did
not help. Using Excel 2000 (9.0.6926 SP3) Thanks Paul B
If you're referring to a Control Toolbat text box make sure that the
MultiLine property is True.
"Paul B" <email@example.com> wrote in message
news:%23ovLUkuLEHA.2456@TK2MSFTNGP12.phx.gbl......I want to add a sound event when the cursor bumps left margin
I want to know (via an event sound) that my cursor movement has bumped the
left edge of the spreadsheet. I am entering thousand of rows of data, and it
would help if there was a event sound when I returned the cursor to the left
edge. I have this feature in 123, and find it helpfull.
Put this in the sheet module:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Static ColOld As Integer
If Target.Column = 1 And ColOld > 1 Then Beep
ColOld = Target.Column
mvpearl omitthisword at verizon period net
"m...How Can I make a cell flash in Excel
I am looking to highlight certain cells in a column of data and would be
helpful to make them flash, as oposed to just standard formatting
flashing would require VBA (using for example the OnTime method).
But I strongky recommend against it:
- slows down Excel
- has IMHO nothing to do with serious spreadsheets
- requires VBA and won't work if macros are disabled
If you still want to go on with this search the Google archives for
> I am looking to highlight certain cells in a column of data and would be
> helpful to make them ...Want to Add more Sub description Field
How I can add more sub description field like 1,2,3,4,5
You have only limit up to 3 fields in RMS 1,2,3 sub-description also you can
use the extended description and there is main description for the item. so
Altogether you have upto 5 description limit and I think that is enough. Let
me know if this won't fulfill your requirements else use the Item Notes for
Rate if like
"Saleem Suri" wrote:
> How I can add more sub description field like 1,2,3,4,5
> Saleem Suri
...Office XP- OUTLOOK: Format toolbar is inactive. Cannot select font, color, underline, italic, etc. This occurs in new message, forward message amd reply message. Tools, Options, Customize, selections
This is the message body. Here you post you issue NOT in th subject line!
Anyway; make sure you are composing a HTML or Rich Text formatted mail. You
can change this under the Format menu in a new message
Microsoft Office and Microsoft Office related News
Also Outlook FAQ, How To's, Downloads and more...
Tip of the month:
-Create your own fully customized Toolbar
Subscribe to the newsletter to receive news and tips & tricks in your
(I changed my reply address; remove all CAPS and _underscores_ from the
address when ma...how do I add in a dinamic graph the total as a new series?
I want to add, in a dinamic graphic, a new series: the mean. Is it possible?
I need it to compare each series with the mean.
Thanks in advance. Regards,
The graph won't calculate the mean for you, so you'll need to calculate the
mean as a new series in your data sheet, and then include that series as a
new series in your graph.
"Guillermo Fuenzalida" <Guillermo Fuenzalida@discussions.microsoft.com>
wrote in message news:117FBACB-4DD2-41CC-864B-632666BE5CD5@microsoft.com...
>I want to add, in a dinamic graphic, a new ser...how can make a mail copy to a group
i using win 2003 , exchange 2003
if have a user mail need forward ( make a copy ) to many users
how can i do this ?
i just know how to make a copy to one copy
On Sat, 12 Mar 2005 01:03:12 +0800, "tequila" <firstname.lastname@example.org>
>i using win 2003 , exchange 2003
>if have a user mail need forward ( make a copy ) to many users
>how can i do this ?
>i just know how to make a copy to one copy
Have you looked at creating a Dirstribution Group within Active
Directory Users & Computers? You can mail enable it and make a number
of...I can't see formatting on my screen for font colors or highlighti.
Why can't I see formatting on my screen for font colors and filling cells
OFF: Changes to Fill Color and Fill Pattern Are Not Displaye�d
Regards Ron de Bruin
"kam347" <email@example.com> wrote in message news:492EDFB8-6199-49E5-9996-F9DE60CE9243@microsoft.com...
> Why can't I see formatting on my screen for font colors and filling cells
> with color?
...Excel wants to create a page break in every cell!
After saving revisions in an Excel worksheet, I get a popup message that
states "Margins do not fit page size". After clicking "ok" (because this is
my only choice) a page break is automatically created in ever cell. At
times(depending on the sizeof the work sheet) it can be over 100 pages with a
page size 14% or smaller.
Why does this happen, and how can I avoid it?
I saw this suggestion in a different forum.
Try closing excel.
Clean up your windows temp folder
Windows start button|Run
and hit enter
Clean all those files that you ca...No fill colors on screen, but prints ok
Publisher 2002 on system with XP and 512K ram, when
creating a brochure the various shapes, etc with color
fill do not show up on screen, only the outline of the
art or shape, but prints out color ok as the produced
Very puzzling when you consider it started out showing
everything as expected on screen but in some mysterious
fashion it began doing this bizarre behavior.
I've already uninstalled and reinstalled suspecting some
sort of corruption. No change. Loaded it on a different
computer and all is well.
Troublesome computer is a Sony Vaio laptop, with a large
WTB: I BUY SOFTWARE - CHECK AROUND - YOU PROBABLY HAVE SOME OF THE
BELOW TO SELL TO ME.
SEE A LIST OF SOME OF THE SOFTWARE THAT I AM BUYING!
I AM BUYING ALL OF THE BELOW. THE MORE QUANTITY THE BETTER!
I am looking to buy large quantities of Windows 7 Professional Upgrade
Dell DVDs with unactivated COAs included in a SEALED package
I am looking to buy quantities of SYMANTEC NORTON ANTI VIRUS, NORTON
INTERNET SECURITY AND 360 OEM AND RETAIL BOXES
I will buy 2010, 2009, 2008, 2007 and 2006.
If you have good quantities setting around and no longer need send me
detai...making '>'s show up in replies?
I am using outlook 2003 and want to have �>' in my replies. The
problem is I can't figure out how to set it up to use those. Any help
would be greatly appreciated!
On 27 Jul 2004 10:59:48 -0700, firstname.lastname@example.org (Gaikokujin
>I am using outlook 2003 and want to have �>' in my replies. The
>problem is I can't figure out how to set it up to use those. Any help
>would be greatly appreciated!
Click on your Tools menu item, then Options...
On that screen's Preferences tab, click on Email Options. The option that
you&...Nulls making a mess!
Ive posted two questions and i cant find them now so heres goes the 3rd:
I have a query and want the blank fields to reflect as zeros. I do this by:
My problem is with this field: TurnoutRate: nz([Total Of
CountOfnumAttended]/[Total Of CountOfnumTrainingSessionID],0)
Its a percentage field so it changes it to a numer from 75% to 0.75 How do
i get it back to PErcentage? When i check the properties it still says
Try this --
TurnoutRate: Format(nz([Total Of CountOfnumAttended]/[Total Of
CountOfnumT...Graphing question #2
How do I extrapolate a graph which do not have a formula for the graph?
At the end of the graph, I found that I don't have enough data and
would want to have a longer graph?
wenlianglo's Profile: http://www.thecodecage.com/forumz/member.php?userid=161
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=71554
You might also consider 1. Adding a Trendline to the chart and then choosing
the trendline and telling it to show forward some number of periods.