

Now click AutoFit and select Fixed Column Width. Note that this is not the Layout tab that is always on the ribbon – don’t get the two confused! Go to the Layout tab on the right-hand side that only appears when you are within a table. To turn off AutoFit for table columns, put your cursor anywhere inside the table you want to change. It’s a good starting point or approximation but often you’ll need to turn AutoFit off and do the final table adjustments yourself. Tables get pushed beyond the right-margin or a single line widens a column unnecesarily. Sometimes you don’t want this and want to be able to control the column widths yourself.ĪutoFit for Word tables is great but sometimes gets too enthusiastic. If you think this may be the root of the problem, the only thing you can do is to recreate the hyperlinks.Word will automatically adjust or Autofit the width of table columns and the space within cells to fit the content that you are entering. Click on OK to close the Excel Options dialog box.įinally, the problem may not even be related to Excel it is possible that the program is getting a bit confused if you changed your default browser after you originally created the hyperlinks-especially if you deleted whatever browser used to be your default.Click on OK to close the Web Options dialog box.
How to turn off hyperlink in word 2007 update#

If that is not the problem, you may want to turn off an option in Excel that causes the program to check hyperlinks whenever the workbook is saved. The Advanced options of the Excel Options dialog box. If this is the case, you will need to either change the name of the worksheet back to its original name, or you will need to recreate the hyperlinks to point to the renamed worksheet.

The second time the hyperlinks were all gray and would no longer work, and she's at a loss as to why this occurred.

Those hyperlinks worked fine until Fanie saved and reopened the workbook. In the first worksheet she created hyperlinks to the second worksheet. Fanie has a workbook with two worksheets.
