How can I fit row heights to the data?
(Already posted to .setup, but no replies so far.)
I have an Excel file with several sheets that are basically glorified
laundry lists; all that's in any given cell is text or a simple number
that I don't need to do any calculations on. (It's information on some
of the abilities available to characters in an RPG I run, if that helps
anyone visualise it.)
Here's the problem: whenever I sort this list or otherwise appreciably
change the order of it, it screws up my row heights. Some rows end up
too small for the text in them while others have huge amounts of white
spac...Margins do not fit page size #2
After many years of excellent services and whatI believe
some expertise in the software, my Excel charts won't show
in "print preview". I get the above error message and a
minuscule page in the center of the screen. all my rows
seem to have turned into pages.
Our Information service experts aren't that good and
Microsoft support was never really that acessible. I run a
virus check, a couple troubleshooting programs and tried to
reinstall Excel. Nothing worked.
Anyone got an idea what to do?
Have you recently changed printers or operating systems? If so, you
should downl...An Inventory order and tracking db for hydraulic fittings
I am starting a new db to track hydraulic fittings and inventory. I want to
do it right, from the start by having it normalized, and not quite sure what
I am doing.
My employer and head office is use to the old part # of the fitting and
wants to use it for billing and organization on the parts shelves, but the
parts have to be ordered using a new # part # because they changed
suppliers. Yes they should use the new #'s but they don't want to and they
sign my pay cheque, so I have to try to keep everyone happy.
Each fitting comes in different sizes, and is going to hav...Access 2007 Fit to Screen or Auto Resize
I have a multiuser form that I would like all the users, regardless, of the
screen resolution they are using, to be able to see on one screen without
having to scroll from side to side or up and down. I have a couple of users
who prefer lower resolutions and my forms are not fitting on their screens.
I have tried to use the "fit to screen" and "auto resize" properties to
achieve this (set them both to "yes") but it doesn't seem to work. I
couldn't find help on the "fit to screen" property. What are these two
properties for? Can I use t...forgot standard password
I forgot my standard password for my Money 2003 file. I
use a windows 2000 OP. I tried tech support but they were
unable to find a way to get me in and recommended I come
here. Please help. thank you
you may wish to try
or some other such application.
"david" <email@example.com> wrote in message
> I forgot my standard password for my Money 2003 file. I
> use a windows 2000 OP. I tried tech support but they were
> unable to find a way to get me in and recommended I come...How can I print form data in a standard letter
I have a Access2002sp3 database. Data is input via a form into a table and
sometimes (at the time of input) we need to print the data out in a standard
letter format (basically like a mail merge with a standard letter template
and data coming from the single record in the table). So far we've been
doing it by exporting the whole table to Excel and then doing a mail merge
selecting only the records that we want printed. Very tedious !!! Is there
some way I can put the standard letter into an Access report and then just
click on a control button on the input form to print the p...Request Standard Mark
Please add the Standard Mark as a symbol we could insert in Office products.
I can do Trademarks and Registration Marks easily, but I have to type "SM"
and then put it in superscript.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.micr...curved lines with publisher 03
I am making a publication that has a white line (3 pts) going from left to
the center of the publication, cuving down 90 degrees, traveling down several
inches and then turning curving 90 degrees to the right and traveling off the
page. It isn't a s curve because the lines (other than the curve part) travel
horizontal and vertical. The only way I could figure to do it was to make a
large white rounded corner rectangle with no fill (3pts), converting it to a
picture and combining two of them cropped to make the shape. My problem is
that when I make it big like I want, the curved part...word email editor standard & advanced toolbars missing
Everytime I close Outlook and then reopen it and want to
reply or create a new email, the Standard and advanced
word toolbars dissapear and I have to add them back.
Anybody got a clue?
Try renaming your outcmd.dat file to outcmd.old while Outlook is closed.
Outlook will rebuild the default toolbars the next time you open it. If
your changes to the toolbars "stick" after doing this, then you know it was
the outcmd.dat file causing the problem. Make sure to make a backup of the
new outcmd.dat file so you can restore it if you ever run into the same
...Does the upgrade from 5.5 standard to 5.5 enterprise lose connector config
Help, in one hour we are forced to upgrade from Exchange
5.5 standard to Exchange 5.5 enterprise. Will the upgrade
erase our connectors configurations?
any advice is very appreciated,
It should not change any of your configs. All it should do
is remove the 16g limit and if I remember give you the
ability to add x400. If you can I would back up your priv,
pub and dir first.
>Help, in one hour we are forced to upgrade from Exchange
>5.5 standard to Exchange 5.5 enterprise. Will the
>erase our connectors configurations?
>...Editing Standard CRM 3.0 Reports
I am keen to know if i can edit the inbuilt crm reports. i can find the rdl
files but not the sln files so they can be edited in visual studio 2005. can
someone please advise me how to go about this?
Yes, the inbuilt CRM reports are available for customization. You need to
export the report file. The reports of CRM are built using SRS Reporting
services. So once you have the .rdl files with you can create a new Business
Intelligence Report project and add the .rdl to the project. You can now
Also if you want you can open the .rdl file in ...Standards on the toolbar...
I have a strong preference for using "good practice", if not "best
practice" when it comes to coding my HTML. I've largely beaten
FrontPage 2003 into submission; the code that it generates for me is
pretty close to standards-conformant, and I even tend to avoid
deprecated usages. I am also very much in favor of using
semantic-oriented tags in preference to presentation-oriented tags, and
apply presentation elements via CSS.
One of the things I have to do to achieve this is use FORMAT > FONT to
select the checkboxes for STRONG or EMPHASIS, instead of using...MIssing Standard Crystal Reports
not found on File Repository Server.
This is after trying to view any report from the CRM
Crystal Report Viewer.
How can i get the reports back?
are these standard reports or ones that you have built?
sounds like your crystal database is corrupted. You may have to republish
your reports. Also make sure you have all crystal services started.
"firstname.lastname@example.org" <email@example.com> wrote in
> File frs://Input/a_186/000/000/186/17b...Fit To Page...
We have a user running Excel 2003 that has the foollowing problem...
When she clicks on FIT TO PAGE and previews the page, the page is extremely
small (1.5" x 1", can't zoom or anything) and it appears to only be one
little page per cell.
Can anyone help with this problem?
I'd suggest that the user select the range to print and then use File, Print
Area, Set Print Area. Otherwise Excel will default to printing the entire
used range of the worksheet, which seems to be much larger than the visible
data in this case.
"Dave" <...How do I shrink to fit while printing in publisher?
I am creating a calendar that prints to 11 x 17 paper. I would like to be
able to utilize the same creation on 8 1/2 x 11 paper if I can find a way to
shrink to fit on the paper for publisher. Any ideas?
First change all the text to "Best fit".
Now change the work area to 8�"x11" the click on a corner and move.
"GCSimoSr" <GCSimoSr@discussions.microsoft.com> wrote in message
>I am creating a calendar that prints to 11 x 17 paper. ...Plotting parametric curves
Can I use the Excel chart facility to plot a parametric curve?
For example, the parametric equation for a circle is x=cos(t), y=sin(t).
I have a column for vaious t values from 0 to pi, and computed columns for
=cos(t) and =sin(t).
Now how do I graph that within Excel?
That worked fine. It is almost what I was trying to acheive.
I had orginally hilighted all three columns, hoping that the graph would
contain the x,y points, and also the t values (either as axis labels or plot
area labels). But, alas, all I got were sine and cosine graphs.
Your method works ok for m...Reinstalling Office 2007 Standard
I was having problems with my Office 2007 Standard so I wanted to uninstall
it then reinstall it. I have not been able to reinstall it because of this
error. I also have Windows Vista Home and I have a 64 bit system. I went to
the registry key and added an everyone user and gave it full control but to
no avail. I also reverted back to IE7 but that didn't help. Any help would be
Error 1402.Setup cannot open the registry key
Explorer\Main\FeatureControl\FEATURE_RESTRICT_ACTIVEXINSTALL. Verify that
you have suf...Bug Report: Money Standard 2002
I am using Money Standard 2002.
I last downloaded Internet Updates on 11/14/03.
In my Bills & Deposits list, I have a recurring
transaction set up to pay my credit card bill. It is
configured as a recurring direct debit from my checking
account to my credit card account. When the monthly
reminder comes up, I go to Manage Bills & Deposits and
click Enter into Register.
Bug: Even though the transaction is correctly configured
as being FROM my checking account and TO my credit card
account, for at least the last two months, when I enter
the transaction, it instead crea...Inventory Item
I am trying to go through the documentation for every module in GP to get a
better understanding for its all aspcets. some terminolgies creating
confusion to me like the following:
in Inventory: Standard Cost vs Current Cost. what is the exact difference?
how they are affected by the actual cost being used during the purchasing?
The Current Cost is the actual cost updated on all inventory transactions
and the Standard Cost should be manually entered.
The usage for both fields is mainly in Pricelist, since the item price maybe
based on percentage of the current or ac...fitting spreadsheet to page for printing
I am doing the expenditure for my accounts 2003-2004 (yes I know Iam leaving
it late) and have got 22 columns and 23 rows, I am using Arial 10pt, Is
there a way to get the whole spreadsheet to fit on one page and still be
readable or how do I spread it across several sheets and make it readable? I
want it to be in gridlines with a heading Expediture, I would be very
grateful if anyone could help.
you can specify to how many pages you want your spreadsheet to fit on
use print preview to see how it looks
modify if necessary after printiing if its not readable
us...Condtional Formatting and Standard Deviation
Trying to ascertain if there is a bug in Excel 2007, or I'm misinterpreting
how "Conditional Formatting" works.
In short, I have a series of investment returns where I want to check for
outliers beyond two and three standard deviations. I used the "Conditional
Formatting" style box, and highlighted the cells appropriately.
For one population, the mean is 2.55 with a standard deviation of .73 Thus,
when I'm checking for +/- two standard deviations, values less than 1.09
(2.55 - 2*.73) and greater than 4.01 (2.55 + 2*.73) should show up with their
...best way to get tight fit?
Is there a way to automate getting a tight fit vertically? In some
cases, my longest column is in column x, sometimes in column y. Is
there an alternative to hand-adjusting each row?
Try selecting all columns, Format > Column > Autofi
Paul Sheppard's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2478
View this thread: http://www.excelforum.com/showthread.php?threadid=39469
I'm trying to find instructions to do a bell curve on
Excel and can't locate them. Does anyone have this?
Tushar Mehta has this on his web site, http://tushar-mehta.com. Check
the list of features on the left side of the screen.
Jon Peltier, Microsoft Excel MVP
Melanie Gallegos wrote:
> I'm trying to find instructions to do a bell curve on
> Excel and can't locate them. Does anyone have this?
...Can I get Excel to draw a line of best fit?
Is there a way to get Excel to draw a line of best fit?
Read Help on the following: trendline, slope, intercept, linest, logest
Then come back with more detailed question.
Bernard V Liengme
remove caps from email
"ronel" <firstname.lastname@example.org> wrote in message
> Is there a way to get Excel to draw a line of best fit?
Your answer led me to the solution of my problem.
"Bernard Liengme" wrote:
> Read Help on the f...Exchange 2000 Standard and Enterprise in the same Routing Group
I have two Exchange 2000 Standard servers, one in Arizona and another in
Utah, both are part of the same Routing Group, all my incoming email hits the
Arizona server first, and then it gets routed to the Utah server.
I have started to hit the 16 GB database limit on the Utah server, I already
deleted mailboxes, and ran the Eseutil /d utility to defragment the database,
but I am still around 15 GB.
I am looking to upgrade to Enterprise 2000, but I only want to do the Utah
server. Is this possible? Or do I need to upgrade both servers to 2000
No issues with this. You can upgr...