insert column problem
I�m trying to add 31 more columns to the end of my spreadsheet and
keep getting this strange error message:
�To prevent possible loss of data. MS Excel cannot shift nonblank cell
off the worksheet. Try to delete or clear the cells to the right an
below your data. Then select cell A1 and save your workbook to rese
the last cell used. Or, you can move the data to a new location and tr
It lets me insert one column, but then it won�t let me insert any mor
My end columns are blank so I don�t know why I�m getting this erro
see attached spreadshee
Attachment fi...How under the insertion pulls in the excel form tabulates the fram
How under the insertion pulls in the excel form tabulates the frame？
...Inserting a Hard Carriage Return within a Cell
I believe in word tables you use a ctrl+return, but how
do you do it in excel with out taking yourself to the next
I am doing address, and want all entries in a cell to line-
up after formatting in wrap text.
Microsoft MVP - Excel
"DL Ressel" <email@example.com> wrote in message
> I believe in word tables you use a ctrl+return, but how
> do you do it in excel with out taking yourself to the next
> I am ...Inserting/Adding objects to Collections
I am trying read from a xml file, pull the values in a object and then add
the object to an ArrayList.
I am using a 'while' loop to move through each node in the xml file and
pulling the required values as needed and setting them to the relevant
property within my object. The reading of the xml file works as it should.
I get a problem when I try to add the object that I created to the
arraylist. It seems to be adding each one, but when I view the results of
the list, it shows the last object passed in for each object stored within
Here is the code that is givi...Insert
Column is titled - "UP". I want to replace with an arrow.
One way: Select the cell and use Insert | Symbol. Go to the Wingdings group
and there's an arrow there that may work for you.
> Column is titled - "UP". I want to replace with an arrow.
> Portland, Oregon
In Excel 2003 click the Drawing tool on Standard toolbar (to the left of the
Zoom button) - the Drawing toolbar usually appears at the bottom of the
On the drawing toolbar click AutoShapes, choose Block Arrow...How do I move Inserted Comments in Word?
I have several comments in a Word 2003 doc. Currently they take up 3 pages,
but I would like to MOVE them on to one page. In order to do that I need to
know how to move inserted comments so that I can fit them on one page.
To move a comment, you can cut and paste the text to which the comment is
attached. Or you could cut the text of the comment, delete the original
comment, insert a new one, and paste in the text.
Microsoft Word MVP
"Kelly" <Kelly@discussions.microsoft.com> wrote in message
news:870CBAB9-EC70-4AE3-BDB4-39A945891C1D@micro...Clip art does not appear in new blank publications when inserted
I am running office 2003 pro. When I use Publisher , the following happens. I
open a new blank publication page and go to insert some clip art. The
outerframe of the clip art appears but not the actual clip art. There is no
clip art to be seen. When I print it out the clip art is there.
Can any one help? What am I doing wrong???
View, pictures, "detailed display"
Mary Sauer MS MVP
"doogle" <firstname.lastname@example.org> wrote in message
news:6F0BD8FE-3FCD-48A3-8BA8-4C1C86...Microsoft Office Word Document is missing from Insert Object dialog
From the Word 2007 ribbon, clicked Insert, Object, Insert Object.
Received Object dialog. On Create tab of dialog, scrolled through
list of available Object Types. Microsoft Office Word xxx types are
missing. Microsoft Office Excel, PowerPoint, etc. are there.
Color me confused. Doesn't happen on all boxes here in-plant, but
does on some.
Hoping that someone can educate me with respect to:
1. What caused the problem, and
2. How to correct it.
You don't have, Insert | Object | Microsoft Word Document in your list?
Terry Farrell - MSWord MVP
&...Inserting text before right command
I am using the command:
This gives me a number output. How do I insert a word before it, i.e.
instead of giving me say "3" it gives me "Position 3"?
Turnipboy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24527
View this thread: http://www.excelforum.com/showthread.php?threadid=486783
"Turnipboy" <Turnipboy.email@example.com> wrote
in message new...how do I insert a title page to a 3 page research paper
How do I insert a title page to my 3 page report
If you're using Word 2007, go to:
If you're in an earlier version of Word, go to
> How do I insert a title page to my 3 page report
...problem inserting photo in publisher
when i insert photo from file the photo is blank in publisher
Based on Publisher 2000; I'd look at View, Picture display and/or Control
Panel Display, Settings, Advanced, Troubleshoot tab, and lower the
"jj" <firstname.lastname@example.org> wrote in message
> when i insert photo from file the photo is blank in publisher
How are you inserting the photo?
MVP Microsoft [Publisher]
"jj" <email@example.com> wrote in ...Quick Parts/Inserting Text File
I have a two-page document I frequently need to insert into certain
contracts. I notice that when I insert it as either a "text from file" or a
"quick part," the formatting gets all screwed up -- the text is the wrong
font, the spacing is too wide and the original two-page document sometimes
turns into 4+ pages with all the weird spacing and font issues. Is there a
way to keep the inserted document/text the way it is originally supposed to
appear? I'm using Word 2007.
Insert a Section Break (New Page) before where you are going to import
your file, and...Can I retain functions from a previous cell when inserting a new r
I have an Excel spreadsheet.
I need to insert a row, but have a column with SUM functions going down each
Can I insert the row and have the SUM function automatically entered
in the new row created?
"Philobr" <Philobr@discussions.microsoft.com> schrieb im Newsbeitrag
> I have an Excel spreadsheet.
> I need to insert a row, but have a column with SUM functions going
> Can I insert the ...Inserting Rows
I have 500+ rows of data that I would like to insert a
blank row in between each row. Is there a globabl way of
doing it rather than having to click on each row one at a
time and then selecting 'insert row'?
have a look at
> I have 500+ rows of data that I would like to insert a
> blank row in between each row. Is there a globabl way of
> doing it rather than having to click on each row one at a
> time and then selecting 'insert row'?
Thanks...Insert FLASH file (.swf) into FP2003
I have a flash file that I can open and view in Internet Explorer. I would
like to insert this '.swf' file into a web page, using FP2003.
How can that be done?
- John R. Baker
Insert > Web Component... > Advanced Controls > Plug-In
- John R. Baker
"JRBaker" <firstname.lastname@example.org> wrote in message
>I have a flash file that I can open and view in Internet Explorer. I would
>like to insert this '.swf' f...Cannot Insert picture as attachment only in body of email
All of a sudden I am unable to insert a picure as an attachment - the options
are grayed out but I can insert a file as an attachment. However, I do have
the option of inserting a picture in the body of the email. I did used to be
able to do this. Outlook is set up to compose messages in HTML and I use
microsoft office to edit my email.
Any advice gratefully received.
To insert a picture as an attachment
To insert a picture in the body
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
http://www.howto-o...Insert / Delete a line keeping the order
I need to generate a table with a sequential reference number as the first column on the left. Every now and then, one needs to add or delete one (or a number of) row(s) in the middle of the table. How can I automatically re-sequence the table without manual intervention?
the following formulas will put a sequencing number in column A, if
column B is filled:
in A1 enter the following formula
in A2 enter the formula
and copy this formula down for as many rows ...How to programmatically insert an activex into a dialog?
How can I programmatically insert an ActiveX control into my MFC
Please cc to my email.
Here's a couple of links to check out:
<email@example.com> wrote in message
> Hello All,
> How can I programmatically insert an ActiveX control into my MFC
> dialog box?
> Please cc to my email.
...Inserting static date AND time
I've found that you can insert either a static date using
[Ctrl] + [:;]
or a static time using
[Ctrl] + [Shift] + [:;]
Is there a way to enter a static date and time without adding the two
Thanks in advance,
Hi, I'm not sure if this is what you are looking for, but playing
around with your example I found that you can combine them.
Add the date, press the spacebar, and then add the time--Excel
recognizes this as a date / time value.
ActiveCell.Value = Format(Now(), "dd-mm-yyyy h:mm:ss AM/PM...Insert Multiple Text Frames
Someone has told me that to insert a text frame you can click the text frame
button with your right mouse and that way it will leave it switched on so
that you can use it over and over again without reselecting the button. I'm
using v2000 but I can't seem to get it to work.
I've never heard that. Right-mouse button clicks generally give you options
about the command you are in the process of using.
MVP Microsoft [Publisher]
"Anita" <Anita@discussions.microsoft.com> wrote in message
news:7DEAAFC1-0DD6-42CD-AF4F-A3A64CE2AE96...insertions in downloaded templates
I must have forgotten! I downloaded some Office business card templates from
MS. Do not remember how to enter info in one of 10 cards on sheet and have it
fill in the others. Do I go to 'print' and set to single per page or what?
Please answer someone! I need to get these done tonite! Thanks!
To all...thanks! Please find me if I can ever return the favor! I would like
to be involved in helping, and also beleive this will be my ''help'' source
in the future. Later..Steve
Sorry no one was looking at your post last night. Hopefully you found your
answer. When yo...INSERT INTO Query Converted to VBA
I have a append query that works great if I just run the query via Access. I
need to convert that query into VBA code. Here is the SQL View of the query
I'm trying to convert:
INSERT INTO TblInitiator IN 'I:\Archive\TestFinal\080107\TS3000v101_be.mdb'
What the query does is append the table called tblInitiator located in a
network location from values in a table called tblAddInitiator. There is only
one field in each of the tables both called fldInitiator
I tried this VBA statement (all on 1 line)
AppendDB = "IN...How do I insert a "hard return" in a cell?
I want the words in the cell to be on two lines. It's SHIFT + a couple of
other keys but I don't remember which ones ... THANKS!
"cari" <firstname.lastname@example.org> wrote in message
> I want the words in the cell to be on two lines. It's SHIFT + a couple of
> other keys but I don't remember which ones ... THANKS!
...Rows inserted into a List will not sort properly
I have a spreadsheet that is sorted first by department, then by number. The
departments are sorting OK, but within some of the departments, the numbers
are not being sorted properly. This is happening in departments where some
rows have been inserted into the spreadsheet and data has been entered. In
those departments, after running the sort, the numbers of the inserted rows
appear first, followed by the remaining numbers. I've tried reformatting the
cells and Iv'e also tried copying the sheet and pasting it into a new file,
both to no avail. Any ideas?
Excel 2003, Window...Auto Insert of Comments for Cell
I have a spreadsheet with a column containing about 500 rows.
For each row, I want to insert a comment. The comment text is in a column
of 500 rows in another spreadsheet.
Is there a way to automate the insertion of the comments from the source
column to the target column?
Try this with the comments text in column A of sheet2
Dim cell As Range
Application.ScreenUpdating = False
For Each cell In Sheets("Sheet1").Range("A1:A500")
On Error Resume Next
cell.AddComment Text:=Sheets("Sheet2") _