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.