The problem that word cannot display images is finally solved! Oh yeah!

Source: Internet
Author: User
Tags email account

Only one box is displayed in the image in my word. This problem has plagued me for a while and is finally solved today.

The reason is as follows:

WordFormulas cannot be displayed in
Q: The edited formula in Word 2003 cannot be displayed. It is displayed as a box. What should I do?
A: Word uses the formula entered in the formula editor as the graph. The edited formula is displayed as a box because the "image box" function is mistakenly enabled, this function allows the Word to display a blank box to replace each image in the document. To disable the "image box" function, click "Tools> options", click the "View" tab, and clear the "image box" check box under the "display" title, click OK. How are you doing? The formula you want to see is coming soon.

Bytes ------------------------------------------------------------------------------------------------------------------------------

This answer was found in the search engine. Later, I found that searching for hidden images in Office online search can also find the correct solution,

Depend! This is called reverse thinking? Ha sign, the solution is as follows:

Hide images to accelerate scrolling

In the Tools menu, click options, and then click the view tab.
To hide an input image, select the "image box" check box. Microsoft Word only displays the outline of the image.
Clear the "graphics" check box to hide custom images (custom images: a set of ready-made shapes, including basic shapes such as Rectangles and circles, and various lines and connectors, arrow summary, flowchart symbols, stars and banners and labels .) .

Bytes ------------------------------------------------------------------------------------------------------------------------------

At last, I posted the frequently asked questions about the searched Office together :)

Unable to reinstall Office XP
Q: My system is Windows XP. When I installed Office XP a few days ago, I had a power failure in the middle and could not use Word. I deleted Office XP using the add and delete programs, then reinstall the file. The message "the C: \ WINDOWS \ Installer file exists and cannot be installed. Please delete this file or end the installation: \ This file cannot be found in WINDOWS. How can I reinstall Office XP?
A: You can go to /? Id = 290301 download a Windows Install Clean Up. After installing this tool, clear the residual Office XP information in the system. After cleaning, you can reinstall the tool.

Cancel "Office Automatic Optimization Program"
Q: After my system is turned on, the "Office Automatic Optimization Program" dialog box appears frequently. If the "cancel" button is not clicked within five seconds, this program will be started and run for a long time, which is inconvenient. How can this problem be solved?
A: Open the Registry Editor and find the branch "HKEY_LOCAL_MACHINE \ Software \ Microsoft \ Office Version \ Common \ Tuneup" (if not, create a registry key ), right-click the blank area in the right pane, select "New> Dword Value", and name it "Disabled". Change the value to 1 (0 indicates that the Office Automatic Optimization Program can be started ), after modification, restart the system (note that "Office Version" is the Version number installed on the local machine ).

What is the MSOCache folder?
Q: After I installed Office 2003, I found a folder named MSOCache on the hard disk, which is several hundred MB in size. What is the purpose of this folder? Can I delete it?
A: In msocache, temporary files are stored after Office 2003 is unwrapped. After installing Office 2003, you can delete this folder. If you do not need to generate this folder during later installation, you can open the files \ Setup \ setup. ini file on the installation disc and copy the cdcac file under the [cache] section.
He = auto is changed to cdcache = 0. Save the settings, and then refresh the disk.

The installation page is displayed when the office component is started.
Q: I am using Office 2003. I don't know what operations I have performed a few days ago. When I open other components of word or office, the installation page of office always appears, each time, you need to click Cancel to open the software. However, after opening the software, the file to be opened is not opened. You also need to open the file from the "open" menu of the Software. How can this problem be solved?
A: Please First insert the Office installation CD, select repair, and then repair your office, so that the installation interface will not appear when you open the office component.

