Best Answer

double click the line in between the columns

User Avatar

Wiki User

โˆ™ 2007-05-12 13:11:14
This answer is:
User Avatar
Study guides

What are advantages of Database Approach

What is a network that covers a large geographical area such as a city country or world

What is the worlds largest wan

What is a network server

See all cards
66 Reviews

Add your answer:

Earn +20 pts
Q: What can you click in the Column Width dialog box to show the automatically selects the best width the data in the column?
Write your answer...
Still have questions?
magnify glass
Related questions

How do you balance the columns in a newsletter so that each column contains the same amount of text?

manually set the column widths in the columns dialog box

What will happen if you check the row and column headings option in the sheet tab of the page set up dialog box?

The row and column headings will be on the pages that you print.

What is the small circle that selects a single dialog box option?

option button

What is used to create a cell name from column and row titles in Excel?

The following is copied from the Help dialog box in MS Excel 2000. A search for 'name cells' or 'cell label' should get the directions that you're looking for:Name cells by using existing row and column labelsSelect the range you want to name, including the row or column labels.On the Insert menu, point to Name, and then click Create.In the Create names in box, designate the location that contains the labels by selecting the Top row, Left column, Bottom row, or Right column check box.

How do you arrange columns so that they are in alphabetical order horizontally with Microsoft Excel?

1) Select the column (or columns) you would like to move (click on the letter at the top of the column). 2) Cut the column (Press Ctrl + x, click the cut button on the Home tab of the Ribbon, or right-click and choose cut) 3) Select the cell where you want the new table to begin. 4) Right-click in the cell and select Paste Special (or on the Home tab of the Ribbon, click the Paste arrow to display the Paste Special option) 5) In the Paste Special dialog box, select Transpose and click OK. After you have moved the contents from a column to a row, highlight the row and sort, as you normally would.

What key selects adjacent documents at the Open dialog box by holding down this key while clicking each document name?

The Ctrl key.

How do you make Firefox you default browser?

Make Firerox your default browser by going to 'Tools' -> 'Options'. In the Options dialog box navigate to 'Advanced' tab and under System Defaults column check the 'Always check to see if Firefox is the default browser on startup' checkbox.

Which button in the spelling and grammar dialog box will correct a word automatically if misspelled in any future documents?

auto correct

19 What is the purpose of the Autopick button in the plan a meeting dialog box?

to select automatically a time when all participants are available

How do I add 1.5 to a column in Excel?

If you have a list of values in one column and want values that are 1.5 higher in another you could have a formula to add them. So if you had values in column A, say in cell B2 you could add 1.5 to A2 like this, and copy it to the necessary cells: =A2 + 1.5 If you want to increase the value of the original cells, there is a special way of doing it. Type 1.5 into a cell. Select the cell. Do a copy. Select the cell you want to add 1.5 to. Go to Paste Special. In the Operation section of the dialog box pick Add. 1.5 will be added to the cell. If there is a value in the cell, it will change the value to the new one. If there is a formula in the cell, it will put +1.5 at the end of it.

How do you paste content of column of one sheet in the row of other sheet in open office?

In the source sheet: select the column cells with values (they must be contiguous but cells with no values are OK)In the destination sheet select the leftmost cell of the row where you want the valuesChoose the menu item: Edit>Paste specialA dialog opens in which, towards the bottom, in the Options section there is a radio button labled "Transpose" click that button so it is filledCheck if any other modifiers are to be used when pasting the valuesClick

How do you add 0.001 to whole column in Microsoft Excel?

Put the cursor on the cell with 0.001 in it. Do a copy, using the Edit menu or Ctrl-C or clicking the copy icon on the toolbar or whatever your preferred method is. Then select the cells you want to add the 0.001 to or click on the column heading if it is every cell in the entire column that you want to add to. Go to the Edit menu and select Paste Special. In the dialog box that pops up, click on the radio button beside Add in the Operation part and then click OK. 0.001 will be added to all the selected cells. If you don't see it coming up, go to the Format menu and make sure the cells are formatted to have at least 3 decimal places.

People also asked