Can you insert a picture into a specific cell?
Or do they only "float" on the page.
They float over the worksheet, but you can adjust the size so that it seems to
fit a cell exactly.
If you insert a picture, you can hold the alt-key down while you move/resize the
picture. When it gets close to the edge of a cell, it'll snap-to that edge.
> Or do they only "float" on the page.
...Joining text with a formula in cell #4
just to complete the thread...
I found the answer.
You have to change the format of the cell to custom 0.00"*"
this is the only way it will show only 2 decimal places
Thanks for the hel
Mustard Head's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1630
View this thread: http://www.excelforum.com/showthread.php?threadid=27700
...Excel Opens Without Displaying Workbook
I am having issues with opening an Excel file. The file opens, but the workbook is not displayed. I tried the resolution in the article XL97: Excel Opens Without Displaying Workbook (http://support.microsoft.com/default.aspx?scid=kb;en-us;158996&Product=xlw97), but neither of the resolutions fixed the problem. Any suggestions??
Are you using Excel 97?
Fort Collins, CO
>I am having issues with opening an Excel file. The file
opens, but the workbook is not displayed. I tried the
resolution in the article XL97: Excel Opens Without
Di...Single click selects multiple cells
When clicking on a single cell multiple cells are selected. The one time
solution for this is to zoom in or out. This is problematic as 60% seems to
be the zoom that works most of the time but at this zoom level the cell
contents do not display. The time lost and the frustration that builds is
killing my productivity and office attitude. Please give all of us a permanet
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" butt...Display of UML State Transition Event
I am attempting to use the UML Statechart with a couple of
states and a transition between them. I select properties,
Events, Change Event type, say, and can see ChangeEvent1
in the property window but...
....when I Ok back to the drawing the ChangeEvent1 is not
displayed by the transition.
I can enter actions in a similar way and they are
How cna I get the event visible too in the drawing? Surely
this is the most important aspect of a transition i.e.
what caused it,
...Renaming Partial File Names
Is it possible to rename part of a file name? (almost like a find and
replace) My database pulls in the excel file names from a directory, with
it's subfolders and contents as well. Every file begins with "Kay Form".
Kay no longer works in our department, and I'd like to run a loop that
replaces "Kay Form" with "Featured Track". I don't know how to do a partial
Thank you in advance!
Message posted via AccessMonster.com
Checkout the Replace function. I...Referencing cells across sheets
I've created a workbook with three sheets. The first three
columns of sheet 2 and sheet 3 are referenced to the first
three columns of sheet 1.
What I'd like to do, is set the workbook up so that if I
insert a row before, between or after referenced rows in
sheet one, a row will also be inserted, and referenced, in
the corresponding place on sheets 2 and 3. Does anyone
know how to do this?
Also, if no data is entered into a cell on sheet one, the
value shown in the corresponding cells of sheets '2'
and '3' is '0'. I need those cells to remain bla...Copying Data in a cell in one sheet to a cell in another sheet
I've run into a problem trying to copy data from a cell
in one sheet to another. I have a spreadsheet
called "rating" which contains a number of formula that
calculates a final number. I also have a spreadsheet
called "Final" that copies over the information
from "Rating". In "Final", I'm trying to copy a number
from "Rating" into a particular cell. I put in =Rating!
G89, but it won't work. When I press enter, a window
pops up "Update value:Rating". I press enter again and
in the cell where I want the number ...How to unlock locked cells by MACRO?!
I have locked Sheet and I need to change particular cells. But when my
macro wants to change it => ERROR :/
Is there any way to unprotect these particulary cells by macro and
change them? - after that action, of course, I want to lock them again.
Please help me, Pedro
Just unprotect the sheet, do the work, and reprotect the sheet. Kind of like:
'your code to change stuff
Petr N�me�ek wrote:
> I have locked Sheet and I need to change particular cells. But when m...VBA to put a copy of worksheet on the desktop 05-13-10
In my workbook XYZ I have a sheet ABC. With a button on sheet DEF I can
refresh sheet ABC. When the code finishes it job I want to add the actual
date (short European notation dmyy) and time (f.i. 241110 16.31) to the name
of the sheet (which becomes ABC 241110 16.31) and after that make a copy of
that sheet in a separate workbook and put that workbook as an icon on the
desktop of my computer. Is this possible? If so, please help me with the
necessary code. Thanks in advance for your assistance.
...Shortcut for inserting names?
I am building many formulas, each with many named cells as part of it.
Currently I have to go to Insert | Name | Paste with the mouse each time I
want to insert a name. I looked in Walkenbach's Excel Bible but couldn't
find any mention of a keyboard shortcut or other shortcut. Is there one I
could take advantage of?
I've got Excel 2002.
...How to add a button to restore all altered cells original values?
I want to add a reset button to an excel spreadsheet that will restore the
values of all changed cells to the original saved ones.
Any help would be appreciated.
this would require quite some VBA code as you somehow have to store the
original values for example on a separate hidden sheet
"Dawnybros" <Dawnybros@discussions.microsoft.com> schrieb im
> I want to add a reset button to an excel spreadsheet that will
> values of all ...Adding a combo box to a worksheet
I'm re-creating one of our paper forms in Excel and I'd like to add combo
boxes to some blanks on the form to allow the user to choose a name from a
list. I know a little about Excel formulas and no VB code at all...what's
the idiot-proof way to do this?
The easiest way is to right-click within Excel in the toolbars area and
select the "Forms" toolbar.
Then Forms toolbar should then appear and could can select the "Combo Box"
icon and click on that. If you can't tell which icon represents the Combo
Box, just hover yo...Can i use conditional formating on a cell when it contains a formula?
I am trying a "conditional formatting" on a cell that contains
formula, but it didn't work.
"If cell value is equal to 0 then font - white" This doesn't work,
If i use this condition on a cell without formula it works just fine.
sit's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=262
View this thread: http://www.excelforum.com/showthread.php?threadid=26784
are you sure your formula returns an exact zero?. Could you post the
formul...Indirect Method for Name Box Variable? #2
The reason I want to do this is that I have to collect data on a dail
basis but I have to display it on a graph on a weekly basis.
I select the entire week of cells and give it a name like week52.
The following week I have to select the entire week and name i
Everything is set up that I can just copy and the numbers will progres
for whatever length of time I need to graph (months, years, etc) excep
Maybe I'll just go back to using the range of cell numbers.
Chris Bre...Cell with large amount of data not showing all data
I'm running Excel 97. I have a cell with 358 words (1928 characters with
spaces). Word wrap is on for the cell. Only part of the text is displayed
even though the cell is big enough to show everything. If I make the cell
wider (wider than a page) more of the text shows but not everything. I tried
a new worksheet with the same text and had the same problem. Is this a known
issue with excel? Is there a solution?
Left to its own devices, excel will only show about 1000 characters in a cell.
But you can add some alt-enters (to force a new line within the cell) and see
more s...Problem displaying expected results with CString
I am writing a MFC program to import data from a single table database into
a normalized database with numerous tables. The first component opens a
recordset object to the database and performs some basic tests on the field
value, and the plan is to write the records out to a spreadsheet that fail
to meet any of the criteria defined for the field. Along with writing out
the record, I want to populate a comments field describing what failed. I
have tried to implement this with a CString variable; I initialize it to a
blank string each time a new record is examined, and then as each field is
che...CRM Email Displays Size=2>
One of my users is experiencing an issue when they save an email that is
tracked within CRM the email displays in CRM with "Size=2>" directly in front
of certain lines of the email. So for example "Size=2>" will appear in front
of someone's comments in the email or in front of their name. Does anyone
know why "Size=2>" is displaying in front of the lines of an email? Thanks.
"Mike H." wrote:
> One of my users is experiencing an issue when they save an email that is
> tracked within CRM the email displays in CRM wit...Sorting by file extension in a worksheet
I have an excel worksheet which has a list of file names from a
directory and various stats about each file. I need to be able to sort
them by the file extension.
I would like to sort them by the ".eps" extension. I have tried using
the Data,Sort menu and something like *?*.eps as the criteria. But am
obvisouly missing something.
Any help would be most appreciated.
You could use a helper column to extract just the extension then
include this in your sort range and sort on the helper col...If a worksheet name is = to test then a msgbox appears
I'm looking for a macro that will display a msgbox if a worksheet is = to test.
For example, if the name of a sheet in a workbook is equal to test then
display msgbox saying sheet already exists.
dim ws as worksheet
set ws = nothing
on error resume next
set ws = worksheets("test")
on error goto 0
if ws is nothing then
msgbox "doesn't exist"
msgbox "already exists"
> I'm looking for a macro that will display a msgbox if a worksheet is = to test.
> For example, if the name of a sheet in a w...formula to have 0 to 6.5 only in ref to other cell val of 0<=6.5
...Automatically open Detail Entry Window
In SOP Transcation Entry, I'd like the Sales Customer Detail Entry window to
open automatically after the customer ID is selected. Is this possible? How
would I go about doing this with Modifier or VBA?
Extender would come in very handy. You don't need to write a single code.
Record a macro using GP macro and embed it on the SOP Entry window using
> In SOP Transcation Entry, I'd like the Sales Customer Detail Entry window to
> open automatically after the customer ID is selected. Is this possible? How
> would I go about doi...display in taskbar in excel 2000
Have a problem!
I work with Office 2000 and excel does not open more than onw screen
in the taskbar.
Windows in Taskbar, I checked in Excel.
Clustered display is turned off in the properties of the
Can anyone help me with this problem prog, get it only if I
2x open excel.
I can't figure out what exactly what is happening in your excel but
try this, Go to TOOLS (Menu Bar) then OPTIONS, in VIEW tab just CHECK
the Windows in Taskbar.
Hope this will help.
...ACC: How to Display Line Numbers on Subform Records
I found this article on MS' website
but ran into problems when I pasted the code and tried to compile it. It
gives a Compile Error:
Method or data member not found
when it reached the line below:
RS.FindFirst "[" & KeyName & "] = " & KeyValue
and it highlights "FindFirst".
I have a sub-form (child) of a parent form's and I have a variable in the
child that the user currently manually increments from 1,2,3 and so forth.
Can this not be done w/o the user's intervention?
...Parameters to open SO Manager with your credentials automatically?
Does anyone know of either shortcut target line parameters that would cause
you to automatically log in with a specific user/password combo; or even a
command prompt parameter? Thanks!