Excel: Overtime Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 More

Insert Columns

Suppose we work for more than one company. How can we expand our time sheet to show that?

 

Add a new column

Select column A by clicking on the “A” column header. Now, go to the Home Ribbon and look for the Cells group. Click on Insert on the menu bar, and then click on Insert Sheet Columns.

 

There will be a new, blank column A. Click on cell A1 and type: Accounts.

Labels should be Bold

Select Row 1 and make the labels bold by clicking the “B” on the formatting bar.

 

Labels should fit

Select Row 1.

Go to Home ->Cells -> Format -> AutoFit Column Width

Home -> Cells -> Insert -> Insert Sheet Columns

 

  Microsoft Excel 2007 Exam 77-602 Topic: 2. Formatting Data and Content

  2.2. Insert and modify rows and columns: Insert a column or row above, below, to the left, or right