It is more flexible to use the Format Cells window, rather than choosing the Merge and Centre option when adding titles that run over several Excel cells
Save time by keeping all the tools you use most frequently close at hand by adding a MyTab heading to Office 2010's ribbon
Excel's Paste Special tool lets you select the parts of the spreadsheet you want
If you've had your PC a long time, the prospect of switching all your files, folders and data seamlessly and safely may be daunting. We show you how easy it is
Since Microsoft changed the look and feel of Office 2007 with the ribbon it has worked its way into most applications. We show you how to get the best out of it
Outlook 2010 is able to email your Excel 2010 spreadsheets. All you need do to facilitate this is make a few changes to your settings
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
The error message a reader is getting is because he may have typed a space in the cell, which is confusing Excel when doing the spreadsheet calculations
Excel is a worthy program but it takes time to work out what to do with all those cells and columns. We list 12 top tips to help you get the most out of it
When learning to use a new program it's very easy to press the wrong key and lose a vital toolbar. Luckily it's just as easy to get it to reappear – if you know how
It's easy to mark off figures you've checked using a pencil and paper, but not so good with Excel. Libre Office lets you cross through cells quickly and easily
If you have a large spreadsheet in Excel it can be difficult to see the where you are. Using groups will add icons that can be quickly collapsed or expanded
A free family tree application may be a better option
Q.Why are some of the keys on my keyboard doing strange...
Q.Is my phone’s Bluetooth any use?
Q.Can I switch boot drives so that I can work on older...
Computeractive Ultimate Guide - Expert PC Tips
Price: £5.99
Computeractive Ultimate Guide - Cloud Computing
Price: £5.99
It's possible to cancel your TV licence, save a heap of money and still watch TV legally – although not in real time. We explain exactly what you need to do
|
|
|
|
|
Computeractive Excel (2010) Online tutorialPrice: £19.99 |
Computeractive Word (2010) Online TutorialPrice: £19.99 |
Computeractive Powerpoint (2010) Online TutorialPrice: £19.99 |
Angry BirdsPrice: £9.99 |
Back Issue CD-Rom 14 (2011)Price: £15.99 |