The system is fixed and Office cannot be used.
Q: I used the Windows XP system. Some time ago, after a system problem was fixed, the Office became abnormal during use. When I started the system, I required to download and install the program, the system also prompts you to insert the installation disc. If you cancel the installation, you cannot use this program. How can this problem be solved?
A: What you encounter is a problem that Windows installer requires the out-of-the-box feature. It is sometimes incorrectly activated. To disable this function, enter "gpedit" in "run. MSC, open the Group Policy Program, and expand "Computer Configuration> Manage template> Windows Components> Windows Installer> Disable Windows Installer" in sequence ", in the "Disable Windows Installer properties" dialog box, select "allow" and click OK to exit. In the future, Windows Installer will not be automatically activated when you start Microsoft Office. In addition, if you are using the office
2000, you can open the Registry Editor, find the "HKEY_CURRENT_USER \ Software \ Microsoft \ Office \ 9.0 \ Common" directory, and delete the value of "UserData. In this way, when you re-open the Microsoft Office program, the program prompts you to enter the user name, but does not automatically run Windows Installer.

Enable the system to not detect the soft drive during startup
Q: After I have installed Office XP in Windows XP, the software drive is detected every time I start the system. How can I cancel the test?
A: After the Office is installed, if you do not want to automatically scan the software drive after it is started, you can remove the new Office-related project under the "Start" project in the Start Menu. In addition, the recently used files listed in the "document" and recently used Office files are stored on disk A, which may also cause this problem, therefore, you need to clear the list of recently used documents in the taskbar attribute and delete "C: \ Documents and Settings \ Me \ Application Data \ Microsoft \ Office \ Recent "(assuming that the current user name is Me and Windows XP is installed on disk C) links to related files in the folder.

Why cannot I delete some files?
Q: When I delete an Office folder set to shared in the shared document, a prompt box is displayed, "An error occurred while deleting the file or folder -- AW cannot be deleted. DLL: access is denied. Please make sure that the disk is not full or is not write-protected and the file is not in use ". I have encountered many operations similar to the above problems. Therefore, I would like to ask what causes this problem and how to solve it?
A: Some files cannot be deleted. Apart from the obvious reasons such as the file being set to read-only or the write protection on the disk, there are two possible causes, first, a resident background program is using the file or has used the file. The solution is to close the program or end the process with the task manager; second, a disk error occurs during file copying and running, leading to the inability to delete the file. The solution is to enter safe mode or command line mode (or DOS ), delete the file.

Why does the Office not display recently used files?
Q: My computer is installed with Office XP. When using Word, Excel, and PowerPoint programs, the "Files" list in the menu bar does not contain recently used files, in "Tools> Options> General", I have selected "list the number of recent files as 4". How can I solve this problem?
A: solution: Enter "regedit" in "run" to open the Registry Editor, find a binary value named "NoRecentDocsMenu" under the HKEY_CURRENT_USER \ Software \ Microsoft \ Windows \ CurrentVersion \ Policies \ Explorer branch and delete it or change the value to 0, after the restart, the recently used files will be restored in the "Files" menu.

How to Use Word to send files
Q: I have installed Office 2003 in Windows XP. After setting an article in Word, I want to use the "file/send/email recipient" function to send it to my friends, there are many buttons on the toolbar that appear, but the "send copy" button cannot be found, so the file cannot be sent, and the software cannot be fixed or reinstalled after being uninstalled. How can this problem be solved?
A: The "send copy" button is missing because the email account is not configured in Outlook, so Word does not know which account should be used to send files through which mail system. After knowing the cause of the problem, it is easy to solve it. Run Outlook, select "Tools> email account", and select "Add new email account" in the pop-up window ", follow the prompts to configure the email account step by step. After the email account is configured, the "send copy" button appears.

Why is there no m3-like symbol?
Q: We can insert "m2" in the Word by selecting "insert → special symbol", but our commonly used cubic meter symbol cannot be inserted. Is there any solution? Can I create a cubic meter symbol similar to "m3" by myself? If the superscript is used, a copy of the image outside the Word is changed to the m3 format.
A: "m2" is a symbol defined in the "CJK compatible Character Set" in the Unicode Character Set, it also contains ten symbols, including "Hour, hour, and hour", and does not have "m3 ". In addition, Unicode has become a standard uniform encoding and therefore does not allow custom symbols. Therefore, we are sorry that your requirements cannot be met, when you need to use "m3", you can only select DOC, PDF, and other document formats that support uploading.

