Chennai Laptop Service
Laptop Repair Service In Chennai
Call 8681030184 ; 8754598732
Text Control: Wrap text, Merge and Centre
-- In cell E2, type the sentence “The room was booked in advance with a specified check out time.”
-- You will notice that the text will spill over to the next cell.
-- Select cell E3 and click the „Wrap text‟ icon in the „Alignment‟ group.
Insert a row above row 1.
-- In cell A1, type the header „Booking Details ‟.
-- Now select cell A1 and drag your mouse to select the cells B1, C1, D1.
-- Now click the „Merge & Centre‟ icon in the „Alignment‟ group.
-- The „Merge & Centre‟ option is used to merge selected range of cells to form one cell.
-- The cell will contain the information entered in the original (1st) cell.
Exercise:
-- Create a new workbook.
-- Enter the data of your choice into cell A1.
-- Align the information to the center of the cell (vertically).
-- Align the information to the left of the cell (horizontally).
-- Now enter a long sentence in cell B1.
-- Use the „Wrap Text‟ icon to fit the information into one cell.
-- Enter a long name in cell C1.
-- Use the „Merge & Centre‟ icon to fit the information into one cell.