how do i change tick marks of excel graph from vb.net
I'm trying to change using VB.NET the tick marks from their default outside
position and place them inside the graph. How can this be done?
...Hyperlink via indirect cell reference
I have workbook that contains a number of sheets. On a separate sheet I
would like to be able to insert a hyperlink so that I can jump to a specific
However, rather than inserting all of the hyperlinks manually (I will have
to replicate this over many workbooks) I wondered if there was a formula to
allow me to jump to a cell (say A1) in another worksheet, based on the name
of that worksheet being entered in a cell reference.
For example - a number of worksheets called "Sheet1", "Sheet2", "Sheet3",
In another sh...Excel Maximized Larger than Screen?
I was on a PC yesterday where Excel Maximized was larger
than the PC Screen ... very annoying ... What is the setup
required to set Excel Maximized to PC Screen Size ... As
always ... My many Thanks to those of you that support
this board ... Kha ...
Do you mean excel or a workbook within excel?
If you meant excel, then I'm gonna guess (and it's just a guess) that either
windows got confused (or you changed the display properties for your windows
setting 1024x768 type of thing).
I'd resize it and see if that fixed the problem. If it did, I'd chalk it up to
one time thin...How to export policies to excel
Our organization has an in-house security tool that generates a text file
with lists of policies and violations. A VB script reads that text file and
populates certain cells on an excel file. There is one column for each db and
one row for each policy. All are SQL 2000 and 2005 version.
New policies are not covered by the tool. So it needs to be tool+manual
scrips, or PBM, maybe?
I wonder if it can be done through Policy Based Management. I am not sure
how easy to generate a similar excel file out of SQL Server policies. Has
anyone used Powershell and/or Report...how to set the worksheet direction in Excel XP
in a right-to-left interface the vertical side showing the row numbers of the
excel worksheet appears on the right side of the sheet. how do I change it'
to appear on the left side?
does tools / options / international - default direction ... help?
"inbal" <email@example.com> wrote in message
> in a right-to-left interface the vertical side showing the row numbers of
> excel worksheet appears on the right side of the sheet. how do I change
> to a...How do I freeze or lock cells to show up on each page without typ.
I have a 4 page sheet. I have a header already. But I want to freeze the
cells that head up the first page. I've done it before in school but can't
remember what it is called or how to do it...that's why I'm doing this.
Anyway, I want these cells to print off on each new page without having to
type them on each page. I hope that makes sense and I hope that someone can
If you mean for printing do file>page setup>sheet and select rows to repeat
otherwise for viewing you can select a2 if the headers start in row 1 and do
window> freeze panes
...Excel, how do I change the column headings from letters to number
I have a spreadsheet that has numbered columns as opposed to the standard
letters. How can I change this back to letters?
Go to the Tools menu, choose Options, then the General tab.
There, uncheck the R1C1 reference style setting.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"lazybee" <firstname.lastname@example.org> wrote in message
>I have a spreadsheet that has numbered columns as opposed to the
> letters. How can I change this ...Excel moving horizontal columns to vertical
I am trying to find a simple way of moving data in horizontal columns
(referencing the key in column 1) to vertical colums (still referenceing the
same key). This would mean automatically repeating the values in column one
for every entry in the moved columns.
I can do this through the pivot table, but this is a long drawn out process.
I'm not sure if this will work for you, but you can try this:
- Highlight & copy on the horizontal value you want to make vertical
- Now highlight the vertical area you want these value to got
- Right Click when highlighted & choose...Rename Cell
How can I rename column A to read "bills" instead of the letter A?
You can't. The closest you will get is to hide column headings, via Excel
Option, and then create your own.
"shoe" <email@example.com> wrote in message
> How can I rename column A to read "bills" instead of the letter A?
you cant change the headers or row labels but you can define you data as a
list (or table) and the headings can then be used to refer...merging 2 cells without losing data?
How can I merge 2 cells without losing data from the other cell?
Not possible I'm afraid. Try placing the dat from both cells into one
and use "Center across selection" under Format>Cells>Alignment
Merge cells always end up causing grief. they are best avoided.
***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
"bob" <firstname.lastname@example.org> wrote in message
> How can I merge 2 cells without losing data from the other...Create static text from cell reference
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
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?
Select all the cells in "C" that have content. R-click them and select
"Copy" then r-click again, sele...Excel sheet not visible
When I open a local copy all I can see is the content of 1 cell in the menu
bar, the work area is all blank gray. I can see the complete sheet (3 Pages)
in print preview. Most users have no problem with this sheet. I have repaired
the installation of Office 2000 and ran all updates, Same problem. It is
something on the local PC that is causing this effect. Other sheets show up
just fine. This is a very simple spred sheet with no formulas.
Maybe it's just off the screen.
(and then resize it the way you want)
New group user 944 wrote:
> When I open a l...How do I convert a word table into an excel document?
I have managed to get the info accross no problem but the formatting is all
over the place. For instance - 07/10 meaning July 2010 is appearing as 07/Oct
despite me going into format cells custom then enter mm/yy which has always
You can't use it like that regardless of formatting, you need to put in the
whole date or else Excel will always assume the current year so any real
date used for calculations needs to be numeric and needs a day, so you can
enter (assuming US date format) 07/01/10 and use a custom format of mm/yy
or if you don't need it for...Cell Format #4
Is there a way to have a cell format based on contents of an i
if(C1="Input",and(C3,Format $#.##),if(C1="% of Revenue",and(C5,Forma
I want the If statement to test a condition, return contents of th
correct cell and format automatically.
Any help is appreciated
bforster1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1177
View this thread: http://www.excelforum.com/showthread.php?threadid=26133
You can't change the fo...Trouble doing a formula for excel
I have a spreadsheet with the following
I would like to add 1 too the number to make unsorder00040.csv and so
I have try mid,right,left i can't seem to do it
"Jason" <Jason@discussions.microsoft.com> wrote in message
> Hi All
> I have a spreadsheet with the following
> A1: z:\data/pc32/tsheets\unsorder00039.csv
> I would like to add 1 too the number to make unsorder00040.csv and so
> I have try mid,right,left i can't see...Getting contents of adjacent cells
I want to divide the y1-axis column and save it to radius (y1/2) column. How
do I do that?
x-axis y1-axis radius(y1/2)
0 0.00 8.0000
1 0.25 8.0242
2 0.50 8.0691
3 0.75 8.1281
4 1.00 8.1989
5 1.25 8.2803
6 1.50 8.3716
7 1.75 8.4729
8 2.00 8.5832
divide the y1-axis by what?
2 as an guess with y1-axis in column c
in the y1/2 column(d?), enter
> I want to divide the y1-axis column and save it to radius (y1/2) column. How
> do I do that?
> x-axis y1-axis radius(y1/2)
> 0 ...How do I export Lotus Approach files into an Excel spreadsheet?
I need to export data from Lotus Approach to Excel; please help. I am using
an old version of Lotus SmartSuite 9.5 and I have Microsoft Office 2003 Basic.
Well, I don't know Approach at all but is there a common file format that
both use e.g. comma delimited. If so , save in that format from Approach and
import into Excel.
> I need to export data from Lotus Approach to Excel; please help. I am using
> an old version of Lotus SmartSuite 9.5 and I have Microsoft Office 2003 Basic.
...How can I sort duplicate text data in excel?
I have a large list of noames that I need to make sure that none of them are
duplicated. Is there a way to have excel check it quisker than me reading
every name until I find a duplicate?
After selecting your data go to filter Advanced filter and check "Unique
You can even copy it to another area all uniques entries if you want to ...
"TinaScheu" <TinaScheu@discussions.microsoft.com> wrote in message
>I have a large list of noames that I need to make sure that none of them
>...EXCEL caused an IPF in module OLEAUT32.DLL
I'm using Microsoft Office 2000 Professional on Win98-SE, I suddenly
began getting the error message:
EXCEL caused an invalid page fault in
module OLEAUT32.DLL at 0187:653aac21.
EAX=000047e9 CS=0187 EIP=653aac21 EFLGS=00010282
EBX=0040fd9c SS=018f ESP=0062b54c EBP=0062b5bc
ECX=65350218 DS=018f ESI=00000000 FS=0f57
EDX=00000000 ES=018f EDI=00000001 GS=0000
I tried re-installing EXCEL but that didn't work. I changed the
Oleaut32.dll with an older version and that also didn't work. I ran
Office Setup and chose to run EXCEL from the CD and it went smooth
without problems. ...Excel 2000 vs. Excel 2002
I am having troubles with a workbook that I created that is havin
I created it in 2002, and it opens fine in Excel 2002 for other people
However, when I send it to someone who has Excel 2000, it takes over a
hour to open.
Now I also made a very similar report that works just fine whe
trasferred to excel 2000.
Here are a couple of stats on the workbook that is having problems:
500+ externel links
200+ simple calculations (a1+b1; a1/b1;etc..)
1 Worksheet in the book.
2 columns with conditional formatting
Message posted from http://ww...Help! Problem Referencing Excel 2003 in VB.NET
I am using Visual Studio 2008 Express Edition to develop some VB.NET
code that manipulates Excel files. I am developing on a Vista/Excel
2007 machine, but I need the code to work on an XP/2003 machine as
I initially set a reference to the Microsoft Excel 12.0 Object Library
and imported the Microsoft.Office.Interop.Excel namespace. This works
great on the VIsta/Excel 2007 machine, but it does not work on 2003,
which needs the 11.0 library. I get an error that says "Unhandled
Exception . . . Could not file or assembly
'Microsoft.Office.Interop.Excel, Version 12.0.0....Customizing Excel's Border Defaults
I'm working with Excel 2000 and use Borders frequently.
The preset default border is a thin line, yet I prefer
and always change it to the thick line. How can I change
the Excel default to the thick line rather than the thin
line? I know it's a small problem, but it's driving me
crazy changing it all the time. In WORD, I know how to
easily "add style default to template", but can't figure
it out in Excel. Any help is greatly appreciated!
...Adding a certain text label in a excel chart
I am plotting in regularly basis a certain set of data in excel.
Based on some data analysis this set of data has to be fitted to these
y = 1/x^a (1) and /or
y = b/x^c (2)
from data analysis, constants a, b and c are found and are placed lets say
in cells A1, B1, C1.
On my graph, I am putting then two small text labels where the real equation
is displayed: smth. like: y = 1/ x^3.45 and / or y = 0.256 / x^3.12 The
whole process is similar with excel curve fitting, when the “show equation on
chart” is checked.
Thank you in advance
My question is: Can ...conditional formatting in excel #3
how do you add a phrase to a field if the filed is blankl, also, can you have
a notifiction sent to you when a date on a spreadsheet has expired?
> how do you add a phrase to a field if the filed is blankl,
What "phrase" do you mean? A Comment? A value?
also, can you have
> a notifiction sent to you when a date on a spreadsheet has expired?
Maybe you can apply an open event (date to be tested being say in F1):
Private Sub Workbook_Open()
If Range("F1") < Date Then
MsgBox "Date expired"
...Excel worksheet with VBE codes don't work elsewhere
Some of my excel worksheets with embedded controls and VBA codes don'
work when I open it on another PC. Is there another way to make i
lazybear's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3519
View this thread: http://www.excelforum.com/showthread.php?threadid=54955
Specifically what problems are you having? Saying "don't work"
means absolutely nothing.
Microsoft MVP - Excel
Pearson Software Consulting, LLC