How to clear items on the Word Toolbar
Q: Some software has been installed recently, and many projects have been added to the Word toolbar. After all recently installed software is uninstalled, the items on the toolbar cannot be cleared. How can I clear the items added by other tool software to the Word toolbar? I use Windows XP.
A: The tool software generally adds a template file to the Word startup directory to realize the purpose of adding a project to the Word toolbar. If the uninstall program is not complete, the tool software has been deleted, but the project in the Word toolbar still exists. In this case, you can manually delete them using the following method. Open the "C: \ Documents and Settings \ your user name \ Application Data \ Microsoft \ Word \ STARTUP" folder (the specific drive letter path should be determined by the system installation location ), if there are files not added by the user, delete them all. To ensure the effect, you can also
C: \ Documents and Settings \ User Name for logging on to the system \" "dot" is the keyword for searching. In this way, you can find some template files hidden in other locations, find them, and then back up and delete them.

How to quickly Merge multiple Word documents
Q: I have a large number of Word documents and want to merge them into one document. But copying and pasting is too slow. Is there a way to merge them quickly?
A: First, store the multiple Word documents to be merged in the same folder, create a new blank document, and select "insert → file" in the menu ", in the displayed "insert file" window, select the preceding folder and drag the mouse to select all files (or use the "Ctrl + A" shortcut ), click the insert button to merge all documents.

How can I change the Chinese quotation marks into English quotation marks?
Q: I used Word 2000. I found that every time I copy and paste the content from Word 2000 to notepad, email, QQ dialog box, and other places, Chinese quotation marks ("") the quotation marks ("") are very annoying. How can this problem be solved?
A: This is a bug in Word 2000. This problem has been solved in Word XP. We recommend that you upgrade it to Word XP. If you cannot upgrade to Word XP, you can save the Word document as a text file, open it with notepad, WordPad, and other programs, and then copy the above content. The Chinese quotation marks will not be changed to English quotation marks.

Retrieve the lost word menu
Q: it may be because of misoperations. Some menu items in my word are missing and cannot be set no matter how I set them. How can I retrieve the lost menu?
A: All settings in Word are stored in the default template normal. Dot file, so you only need to recreate the file. Click Start → find → file or folder. In the displayed dialog box, enter normal. dot. The search scope is set in the partition where the Office installation file is located. Click "Search" to delete the file. When the word is restarted, the file is re-created and the default parameters are applied to restore the deleted menu.

Retrieve the menu bar of Word 2000
Q: I am using Office 2000. I don't know what operations I have performed a few days ago. The menu bar of Word 2000 is missing and I haven't found it back using some simple methods, I cannot reinstall Office 2000. What should I do?
A: click "Start> Run" and enter "regedit" to open the Registry Editor. Find or create the "HKEY_CURRENT_USER \ Software \ Microsoft \ Office \ [Office Version] \ Word \ Data" item, change "Data" name to "Olddata", save and exit. (Note: [Office Version] The specific values are as follows: Office 97 is 8.0, Office 2000 is 9.0, and Office XP is 10.0 ). After completing the settings, save and exit the Registry Editor. Open your Word and you will find that the menu bar is restored.

