Displaying active cell in upper left corner
When selecting a range by name, if the range is not in the cells
displayed at the time, Excel then shows the first cell of the range at
the bottom of the display. This is also true if I have hyperlinked to
a particular cell as in an index.
How do I get the active cell shown at the upper left corner of the
display instead? :)
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
Sub setscroll()'no need to activate first
ActiveWindow.ScrollRow = [a5].Row
This ...set cell margins
Does anyone know how to set cell margins in Excel? I'm preparing a long list
of items for a committee review, and I think it would be more user/reader
friendly with some white space. The columns are mixed numbers, dates, and
text, but the largest cells are text.
Look at the various options in "Horizontal" and "Vertical"
Top, bottom, centered, justified, right indent, left indent and a gang of
Also row heights and column widths can be manipulated.
Gord Dibben Excel MVP
On Sun, 5 Dec 2004 10:35:28 -0800, "Junebug...Creating a Chart from Cells that use a List Box
Hi, I am trying to create a number of charts (e.g., pie, line etc) based on
data that is slelected from a list box (i.e., data validation). What i would
like to do is create the charts before any data is entered (if that makes
sense) and as data is entered the charts will display this.
...Smartlist's Account Trx should show document dates of submodules
When you use the Smartlist object Account Transactions and try to find the
document date of those transactions coming from the sub modules - Smartlist
will not be able to show it. There is a field Document Date, but it will show
00/00/0000. The created date is also not very useful as it takes the
system/user date when the transaction was actually posted.
Not all the time will the document date be equal to the transaction date.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click ...Form problems in a table with merged cells
I have a spreadsheet I've been using for several years in which I had set up
a ribbon button to show a data entry form using the table headers. I merged
some cells in an area adjacent to the table and the form would no longer
work. Clicking the ribbon button simply gave the message that the command
could not be used in a table or range containing merged cells. I unmerged the
offending cells but it still doesn't work. I'm stumped - can anyone please
...Date formatting on charts
I have a simple line chart (in PPT 2007) with dates going along the x-axis.
They are m/d/y format - I cannot seem to change them to another format for
the life of me!
I am going to format-axis-number-date and cannot change the format at all!
Does anyone know how this procedure - so simple in PPT 2003 can be achieved?
Help and thanks!
Press with your right mouse button on the chart and choose Format Axis. From
the new menu go under Number - you'll have a list of different formats
I help with Excel and PowerPoint
http://www.officetodo...Tools/Options/Charts-Active cells is dimmed. Want to select leave
I tried using #N/A in equation IF(B7=0,#N/A,B7) as to not show zeros in
chart, but still showed zeros. When I went to Tools/Options/Charts, the
Active Cells area was dimmed and I could not select "leave gaps". Any
Was the chart selected when you did Tools>Options ?
> I tried using #N/A in equation IF(B7=0,#N/A,B7) as to not show zeros in
> chart, but still showed zeros. When I went to Tools/Options/Charts, the
> Active Cells area was dimmed and I could not select "leave gaps". Any
&...how can I split a single cell diagonally in Excel 2000
Anyone out there know a way to split a single excel cell diagonally in order
to have it contain 2 pieces of information?
As far as I know, you can not split a cell diagonally so that it can contain
2 pieces of information. However, you can merge cells which might give you
the effect that you want. To do so, go to the standard toolbar and hit
Format -> Cells -> Alignment Tab -> Text Control and work with the merged
> Anyone out there know a way to split a single excel ce...VBA code to insert pictures in a column of cells
I have a folder of 99 pictures with filenames: image01.jpg, image02.jpg up
to image99.jpg. All of these images are small, and the same size.
I want to insert them (in order) in a column of cells (A1, A2, to A99) using
VBA. The images should be embedded, not linked. Resizing cells to the right
size would be a nice extra, but not necessary - it's easy in this case to
resize manually. Thanks for looking at my question - and I hope to hear some
I need to be able to set set a deadline based on prior dates. These can go
back years. I would like to set up a current 'next appointment, for instance
ever 90 days, based on a date of arrival. For example, if date of arrival is
2/13/03, how do I make a formula that is effective now. In other words, the
cell updates to a new deadline every ninety days, and stays current.
Thanks a bunch.
Maybe this which calculates the number of 90 day periods that have elapsed
since the start date.
Understand though that working with dates is tricky. There i...Date Formulas #3
How can I make a cell correct the year of a date
not really sure what you're after here
if you have
and you want to display just
then right mouse click on the cell and choose format cells / on the numbers
tab, choose custom and then type
in the white line and and click OK.
however, this just displays the date showing only the year, if you want to
extract the year only to another cell you can use
where A1 contains the date
if you're after something else, please type a few examples of the data you
have and what you want to see.
JulieD...Automatically match destination formatting?
I have a spreadsheet where I would like everything I paste into to it to
match the formattting of the cells around it--not retain the formatting it
had in its original location. I don't want to have to select "match
destination formatting" every time--I want it to default to that. Any ideas?
I cannot find a way to make Excel paste automatically using destination
formatting. A workaround is to use a macro to do the paste:
ActiveSheet.PasteSpecial Format:="HTML", Link:=False, DisplayAsIcon:= _
False, NoHTML...Hiding Columns based on cell value
I am a novice when it comes to writing VBA code, I would greatly
appreciate any help I can get in figuring out my ?.
I would like to write a macro that automatically hides columns of data
based on the value of a cell (I2) with a picklist. Cell I2's picklist is
monthly values (formatted as Jan-10 though Dec-10 but real values are
1/1/2010 through 12/1/2010). I have a range that contains work week end date
values (1/8/2010 to 12/31/2010) in L6:BK6. I would like to have the macro
hide columns that are less than date value chosen in I2.
For example, if a user selects "...Insert date automatically
I have a column with values such as:
And wish to automatically add todays date if the value of the cell is blank
in the mm/dd format. I have used an =If(Column:Column="",TODAY()) in a
column next to it and formatted it in mm/dd to get the desired result. But
how can I take this value (todays date) and insert it back into the original
column automatically and without changing the other valuse?
As always thank you!
Hi, Rick: Here's one way.
Step 1 is to make a backup of your original file so you have a fallback
in case something goes ...Custom Formatting in a Button
It sounds simple but I have not been able to find any help on th
I do lots of formatting in Excel XP. I do not want to alway
right-click on the cell(s) and go to the Format menu.
My Q is can I place an icon in the tool bar (I know how to do that
that will have the custom fomat I need for the cell.
Your help is much appreciated
Artful Dodger's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1656
View this thread: http://www.excelforum.com/showth...C or C++ Utility for wrting .doc format
my final output is to write MS Word .doc file
my input is some text and Images .
and i have to write using either c or c++ , can you tell me any third
party Libs or
is there any API provided by Windows or MSVC or .... if there is
nothing and i have understand
the complete file format and write it as binary file then please help
me how can i get the format details
and i have Image decoder all ready developed .... so there is no
problem of decoding the images
>karunesh" <email@example.com> wrote in message
> me how can i get the format deta...How to get only the year in the date format in Access
How to get only the year in the date format
I.e in the table in need to display only year
E.g 2005 - should be display " 05" automatically
Custom format the cell as:
Please keep all correspondence within the NewsGroup, so all may benefit !
"yanu" <firstname.lastname@example.org> wrote in message
> How to get only the year in the date form...Is there Formula to Tab to certain cells
Is there a formula to tab through certain cells? I have a form with about 15
cells that I would like to access easily through the tab key....is there any
way to do that?
One way to explicitly control the exact "next cell of focus" selection, is
to select the cells in the desired order of travel, and then preserve this
ordered movement by creating a named range.
This old post describes the steps that can be taken to create such a "named
Please keep all correspondence within ...Conditional formatting error
I have a form with multiple date fields, whenever the date entered is within
6 months of today's date, I have conditional formatting set to show the date
Taken From Dialog Box: "Field Value is - Less than - Date()-182.5"
There are instances where the formatting is being applied and others where
it is not. In some cases on the same form. I don't know where to go to get
the form code to past here so help there would also be appreciated.
To get the code, open the form in design view, click on one of the date
fields, open t...The Sum from 1 worksheet cell to another worksheet cell
the sum from one cell on sheet1 from another cell on sheet2,how do you do the formula
To sum the value on Sheet1, cell A10 with the cell
value Sheet2, cell B20, enter =Sheet1!A10 + Sheet2!B20
(or you can enter '=' sign and click on A10, then enter
the plus sign and click on B20)
>the sum from one cell on sheet1 from another cell on
sheet2,how do you do the formula
...Prevent change to refs in second worksheet when drag cells in firs
I have a complex calendar in Excel. Each week, admins Ctrl-drag cells among
different locations in the primary calendar worksheet. I have a second
worksheet that needs to list those cell values in a fixed configuration, e.g.
the value in Sheet1!A1 needs to always appear in the cell of Sheet2!G10.
Sheet2!G10 contains the formula: “Sheet1!$A$1”. If the user drags Sheet1!A1
to Sheet1!A3, the formula in Sheet2!G10 gets automatically updated to
“Sheet1!$A$3”. I have tried all combos of locking and protecting to prevent
this updating. Is there a way to do this?
Try referencing the other shee...How do I split a single cell in Excel ?
I have a calendar with one day in each cell. I need to split a cell
horizontally. Is this possible ? How do I split an individual cell ?
you can draw a line for corner to corner in a cell but you
cannot "split" a cell like that ie not possible.
>I have a calendar with one day in each cell. I need to
split a cell
>horizontally. Is this possible ? How do I split an
individual cell ?
Not splitting a cell--but putting information on multiple lines with in the same
If that's ok, use alt-enter to force that new lin...=if() statement -- test for any text in cell
I'm trying to convert the following statement . . . =if(A1=______ , "+", "")
to . . . a search for any text, that might happen to be in cell A1.
I don't know what the best option is for filling in the blank after A1=
Thanks So much hor helping me if possible,
You could reverse your argument to
It will depend on whether you expect there to be anything else in the cell.
It won't work if there is a number.
There will be a way - I just ain't got it yet
Russell...how to print cells based on "Yes".
If the first cell in row 1 of Column "A" is "Yes", how do I get preselected
contiguous or non contiguous cells in the same row to print? If the answer is
"no", I do not want cells in that row to print.
Thanks for anyones help!
You can use Data>AutoFilter to filter on that column and print.
Only the visible cells will print
Regards Ron de Bruin
"Francis Knight" <Francis Knight@discussions.microsoft.com> wrote in message
I am trying to sort my sales table, it doen't seem to work for me. A
comment comes up: this operation requires the merged cells to be idendically
sized. Can you help? Thanks
Easiest way is to *unmerge* the cells, and then use "Center Across
<Format> <Cells> <Alignment> tab,
And expand the "Horizontal" window, and choose,
"Center Across Selection"
Please keep all correspondence within the Group, so all may benefit!