Simple clear advice in plain English

PC help: Feel the merge

Merge cells in Microsoft Works spreadsheet

Although it is not technically possible to merge cells in a Microsoft Works spreadsheet in quite the same way as it is in Excel, there is something of a workaround available.

If a title needs to span several columns, for example, start by typing the relevant text into the far-left cell of the row in question.

Now select all of the cells the title should span and open the Format menu and select Alignment. In the lower portion of the dialogue box, select the option labelled ‘Center across selection’ and click on OK.

Article tags

Reader Comments

   

Add your comment

All fields must be completed. Your email address will not be displayed or used to send marketing messages.

All messages will be checked by moderators before appearing on the site.

See our Privacy Policy for more information.

Related articles

Using Wizard to create a form

Create a good Base for your data

Databases may sound very dreary but they are behind almost everything we do. We explain how to go about starting one of your own using Libre Office Base

iTunes' Get Track Names screenshot

Get your music collection tagged

Every music file contains a lot of hidden information, not all of it correct. We explain how to get your collection sorted, labelled and correctly tagged

Word's undo feature

How to fix common PC errors

It’s easy to hit the wrong key when using a PC and throw yourself into a panic. There's no need to worry - we have easy fixes for 30 common everyday errors

Question & Answer

Q.Is my phone’s Bluetooth any use?

> Read the answer

Q.Can I switch boot drives so that I can work on older...

> Read the answer

Q.Can I open my old genealogy files or have they gone...

> Read the answer

Best deals on the web

img

Apple iMac 21.5" (MC309)

£927.29- Buy it now

img

Dell Inspiron 620 ST Intel Core i3-2100 3.10GHz / 3GB / 500GB / DVDRW / Win 7 Home Premium

£329.00- Buy it now

img

ZooStorm 7877-1023

£386.38- Buy it now

Latest issue & subscription deals

Poll

Are you concerned about viruses that target mobile phones?

Jargon Buster

Computing terms explained in plain English

Restore point

A Windows backup of system files and settings.

Great shopping deals from Computeractive