Word toolbar missing
Q: I am using a Windows XP operating system. Today I found that the menu bar and toolbar of Word 2002 are all lost inexplicably. There is only one editing interface left. Follow the previous method: delete normal. after dot, open the Word again, but it still does not work. What should I do?
A: Close all Office applications, click Start> Search, enter Normal in the search box, set the search target to C:, and click search, delete the file starting with Normal, and open "C: \ Documents and Settings \ <your username> \ Application Data \ Microsoft \ Word \ STARTUP ", delete the content, open "C: \ Program Files \ Microsoft Office \ OFFICE10 \ STARTUP" (assuming that the Office is installed on disk C), delete the content, and finally Run regedit, find HKEY_CURRENT_USER \ Software \ Microsoft \ Office \ 10.0 \ Word, export the root key as the REG file, back up the file, delete the root key, and close the registry editor, restart Word. If you can only see menu items but cannot see the toolbar, you can click "View> toolbar" in the menu and select the required toolbar.

Error prompted when starting Word
Q: I am using Windows XP. I installed Office 2000 some time ago (the installation process went smoothly). Now, when I open Word, I always prompt "AUTOEXEC ", however, Word can also be started normally. Why?
A: When editing a document, your Word program loads an AUTOEXEC macro. You can solve this problem by opening the "template and add-on" column in the Word toolbar and adding an additional "xxx. dot ", this is the automatically loaded macro, you just need to delete it according to the full path.

Automatic shutdown during Word running
Q: The system installed on my computer is Windows 98. When you run Word 2000, a "server busy" dialog box will pop up several minutes. The content is: "Because the Microsoft Word program is busy, this operation cannot be completed. Click the correct button on the taskbar to start the program and solve the problem ." What is the reason?
A: Generally, this is caused by viruses, which damage the Word application. First, use the latest anti-virus software to scan and kill viruses. Then, create a new word file, select "Help> detection and repair", and insert your Office installation CD as instructed on the screen, the damaged Word program will be repaired in a few minutes.

Sort out documents copied from the Internet
Q: I often download some materials, copy them from the Internet and paste the materials in Word and notepad. After the materials are pasted, they are always arranged in length and length. How can I arrange them neatly?
A: We recommend that you use WPS2002 or a later version to copy and paste the documents to a blank document in WPS2002, and execute "tool> text> Delete space at the beginning of the section ", clear all spaces at the beginning of the section. Execute "tool> text> Add space at the beginning of the section" to add a uniform space for each section (2 Chinese characters by default ); execute "Tools → text → Delete blank segments" to delete all blank lines. Finally, set the font, Font, and font size, and the document will be displayed in a neat manner.

Disable Automatic hyperlink replacement
Q: When I type an e-mail address in a Word document, Word automatically converts it to a hyperlink, which affects editing efficiency. Will Word be prevented from automatically converting the email address to a hyperlink?
A: You can disable the function of automatically replacing Internet and network paths with hyperlinks in Word: click the "Automatic Correction option" command in the "Tools" menu, click the "Apply format automatically when typing" option, and under "replace automatically when typing", deselect the "replace Internet and network path with hyperlink" check box.

Insert an Excel table in Word
Q: I want to write an annual summary recently. I want to copy some Excel sheet content into an image and insert it into a Word document. Someone tells me that I can use the PrintScreen key to capture it, however, the captured images must also be cropped or scaled. Is there any better way?
A: You can select the cell area to be copied to an image. Press Shift and click the "edit" menu and select the "copy image" command to bring up the "copy image" dialog box, by default, select "as screen" and "image" for "appearance" and "format", and click "OK. Then, the selected table area is copied as an image. To paste them out, you only need to press the Shift key and then click the "edit" menu and select the "paste image" command (or do not press the Shift key, select the "select Paste" command from the "edit" menu and paste it as an "image"). In addition, you can paste it into other software.

Strange phenomenon in Word
Q: When I recently used Word, I found a small problem. Every time I input "C" in the article, it is not "C" but a small "C" with an external circle. I don't know why, how can I restore to normal?
A: This is because of the automatic replacement function of Word. You can cancel automatic conversion by setting the following method: click "Tools> automatic correction options" in the Word window ", in the displayed window, select the "Automatic correction" tab, select the "(C)" item, and click "delete.

