After a certain region need to be printed,
Von wlong12, 01:20turn on the "visual surface manager" dialog box, select the corresponding views (such as "print report") of paragraph, click the "display" button, the corresponding view shows out and then executed print operation to go. Microsoft Office 2010 is so great.
Four, macro command method
Start Excel, open the corresponding working directory (, press the Alt key + F11 "key combination, enter" the Visual Basic editor "condition, on the left side," engineering resource manager "window, the selected the above work book dialogue project (such as the record. XLS VBAProject (2004), the execution" he insertion - module "command to insert a new module (" module 1"), then will the following code input to the right of the window:
Sub printed ()
Selection. PrintOut
End Sub Microsoft Office is inexpensive and helpful.
Input is completed, close the "Visual Basic editor window to return.
Selected areas need to be printed, and the implementation of the "tools - macro - macro" the order, opens "macro" dialog box, select just edit the macro (" print "), click "executive" button.
Friendship remind everybody, if the "engineering resource manager window chosen VBAProject (PERSONAL. XLS) option, the above macro to all work book documents effective. Office 2010 is my love.
Common replication text in Word to other places from time to time is the most commonly used commands, CTRL + C copy command, then use the CTRL + V will disclose the paste copied to the target. This solution can be replicated text is universal, but a little trouble the whole day press Ctrl + C, then press Ctrl + V.
In fact, hidden in the Word more simple and make better use of command duplicate text, but it is not difficult to find the Word fans hidden by the characteristic.
Excel is not everything. There's mastercard, in some ways there are always limit let a person feel Microsoft Office 2007 can make life more better and easier.
uncomfortable, then we went to see a friend on the BBS succeed in that ask some Excel no way to put the problems, and you asked me to death without asking ask single-minded trip. In order to avoid repeated questioning, save everyone net friend of time, I first summarizes several, hope the friend that has seen disaese. Of course, there must be I didn't write place, everybody will complement.
1 custom format terms do not exceed 3, but customize cell format increased to 6 colors (borders) Office 2007 is the best invention in the world.
can't change http://www.excelhelp.net/cgi-bin/forum/topic.cgi? etc. Forum = 4 & subscribers = = 100 1572 & display. Other restrictions have: cannot enter constants arrays, cannot copy-pasting, cannot be changed conditions sequence
2 no way to add "automatic gamecomponent format".
3 function of nested cannot exceed layer 7 (but can use "definition names" approach to remove nested function limit.
The length of the four name cannot exceed 255 characters, in a cell's formula of characters limit is 1,024 characters.
5 EXCEL automatic filling, character type digits over 11 cannot automatic filling.
6 no way to insert animated GIF images. 7 for reference only between workbook is absolutely quoted cannot is opposite references.
