Operating System: Mac OS X 10.6 (Snow Leopard)
How do I align decimals in a word document? I know it has something to do with setting tabs, but I can't seem to get it right when I tried to figure it out myself! Thanks so much.
Why are you trying to "figure it out" for yourself?... That's what Help is
for :-) See the topic: Set tab stops
On 2/7/10 6:37 PM, in article 59bb26da.-1@webcrossing.JaKIaxP2ac0,
"email@example.com" <firstname.lastname@example.org> wrote:
> Version: ...Regrouping large lists into areas based on zip codes
I receive lists of about 200 addresses covering about 40 zip codes. I have
to separate and re-group this list into 7 areas based on zip codes (which
aren't serial, of course). I've considered using IF.THEN..ELSE formulas,
but fear that would be too complex. Does anybody have any simple, elegant
We'd need to know what your 7 classifications are. Assuming, for
instance, that the seven classes are based on the first 3 characters in
the zip code and assuming the zip code is in a cell by itself, you
could use a MID() or LEFT() function to derive just those fi...second axis
How can I use bar graphs for three different products with two axes becuase
of two different sets of info for each product and get the graphs to stop
plotting on top of each other? Please help!!
Jon Peltier has instructions for a column chart on two axes:
carrie in pa wrote:
> How can I use bar graphs for three different products with two axes becuase
> of two different sets of info for each product and get the graphs to stop
> plotting on top of each other? Please help!!
Excel FAQ, Tips &...Surpressing plot of blank cells
I'm creating a line chart plot using Excel 2007. The data range for plot
lines contains some blank cells. These blank cells get plotted as zero
How do I change this behavior to plot only points that have values and to
leave the blank cells unplotted?
I appreciate your help, -John
If they are truly blank then check the plot empty cells setting via.
Select Data > Hidden and Empty cells.
If the Cells in fact contain formula then use NA() instead of "". This will
suppress the data marker but will not break the line.
Alternatively use Autofilter to hide un...Memo and Category Description
Versions later (using ver. 2004) it still bugs me that when you have one (1)
Category you can't have both--a Memo AND a Category Description. For
instance, when I use the ATM and split the transaction I can add a unique
Description for each Category in the split, AS WELL AS a unique Memo field
(that I use to indicate either the name or address of the ATM)....But, when
I only have one (1) Category either the Memo field overrides the Category
Description or the Category Description overrides the Memo field. I can't
imagine why they don't remain different fields for different purposes...Excel will not allow me to change alignment
I have a worksheet in which Excel does not allow me to change the
alignment of a range of cells from, say, left-justified to centered.
I am experienced with Excel/VBA and have not seen this before. The
cells are not protected and do contain numerical data. If I add a
leading apostrophe to the cell values to have them treated as strings,
I can then align the cells however I like. When those cells contain
numerical data, Excel will not allow me to change the alignment from
left-justified, regardless of whether I use a toolbar, the Format tab,
---------------...Secondary Y axis #2
I created a chart with 2 axes: left axis is a line chart and right axis is a
bar chart. Both series have both positive and negative numbers. Problem is
that both have their origin at 0 on the scale, but the 0 on the left axis is
slightly higher than the zero on the right axis. Any ideas?
Have a look at,
Andy Pope, Microsoft MVP - Excel
"chadmh" <email@example.com> wrote in message
>I created a c...Four-up postcards not aligned right
I'm using Publisher 2003 to print postcards four to a page. They are "off"
by about 1/4 inch to the left. This isn't awful for the two postcards on
the left side of the page, but the two on the right side of the page are
How do I fix this problem? I used Publisher's postcard format, 4.25" by
5.5". I've tweaked the postcard size down a bit in Page Setup (to 5.35") in
order to insert a .1" side margin and a .2" gap between the two postcards
(it's called a "horizontal gap," based on a portrait orientation, even ...Different Master Category Lists?
Running OL 2003 Pro SP1 under WinXP Pro.
I have several different .pst files I keep open at once, and would like to
have different, non-overlapping Master Category Lists for each .pst file.
This is because I have created a lot of categories that are specific to each
..pst file, and it would make each .pst file's category list a lot less
cumbersome to wade through if it didn't have all those categories from the
Is there any way I can create separate, non-overlapping category lists for
each .pst file?
The Categories are stored in the registry under the Curre...PivotChart, 2 primary, 1 secondary axis
Hi there, I am trying to get 2 sets of data to appear on the primary axis as
an area chart, and one set of data to appear on the secondary axis as a line
Is this possible?
I can do 1 and 1, but I really need 2 and 1 to show all the information
...Dont have secondary axis option listed in Series Option
I am trying to creat a seconday axis. In Excel 2007 from the Series Options
tab on the Format Data Series prompt, I only have the following options: Gap
depth and Gap width instead of primary and secondary axis. What am I doing
wrong or how do I get these options
Please look at:-
Item number 26.
What follows is said in reference to the above file (called secondary_axis).
Take the following action in EXCEL 2007:-
- click somewhere in one of the blue columns (on chart itself)
- this will place blue circles around those columns
- ...Adding Categories in MS Money Essentials
Just upgraded from MS Money 2005 to MS Essentials and cannot find a way to
add or change category names that appear in the dropdown listing for payees?
For example, I have Dining Out as a category, but would like a separate
category for Coffee (yeah, from Seattle!). Thanks for any help - Will
"Will_Treinen" <WillTreinen@discussions.microsoft.com> wrote in
> Just upgraded from MS Money 2005 to MS Essentials and cannot find a
> way to
> add or change category names that appear in the dropdown list...Align
In a cell, Why are texts aligned to the left and numbers aligned to the right
in MS Excel spreadsheet?
That's the standard for Spreadsheets. Comes in handy when you THINK a cell
houses a number and it's left aligned by default.
"Diana" <Diana@discussions.microsoft.com> wrote in message
> In a cell, Why are texts aligned to the left and numbers aligned to the
> in MS Excel spreadsheet?
microsoft chose this as default to mimic ...Pivot Table macro to set print area and print details of drill down data
I have created a pivot table from a set of data which the user can select
parameters on to specialise the data and then double-click any total to
drill down to the underlying data. I am trying to design it so that a user
will see all of the underlying data but when they print it it will only
print the leftmost 12 columns. I thought I may be able to do this by
creating a macro that captures the double click event, create the drill down
data sheet and then to record the set print area and header footer
information etc. and then stop recording. Then put this macro in users
workbooks so th...Chart axis titles/labels
On a chart i have 3 levels of titles labelling the x
axis. When i try to change the alignment on the
title/labels, only the first level (closest to the axis)
changes, is there a way of changing the next level up and
so forth? am thinking probably through vb?
many thanks ahead
I have an example on my web site for making staggered axis labels:
The technique makes use of a dummy series, which is invisible but which
has data labels attached to the invisible points. You don't want your
labels staggered, but...Budget vs. Spending By Category
Is it possible to categorize expenses to the subcategory level (Leisure:
Books and Magazines), but to run a report showing budgeted amounts vs.
expendatures at the category level? While it can be helpful knowing where
money is going to a more detailed level, the big picture can be much clearer
at the category level. I can stay on track with my budget whether I am
reading or watching movies any given month.
Is this possible? I haven't found it here?
Silver Spring, MD
How can I align text to the bottom of cells in Excel 2007. The bottom text
alignment button places text only in the center.
Make the Cell higher and then look at Center vs. Bottom.
> How can I align text to the bottom of cells in Excel 2007. The bottom text
> alignment button places text only in the center.
...Format Y-axis value ? Urgent
Does anyone know to set the maximum Y-Axis value by using VB6.0
the chart automatically create on excel sheet by using Vb 6.
thanx in advance
In XL, turn on the macro recorder (Tools | Macro > Record new
macro...), change the y-axis scale maximum by hand, and turn off the
recorder. XL will give you the necessary code.
Tushar Mehta, MS MVP -- Excel
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <618E5996-9F31-41BA-8817-EE1F9CCF7E0C@microsoft.com>,
firstname.lastname@example.org...Outlook 2007 Calendar Category Colors...
I have Exchange 2003 with users on outlook 2007. My users are using a VB6
based desktop application where users can schedule appointments on other
users calendars. Now when the appointment is completed in the system, the
system is supposed to change the category on that appointment item in their
own calendar. But it's not doing it.
If I do same on anybody's calendar, it does change the color of the item on
celndar as well as change the text in the appointment item also. I am a
I have tried to change couple of users to domain admins also but still it
does not d...text box won't align middle
I've got a text box in one of my documents, i've set it to middle align (they
all are), but this one doesn't - it looks to me like its top align...
It's got a texture background (the same as the others), and the text is
I've tried setting the margins to 0 and 0.1 (and whatever they were as a
Select the text box, Format, Paragraph, be certain all these settings are
correct. Zero before and after. Could be the text box has some corruption going
on. If you create a new box and paste the text into it, does it work?
Mary Sauer MSFT MV...Commission tax category ?
Is there a way to change the tax category for commission from capital gains
to misc. 2% ? I pay a quarterly advisory fee which I enter as commission,but
it shows up in capital gains vs. the proper schedule.I know I can enter this
from the cash account, but then it isn't reflected in the accounts rate of
return Thanks Alan
In microsoft.public.money, Apothecon wrote:
>Is there a way to change the tax category for commission from capital gains
>to misc. 2% ? I pay a quarterly advisory fee which I enter as commission,but
>it shows up in capital gains vs. the proper schedu...Menu issue: Multi-layer Menu is not aligned properly in IE 8
Running CRM 4 in IE8, when we select a menu that has a submenu and then
select the submenu, the submenu items lay directly over the menu rather than
being shifted slightly to the right. For eample if you are looking at the
account form and then click on the Dynamics round logo in the upper left, the
top item is New with the arrow indicating a submenu. If we click on that
menu item to expose the submenu the submenu lays right on top of the original
menu rather than being off-set slightly to the right so that you can still
see the top level menu items. This seems to only happen IE 8. ...After align right, how go back to no alignment?
Thanks in advance.
I have a column that was left aligned somehow, though I
don't think I did it.
It's filled with numbers, and I want to put it back to
right aligned, so I can do that with the 'align right'
button. Then if I click on a cell in that column,
the 'align right' button will have a blue border around it.
How can I go from a right aligned cell back to a cell
where there is no alignment (no left, middle, or right
Normally cells with numbers are to the right, but
the 'align right' cell is not bordered.
So if I 'align right' th...accounts category
I create some new accounts category and link them to range of accounts ,but
when I try to use them in frx reports I couldn`t find them ,any help?
First, I presume you are using the FRx report mode that is designed to view
quantities. I would rebuild the GL account index in FRx. You can delete any
..g32 files from FRx and the indexes will be rebuilt.
Please let us know if this doesn't solve the problem.
> I create some new accounts category and link them to range of accounts ,but
> when I ...Filling In/Painting In an Area
I have an area on a photo I want to fill in. How do I create the space and
paint it in. It's not a perfect square/circle. I thought there was a spray
or paintbrush tool.
Use an editing program.
www.getpaint.net is free.
Mary Sauer MSFT MVP
"Adriana" <Adriana@discussions.microsoft.com> wrote in message
>I have an area on a photo I want to fill in. How do I create the space and
> paint it in. It's n...