Batch change font in Word
Q: I wrote an article in Word. When I modify it again, I need to replace all the text in the quotation marks with a large italic. It is very troublesome to modify the text one by one, is there any way to modify it at one time?
A: open the file, select all the articles, click the "Edit> Replace" command, open the "replace and search" dialog box, and click the "advanced" button below, select the "use wildcard" option, enter "*" in "search content", click "Replace with", select the "format" below, and select the "font" option, in the pop-up "Search font" dialog box, set the font to "" and click "replace all ", in this way, you can replace all the text in quotation marks in the article with the italics.

Remove the line from the Word Header
Q: When I recently used Office XP to edit documents, I inserted a header in Word and found that there was a straight line in the insert. can I remove this line?
A: You can remove it. Click "View> header and footer", click "page settings", select "layout", click "border", select a border, and click "NONE ", then, select "section" under the application, and click "OK.

Formulas cannot be displayed in Word.
Q: The edited formula in Word 2003 cannot be displayed. It is displayed as a box. What should I do?
A: Word uses the formula entered in the formula editor as the graph. The edited formula is displayed as a box because the "image box" function is mistakenly enabled, this function allows the Word to display a blank box to replace each image in the document. To disable the "image box" function, click "Tools> options", click the "View" tab, and clear the "image box" check box under the "display" title, click OK. How are you doing? The formula you want to see is coming soon.

How to ensure that the slide font remains unchanged
Q: I used PowerPoint 2003 to create a slide, Where I used some pretty fonts downloaded from the Internet, however, the beautiful text played on my computer has become a rigid font in other people's computers. Is there any way to keep the font of the slides unchanged?
A: Your requirements are easy to implement. As long as you embed the beautiful fonts used in the PPT file into the file, the font will not change on any computer. The specific method is as follows: open the edited slide file, click "File> Save as", select "Save option" from the drop-down menu of "Tools" in the pop-up window, and select "embed TrueType font ", select "only Embed characters used (applicable to reduce file size)" or "embed all characters (suitable for editing by others)" as needed, click "save" to generate a slide file with a new font.

Extract images from the PPT
Q: My friend sent me some PowerPoint slides with many exquisite images. I really want to extract the images from them. I don't know how to do this?
A: You can open the slide file of the image to be extracted in PowerPoint and click "File> Save As webpage". In this way, you can find the image used in the slide in the generated folder.

Cannot open the PowerPoint File
Q: When I used PowerPoint to create a slide, the system suddenly exited. After saving the document as prompted, I started it again and gave the prompt "The registered converter is not found, and PowerPoint cannot open the file, how can this problem be solved?
A: This problem may occur because your system's virtual memory is too small. Please adjust it as appropriate. To restore this document, first find the Office installation CD, run the installer and select "converter", then reinstall it, and then open the Temporary Folder, find the temporary file with the same name as the error file (with TMP as the extension), or use the system search function to change its extension TMP to PPT and then open it. In this way, the slides you have created will be displayed normally.

The object animation effect cannot be demonstrated.
Q: I have installed WPS 2003 for education, but I found that the slides created using PowerPoint 2000 are played in Jinshan demonstration 2003 instead. When setting the animation effect of objects on the demo page, click "demo playback" on the main menu. The "Object Animation" displayed is gray and disabled. What should I do?
A: When Using Jinshan demonstration 2003, "Object Animation" cannot be used after you click the text box because no object is selected. When you click the text box, press and hold the left mouse button for about 2 seconds to release it. (Note that there is no insertion point in the text box after the text box is selected ). After correctly selecting the text box, click "demo playback" on the main menu and "Object Animation" to use it.

Reduce the size of PowerPoint Documents
Q: I often use PowerPoint to make some courseware. Sometimes there are a lot of pictures in the slides, so it is very inconvenient to copy the files, is there any way to reduce the size of the created file?
A: Open the slide file first. If the image toolbar is not opened, click "View> toolbar> image" on the menu to open the image toolbar. After opening the image toolbar, click the "compressed image" button above to bring up a compressed image dialog box. In the application, select "All images in the document" and save the file. This will make the file much smaller.

