BIS155 SBS_Lab1_Step3b

BIS155 - Step by Step Instructions Step 3b Format Spreadsheet A Separate the Header information and the summary information from the data Insert

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Step by Step Instructions Step 3b Format Spreadsheet A. Separate the Header information and the summary information from the data. Insert rows between Row 4 and 5 and between Rows 14 and 15. Select the row below where you wish to insert a row. From the Home Tab, Cells group, click the Insert command and select Insert Sheet Rows. B. Move the data in cells C17:D18 to cells A18:B19. Select the cells you wish to move. Hover your cursor over the selected cells until the cursor becomes a Move pointer: Drag the cells to A18. Notice that the formulas will not change when you move the cells. C. Hide columns D through M. Select Columns D through M. From the Home Tab, select the Format menu, Cells Group, Visibility Command, Hide & Unhide. Select Hide Columns.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
D. Merge and Center the data in rows 1 and 2. Select columns A through P. From the Home Tab, Alignment Group, select Merge & Center: E. Select all text and change the Font to Arial. F.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/10/2010 for the course MGMT 400 taught by Professor Frankenstein during the Spring '10 term at DeVry Chicago O'Hare.

Page1 / 8

BIS155 - Step by Step Instructions Step 3b Format Spreadsheet A Separate the Header information and the summary information from the data Insert

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online