Replies

And thanks to all.

I have a question that comes from a little knowledge, but not enough to be really intelligent sounding.

It is my understanding that to do the editing, in most cases the software requires that the dvd files be converted to another format. Then, the files need to be reconverted to dvd format to allow burning onto another disk. If this is true, is there any degradation of the quality of the dvd image and/or sound?

The behaviour you want should be there if you are in edit mode.

You can get into edit mode by dbl-clicking the cell or hitting key. In edit mode, the backspace, right and left arrows move, , and move within the text of the cell. When outside of edit mode, those keys work on the sheet…

Steve

I was well aware of the double click to edit a cell; but I did not know about . Thanks.

Still, it would be nice if there was a way to be able to be in edit mode all the time. Or at least, with respect to backspace and home.

Option 1 – use a formula such as =UPPER(TEXT(A1,”dd-mmm-yyyy”)) to convert to uppercase
Option 2 – format the cells with a font that only has uppercase characters.

I’ll be watching to see if anyone has any better suggestions.

I just might use that if there is no better way. I can put the date in a separate column, and hide it when I have to print a report.

I just checked it again; it works for me.

You can also go to the “View” tab in 2007 (You ARE using 2007, yes) and click on the Zoom button. Zooms can be adjusted there.

There is also a “dial-a-zoom” slider at the bottom right of the screen.

I found out the problem. In 2003 in “normal” view, the non-printing grid lines show up. In 2007 in “draft” view, the lines do not show up (or at least I cannot find the switch that turns them on). By moving the mouse slowly around, you can get it to change to the two parallel lines that show that you are on the border, and you can then move things around. And, of course if you have the ruler bar on, you have a little bit more information available.

But still……..

I tried Draft view but the pages are miniscule, way too small to see, and switiching to One Page view resets the Document Views to Print Layout.

The size of any of the views can be quickly adjusted by holding down the CTRL key and rolling the mouse wheel. Incidentally, this seems to apply to most software.

There must be a table setting I am not aware that controls how tables respond to Insert Page Break commands before them. In a report I’m ediitng, whenever I insert a page break above a table, and then Cut or delete the hard paragraph return above the table, the table goes back to the previous page. Essentially, removing thhis hard return (which I don’t want b/c it lowers the position of the table by the height of a return) seems to remove the Insert Page Break field.

In a blank Word document, this doesn’t happen. Deleting or cutting the hard return after inserting a page break as above causes the table to move to the top of that new page, the result I want to occur in all documents.

I’ve looked at the table options but don’t see any setting that would control this. Perhaps the option is elsewhere in Word and not in table options?

Anyone?

Thanks.

I had a similar problem in 2003. There if I used the “normal” view, now more accurately called “draft”, you can see both the page break and the hard return. You have to be sure to be viewing all the formatting marks to find this. I haven’t tried it yet in 2007, but the draft view seems to be acting the same in other areas.

As an alternative, just go and format the paragraph, and set the height to “exactly” 1 point high. It will essentially disappear.

Just a note: I’m going to be offline for the next day and a half (heading to the beach!), so won’t be able to follow this thread for a couple of days.

Thanks. I will try your suggestion.

Meanwhile, I hope you enjoy the beach. I just got back from camping, hiking, canoeing, and biking with some Boy Scouts.

Are you using ordinary Copy and Paste commands?

Good Question. I don’t use Copy and Paste directly; another lounger gave me a macro that inserted it with a few additions:

Sub PasteXLTable()
On Error GoTo ExitHere
Selection.PasteExcelTable False, True, False
Selection.MoveUp Unit:=wdLine, Count:=1
Selection.Tables(1).Rows.HeightRule = wdRowHeightAuto
Selection.Tables(1).Rows.AllowBreakAcrossPages = False
ExitHere:
End Sub

(2003 insisted on fixing the row height which was often larger than it should be for the subset that I actually included in the document; it also allowed a row to break across a cell, something that I could not allow for my reports. That is the reason for the last two commands.)

If this macro needs tweaking, I would appreciate it. I am just starting to get to speed on 2007.

Yep, that is a work around but if you want a way to format the cells try a custom format of @

Thanks even more. Yes, that works even better (I tried it in a sandbox). But, oh my, was that a nusiance to dig out of the “help” files.

Add a space to the front of the text on entry

Hmm–I have heard worse ideas. Thanks.

[But seriously someone should send a message to Microsoft–isn’t this a bit draconian even on your part. I mean, no way to shut it off?]