Can I protect the slides from being modified?
Q: Can I protect slides in PowerPoint like in Excel to prevent others from modifying them?
A: Yes. Take Office XP as an example. You only need to select "Security Options" in the "Tools" drop-down list and set the password in "Change permission password, users who do not know the password cannot modify the password. Operations in other versions of office are similar.

How to demonstrate three-dimensional images in PPT
Q: I used PowerPoint 2000 to design a slide. I wanted to use a mouse to flip a three-dimensional image during the demonstration so that I could see its different sides, however, the free rotation button in PowerPoint 2000 turns gray. What should I do?
A: The free rotation of PowerPoint cannot reach the expected three-dimensional rotation, nor can it work on the inserted object. To solve your problem, you must use the PowerPlugs: Transitions plug-in (, which can easily add more 3D effects to your presentation, it includes 12 styles and more than 70 3D effects, such as rotating squares.

Show guides in PowerPoint
Q: I have heard that you can use guides to align objects in PowerPoint. How can I display and use guides?
A: The guides are water and vertical lines used to align objects visually. You can add, delete, and move guides. If the guides are not displayed, click "Guides" in the "View" menu to display them. Follow these steps to use the guides to align an object: ① drag the guides to locate the objects to be aligned. ② Drag each object near the guides, so that the center or edge of the object will automatically align the guides.

View Hotmail in Outlook 2000
Q: I often use Hotmail to send and receive mails. Although Outlook Express supports access to the Hotmail email account, I want to use Outlook 2000 to access the Hotmail email account, how can I implement the functions I want?
A: Although Outlook 2000 does not support Hotmail email account integration, you can view Hotmail emails in Outlook by creating a Hotmail folder, then link the folder to the Web View of the Hotmail Web site. ① On The View menu, click the folder list to open the folder list. ② Right-click Outlook today, and then click Create folder. Name the folder Hotmail and click OK. Now, your "folder list" should contain a Hotmail mail project folder. ③ In the folder list, right-click
In the Hotmail folder, click Properties. ④ Type A in the address box on the home tab. ⑤ Click to select the default home page that displays the folder, and then click OK. Now, when you click the Hotmail folder in the "folder list", you will see the option used to log on to your account. You can
Drag the Hotmail folder to the Outlook bar to add a shortcut to the Hotmail folder.

You cannot open a webpage when reading a letter.
Q: When I use OE to read some emails, I often automatically call up IE and open some advertisement webpages. Is there a way to prevent them from automatically opening when I watch the emails?
A: JavaScript is used to automatically open the webpage. In OE, select "Tools> Options> Security" and set "security region" to "restricted site region "; open Internet Options of IE, select restrict site on the Security tab, and click "Custom Level, in the window that appears, set all "script" options to disabled.

Backup contact address of Outlook
Q: I uploaded the mobile phone contact address to the Microsoft Office Outlook 2003 contact, backed up the entire Microsoft Office folder, formatted the C drive, reinstalled the system and Office 2003, and restored Outlook 2003, however, when the contact is opened, the original contact disappears. What is the contact address of Outlook 2003?
A: By default, the contact address is stored in C: \ Documents ents and Settings \ username \ Local Settings \ Application Data \ Microsoft \ Outlook by default, we recommend that you back up the content in this folder during Backup.

The address in the address book is missing.
Q: I have been using Outlook Express. The mailing addresses of my friends and colleagues exist in the address book. Due to accidental operations, the computer experienced a blue screen fault. After restarting, the address book in OE was found to be blank. How can I retrieve the lost address?
A: Open the search file dialog box and search. WAB file, find "ll. WAB and LBG. wab. wab is the address book containing the address. copy WAB to LBG. the folder where wab is located, and then put LBG. rename WAB as lbg1.wab, and then rename ll. rename WAB to LBG. wab.

Open the attachment in OE
Q: I used Windows Update to pack a patch for my computer, but I didn't expect that after Outlook Express 6 rose to 6.1, all attachments in the emails will be gray and cannot be opened. What should I do?
A: Open Outlook Express, select "Tools> options", select "security", clear the "Do Not Allow save or open attachments that may contain viruses" check box, and click "OK.

Why can't OE be used normally?
Q: I have installed Windows XP, and everything else works normally after installation, but Outlook Express cannot be started. Internet access is normal. If IE is 6.0, the following message is displayed when you start Outlook Express: you cannot start Outlook Express. Outlook Express requires Outlook Express 4.01 or a later version. I can't reinstall Office XP, But I Can't reinstall IE. How can this problem be solved?
A: The error message is that Outlook Express is not correctly installed and has nothing to do with Office XP. You can use the "Add/delete Windows Components" option in "add or delete programs" on the Control Panel to uninstall and reinstall Outlook Express.

Access File Security Warning
Q: I installed Office 2003 under Windows XP, but a security warning prompt will appear when I double-click the access file to open it, select "yes" and "open" to open these documents normally. However, if you start the access program first and then use the open command under the "file" menu to select the file to open, the above prompt will not appear. What is the problem?
A: This is an office security warning for "insecure expressions". For common users, you can disable it so that similar prompts are not encountered. The procedure is as follows: Start access, point to macro on the "Tools" menu, click "security", click the "Security Level" tab, and then click "low ......", Click OK to restart access.

Excel files cannot be saved separately
Q: I am using Windows 98. A few days ago, when I opened an Excel file and wanted to save it as a file, the system prompts that the file has been saved as a temporary file, click "OK". After you confirm, the Excel file is closed. Why?
A: You can delete the saved temporary file and save it again. First, delete all temporary files in the \ windows \ Temp folder in the system partition, then, go to the Excel file storage location to clear the files with the TMP extension (these files are generally hidden, you need to set "show all files" in "Tools> Folder Options> View "). After the temporary files are cleared, open the Excel file again, and you can choose to save it.

Quickly copy data in Excel
Q: due to business needs, I have to copy a column of data in an Excel worksheet to a row of data in another table. How can I convert rows into columns? I used to use the manual drag method. It is troublesome. Is there a simple way?
A: select and copy the row of data. In the blank document that is opened, use the "select Paste" command under the "edit" menu and select "unformatted text" for pasting, open the "search and replace" dialog box, enter "^ t" in "search content", enter "^ P" in "replace", and click "replace all ", paste all the data back to excel.

How to quickly enter time in Excel
Q: As work requires, I need to input a large number of the same time formats in Excel. For example, "15: 15" indicates 15 minutes and 15 seconds. What I want to ask is, is there a way to set the cell format so that when I input "1515", the Excel file can be automatically changed to "", and the input time can be calculated in Mathematics (such as average value )?
A: It is difficult to use Excel alone to complete this task. However, you only need to copy and paste it twice between Excel and Word: first, enter the required data in "1515" format in Excel; then, select all input data, right-click the selection area, and select "set cell format ", in the displayed "cell format" window, select the "Number" label, select "Custom" in the "category" list, and enter "##" under "type" on the right: "#" (the outer double quotation marks are not included. Note that the colon and double quotation marks on both sides are punctuation marks). Then, the "example" above is displayed, however, at this time, the data format is not time. If the average value or other mathematical operations are performed, an incorrect result will be obtained. Therefore, you need to create a new
Word document: select all the data in Excel again, copy and paste the data into the Word document, and generate a Word Table. Finally, you only need to select the Word Table and copy it to the new Excel worksheet again, you will find that all the data is displayed in the form of "XX: XX", and the cell format has been automatically set to "time h: mm ", in this way, you can perform the necessary mathematical operations.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.