Vertical Indent in Excel 2002
Please help me to create Vertical Indent in Excel 2000 or 2002
because the border line are very near to the text given in a table, it looks
very congested in the gap between lines and text when we use auto fit to rows
there is any solution for this
please help me i want to know the option.
No such feature as Vertical Indent.
You can use Alt + Enter to provide a line feed at top and bottom of cell.
Select a cell then hit Alt + Enter
Type the text you need then hit Alt + Enter then Enter.
This will give you a blank line at top and bottom.
Gord Dibben MS Exc...excel columns keep changing size
I have a spreadsheet that I want to print on legal sized paper. I have
5 columns that I want to be as wide as possible and fit on the paper,
landscape format. Every time I try to change the font size of the
text, excel automatically changes the columns size. ALso, even though
it says that the font is 48 points, it shows up as very tiny on the
screen and also on paper. What is going on?
Check your pages set up settings.
Go to sheet in page set up and check to see if the print area is empty
this could have a range in it. If it does and this is too large for th
paper you are using then it wi...Excel Formatted Spreadsheet To SQL ?
Is there any reasonably straightforward way to convert an Excel
spreadsheet, or part of one, to a format that SQL would accept ?
Usually the method that works is to save the worksheet in CSV format.
Then import the CSV format into your database. Access will import CSV
and so wil a number of other databases.
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=196450
http://www.the...missing excel VBA help file
I'm missing the excel 97 VBA help file "VEenUl3.hlp". I assume this file
is on the software distribution pack that came with my computer. If it is
do I reinstall excel or can I just copy the help file from the distribution
Finally I may not have the distribution pack since I've moved three times in
the five years since the computer was purchased. How would I get a copy
if I need it? I'm using windows 98.
Thanks for your help
VBA and help files are not part of normal Office install. ie. Office 9
or Excel 97 *not* Windows disk required. Perhaps you ...How do I read Pocket Excel files from Excel
Just got an Ipaq and trying to use ActiveSync to synchronise speadsheet files
between that and my desktop. Unfortunately, when I update the file using
Pocket Excel on the Ipaq, it is converted to .pxl format, which the desktop
version of Excel (2000) won't read! How do I get round this one?
...How To Create Order Form in Excel
Hey, I am trying to create a fundraiser order form in Excel and I don't know
how to slant the cells. I angled the words at a 45degree angle and I want the
whole cell to transform that way. Any advice?
You can't slant the cell itself.
If my comments have helped please hit Yes.
> Hey, I am trying to create a fundraiser order form in Excel and I don't know
> how to slant the cells. I angled the words at a 45degree angle and I want the
> whole cell to transform that way. Any advice?
...How to create a line chart with two X-axes in Excel
PLEASE HELP ME!!!!! How can I create a line chart with two X-axes in Excel?
select one of your data series and change axis to secondary. <chart><<chart
options><Axis> Select secondary x axis.
> PLEASE HELP ME!!!!! How can I create a line chart with two X-axes in Excel?
Hello, thank you for replying.
Which chart type would allow for 2 X-axes. The only chart type that I know
that allows for 2 axes is "Line Chart with 2 Y-axes".
For the above-mentioned chart, the option to designate a primary and
secondary x-axis is display...prevent Excel from EVER automatically converting numbers to dates
in Excel v. X for Mac how do I permanently prevent Excel from EVER
automatically converting numbers to dates. Formatting individual cells
as text will not work in my applications. I need to disable this funtion.
Not possible - there's no preference option to turn this off.
Instead of preformatting as text, entries can be made with an
apostrophe as a prefix:
You might be able to use an event macro to change it back
retroactively, but that depends on knowing what format the user
entered it. For instance,
3/4, 3-4, 4Mar, mar4, etc
will all be interpreted as 4 Marc...excell documents
when i double click on excell documents on my desktop nothing happens.
instead, i must open excell first
click on file then open its then that my documents opens.
any idea on what might be causing this.
Can you single click the excel document to highlight it from the desktop. If
so, can you then select "Enter" to open the document. Does the double-click
issue happen with any other items on the desktop?
> when i double click on excell documents on my desktop nothing happens.
> instead, i must open excell first...Can I make a Cladogram using microsoft Excel?
I'm using microsoft offfice 2003 and was curious is there anyway I can make a
caldogram using the program? I know that it is possible to make a family
tree; however this is inifficient in depicting ancestoral progression of the
species- which would be better display with a cladogram. Any Help greatly
Maybe fernando cinquegrani's cluster or grafi examples may help.
It should be possible to construct a chart using a xy-scatter and
various charting tricks. But a lot depends on how you have this data
La...How do I activate sort in Excel?
I have worksheets set up in Excel. I am wanting to sort 1 column of these
worksheets, but my sort button seems to be grayed out & I cannot select it.
How do I activate the sort function again. Any ideas?
Unprotect your sheet
Regards Ron de Bruin
"marygries" <firstname.lastname@example.org> wrote in message news:A81E1842-3CF4-4CF5-85B3-ED01BEF943C7@microsoft.com...
>I have worksheets set up in Excel. I am wanting to sort 1 column of these
> worksheets, but my sort button seems to be grayed out & I cannot s...Stop excel icon showing at the bottom when opening spreadsheets
how can i stop the excel icons showing at the bottom when i open multiple
spreadsheets. this can be annoying when you have other applications open also.
I assume you mean the Excel icons in the Windows taskbar. To prevent these
from appearing go to Tools -> Options and on the View tab deselect the
Windows in Taskbar checkbox.
> how can i stop the excel icons showing at the bottom when i open multiple
> spreadsheets. this can be annoying when you have other applications open also.
...Corrupt Excel Menu Bar
Somehow my excel menu bar became corrupted. I now have
7 "Edit" menus, 2 Format menus, and 2 Tools menus in my
standard excel view. As a keyboard user (rather than a
mouse user), this is killing my productivity. Any ideas?
Try this. Right-click your menu bar, select Customize,
click the Toolbars tab, click the Reset button, click OK,
click Close. That should reset your menu to normal.
>Somehow my excel menu bar became corrupted. I now have
>7 "Edit" menus, 2 Format menus, and 2 Tools menus in my
>standard excel ...Excel and Word Attachments Time Out in OWA
I am having an odd problem in OWA. Many end users are experiencing time
out problems when trying to access Word or Excel attachments in OWA on
Exchange 2003. It appears to be only Word or Excel as others work fine.
OWA is being accessed on a front-end server. However, all attachments
work fine when accessed through the back-end server. Any ideas?
...data-set too big for Excel
I am using Excel to extract data from a database, but when
the extracted data is too extensive, Excel is stuck. Is
there any way to expand the data-holding capacity of
Excel? I am using Excel 2000.
Any help would be appreciated.
...Representing times in excel without dates
Excel experts I need your help!! I am using Office XP excel and am trying to
represent time in the format: AM/PM without seconds. When I put in the time
[I have the cell number format set to time/"1:30PM"/Locale is English (United
States)], it comes up with the date preceding the time. I have tried varying
settings of time but they all come up with the date. So if I try to put in
1:00PM it would represent this as a date and leave the rest of the time as
12am. I am doing a time sheet that subtracts the hours from between two times
and then adds the differences up. I want it to ...Need macro to allow me to go out into another excel file and copy and bring data back..
I'm looking to have a macro that I've started (below) to allow me to go
out to a file that is always in the same location with the same name
and copy information from it and bring it back into the file I was
originally in. The file from which I want to get the information from
is updated automatically every 24 hours from data dumped into it from
our MRP system. The macro is to be stored in my "personal.xls" file.
The problem is that the original file name is always different. So how
can I make the macro come back to this file that has a different name
each time to pas...Excel and clear cells....
I have this large spreadsheet showing 52 weeks, and for each week 10 areas
not adjacent to each other, all of wich I need to be cleared every year. In
between areas needed to be cleared there are some hidden cells, rows and
Is there a way to easily clear these areas, without clearing hidden and
You can highlight disjointed areas of cells using the Ctrl key while
you click and drag.
For example, click cell A1 and drag to cell B2 to highlight 4 cells.
Now hold down the Ctrl key and click cell A8 and...Importing xml Data into Excel 2002
It appears that there is a bug in Excel 2002 relating to importing xml files.
If the xml file is empty for example:
Excel 2002 will crash when trying to import this using Import Data, or New
Web Query. However, if the file contains something inside these tags, like:
Excel 2002 will not crash. I tried various combinations of this, and it
appears that Excel crashes only if there is one empty tag. If there are
other populated tags such as:...Excel 2008 bug
Operating System: Mac OS X 10.6 (Snow Leopard)
Open a blank sheet. <br><br>Enter a value with a dash in it - i.e., U1-1 <br><br>Excel will NOT allow you to set the series - it'll increment by 1 in the 'normal' direction and decrement by 1 in the 'reverse' direction. It will not allow you to set the series step whatsoever. <br><br>Oh the joy. Now I get to enter 256 fields by hand.
Well, what isn't clear is what you would have it do instead or how you're
attempting to get it to do otherwise. If...How do you create a drop-down menu within a cell in Excel?
How do you create a drop-down menu within a cell in Excel?
You can use data validation. There are instructions in Excel's Help, and
> How do you create a drop-down menu within a cell in Excel?
Excel FAQ, Tips & Book List
...Export to Excel with Expand/Collapse Feature
I work with Sqlserver 2005 and Reporting. I'm using a component Table to make a report. I use groups to collapse/expand rows.
When I export to Excel the report, the expand/collapse is not export. I don't have the possibility to expand/collapse, it appears in expand version. What I need to configure? For example, if I use a component Matrix and I export to Excel, I can collapse/expand the rows in excel too.
Submitted via EggHeadCafe - Software Developer Portal of Choice
ASP.NET Cookies FAQ
http://www.eggheadcafe.com/tutorials/aspnet/198ce25...Excel Invoice template
Can any one suggest an invoice template for the British market?
...Can I sort into sections on Excel 2003?
I have data that looks something like this, in two columns (each row
here represents a column, to make it simipler)
A1, A2, A3, B1, B2, D2, E1
A2, A4, B2, C3, C4, D1, D2
Is there a way to sort the table so that everything is grouped into
alphabetical sections? Something that looks like this:
A1, A2, A3, B1, B2, [space], D2, [space], E1
A2, A4, [space], [space], B2, [space], C3, C4, D1, D2, E1
I'm not sure if that is clear, but I want all the cells that begin
with A to be grouped. The data in each column is not related. I just
want to compare the two columns to see if things in column 1...How do I remove outlook headers from my excel worksheet?
I can't figure out how to. I can't drag it off like I can other toolbars
(formatting, etc.) I can't find anything about outlook in any of the
I have XP, by the way, and I have no idea how the email stuff got into excel.
By headers, I mean there is an email toolbar, where I can choose a from
address and enter to addresses, and choose a priority, etc. It's really
Maybe it's as simple as:
File|Send to|"Uncheck" Mail recipient.
That icon on "mail recipient" is difficult to distinguish between on and off
(for me at least).