answersLogoWhite

0


Best Answer

If you click right between the heading of two columns, when the mouse pointer changes to a double headed arrow, it will trigger an autofit. This will set the width of the column to be equal to the widest contents of a cell in the column. This may mean the column will get wider or narrower.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

11y ago

If you double-click the border between the headings of two columns in Microsoft Excel or Microsoft Access, you change the width of the left column to fit the widest cell in the column.

Here are a couple of tricks I learned accidentally: If you select several entire columns then double-click the right edge of the heading of any of those columns, you change the width of each of those columns to fit the widest cell in that column, just as if you had double-clicked the right edge of the heading of each column separately. If you select several entire columns then click and hold the right edge of the heading of any of those columns while you drag it to a new width and release, each of the selected columns becomes the width of the one you just resized.

This answer is:
User Avatar

User Avatar

Wiki User

12y ago

The column width is adjusted to fit the text

This answer is:
User Avatar

User Avatar

Wiki User

13y ago

you can type text into the cell

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What happens when you double click a cell in excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

When you double-click a cell with a entry Excel changes to what mode?

It changes to Edit mode.


How do you correct data all ready in a cell on excel?

Click on the cell and edit the contents in the formula bar at the top of the screen, double-click the cell and edit in the cell, or click on the cell and press F2 to edit within the cell.


Format cell in Excel?

To format a cell in excel right click on it, then on the thing that pops up click on format cell


Do you double click to do spell check in a cell on Excel?

No. You can do a single click on the Spell Check icon or just press the F7 key.


What is cell of the excel?

To format a cell in excel right click on it, then on the thing that pops up click on format cell


How do you clear cell entries in excel?

Click on the cell and press delete.


In Excel how is a cell selected?

The simplest way to select a cell is to click on it.


What do you do to start a new cell in excel?

Click in the cell you want to use.


How do you finalize a cell in Excel?

This question is not clear. There is no Excel process for "finalizing" a cell. When you are done making changes to a cell, just click to another cell.


How do you highlight in Excel?

You need to click on a cell and hold on, then drag it to another cell.


What is it called when you change the contents of a cell in Excel?

Editing.Editing.Editing.Editing.Editing.Editing.Editing.Editing.Editing.Editing.Editing.


When excel is in edit mode when you double click the cell content you can edit cell content directly in the cell?

Yes, you can do that.Yes, you can do that.Yes, you can do that.Yes, you can do that.Yes, you can do that.Yes, you can do that.Yes, you can do that.Yes, you can do that.Yes, you can do that.Yes, you can do that.Yes, you can do that.