Select the Window menu again and select Unfreeze Panes. If you encountered a bug or want to suggest a feature in Microsoft Office, we recommend you contact Microsoft Support. We are not a division, a subsidiary, or a contractor of Microsoft Corporation, and we are not responsible for their decisions. Also, we are not responsible for access configuration or software updates in your company. Contact your company support team and install latest updates before asking questions.
We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. How to freeze columns and rows Excel You can freeze your column and row labels so that you can view them no matter how far you scroll down or to the right in your worksheet. To freeze row or column headings or both , follow these steps: 1.
Failed to send the question. Please try again. If your antivirus software includes integration with Excel you may experience performance issues. In this case, you can disable all Excel integration within the antivirus software. Or, you can disable any antivirus software add-ins that are installed in Excel.
Important: Changing your antivirus settings may make your PC vulnerable to viral, fraudulent or malicious attacks. Microsoft does not recommend that you attempt to change your antivirus settings.
Use this workaround at your own risk. You may have to contact your antivirus software vendor to determine how to configure your software to exclude any integration with Excel or to exclude scanning in Excel. If the methods that were mentioned earlier did not resolve your issue, the issue could be either file specific, or environmental. The following section describes how to troubleshoot additional issue that can cause Excel to hang, or crash.
Environmental factors are just as important as file contents, and add-ins when you are troubleshooting crashes. You can help determine the cause of your issue by taking the following actions:. Moving the file locally will help determine whether there is something wrong with the file, or with where the file is saved. Several issues can arise when you save an Excel file over a network or to a web server. It is a good idea to save the file locally.
This should be done in the following scenarios:. For more information about Microsoft software that is running in a virtualized environment, see the following article: Support policy for Microsoft software running in non-Microsoft hardware virtualization software. Excel files can grow fairly large when you start adding lots of formatting and shapes. Make sure that your system has enough RAM to run the application. For system requirements of the Microsoft Office suites, go to the following Microsoft articles:.
System requirements for Office System requirements for Office System requirements for Office System requirements for Excel Office introduced native bit versions of Office products to take advantage of larger processing capacities. To read more about bit editions of Office, go to the following Microsoft articles:.
When you start Excel, it examines the default printer and video drivers that will display your Excel workbooks. Excel is printer-intensive, and it will run slower when Excel files are saved in Page Break Preview view. Testing a file by using different printers such as the Microsoft XPS Document Writer printer driver, or the VGA video driver will determine whether the problem is with a specific printer or video driver.
If you still have hanging or crashing issues in Excel after you work through the resolution methods that are mentioned here, you should contact Microsoft Support for guided troubleshooting. You can always ask an expert in the Excel Tech Community or get support in the Answers community. Troubleshooting and support. Excel issues. Excel not responding, hangs, freezes or stops working.
Need more help? Join the discussion. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical.
0コメント