Teach Yourself Excel Lesson 7 - Change Column Width
Change Column Width
Having entered your data in the previous lesson, You'll immediately notice that you cannot see all the data as the columns are too small.
We'll need to increase the column widths
Steps:
- Select cell A1
- Press CTRL + A
- This selects the data we entered
- Press CTRL + SPACE
- This selects all the columns that the data we entered are in
- Press in sequence: ALT then O then C then A
- This changes all the column widths so that you can see the headings.
- Select cell A1
Now, you'll see:
Your sheet should now look like this
Next lesson: Teach Yourself Excel Lesson 8 - Data Validation
Training Video on how to Change Column Width in Excel:
Attachment | Size |
---|---|
change-column-width.xls | 17.5 KB |
»
- Nick's blog
- Login or register to post comments
- 15708 reads
Recent comments
5 years 47 weeks ago
6 years 33 weeks ago
6 years 45 weeks ago
6 years 48 weeks ago
6 years 49 weeks ago
7 years 2 weeks ago
7 years 10 weeks ago
7 years 11 weeks ago
7 years 11 weeks ago
7 years 11 weeks ago