See all Microsoft Excel tips
Strategy: Follow these steps to correct this.
1) First, hit Ctrl+1 to open the Format Cells dialog. On the Alignment tab, look in the Text Control section. The Wrap Text choice is probably a grey checkmark, as shown in Fig. 1322. This means that for some cells in the selection, the Wrap Text property is on, and for others it is off.
2) You want to turn the Wrap text property off. The first mouse click will change the grey checkmark to a black checkmark. The second mouse click will turn off the checkmark, as shown in Fig. 1323.
After this step, you can see more rows, as shown in Fig. 1324. You still need to make the columns wider.
3) From the menu, select Format – Column – Autofit Selection. You can now see the bank statement, as shown in Fig. 1325.
Summary: Data pasted from web pages will often have the Wrap Text property turned on. This prevents the AutoFit selection command from working.
Commands Discussed: Format – Cells – Alignment – Wrap Text; Format – Column – AutoFit
See all Microsoft Excel tips
