Software : Tutorial: Microsoft Excel shortcuts to save you time

---

Tutorial: Microsoft Excel shortcuts to save you time Posted: 30 Jul 2011 02:00 AM PDT Start speeding up the way you use Office Excel by setting it up to reflect your personal needs. Open Options from the Tools menu, File ribbon or Office button, then work your way through the options on offer. Set up how many worksheets you prefer new workbooks to contain from the General section, and choose a default format and location new files are saved to from the Save section. When entering data, make use of the Fill Handle to dramatically speed up data entry - just type in a figure, then click and drag the fill handle down or to the right to duplicate the number or formula in each of the selected cells. The Fill Handle can also speed up entering a row or column of consecutive dates, including days, months or years. Type the first entry as normal, then click and drag using the right mouse button - if you've typed Monday, for example, you can fill out weekdays or all seven days of the week as you drag by selecting the appropriate option. The Fill Handle isn't much use for entering the same figure in non-adjacent cells, but there's a workaround. Select the cells you wish to include by Ctrl-clicking each, then type the cell reference, number or absolute formula before pressing Ctrl and Return. Navigating a large spreadsheet can be a real hassle, so instead of manually scrolling to the cell in question, simply type it into the Name box and press Return to jump straight to it. If you frequently use a specific figure, such as VAT, in your workbook calculations, save time by defining it as a constant - switch to the Formulas ribbon and choose Define Name. Type the term (VAT in our example) into the Name box and its amount (20) into the Refers to box before clicking on OK. Now just type VAT instead of 20 into your formulas, and when the VAT rate next changes, you can update the entire workbook to the new rate simply by changing the figure for VAT in the Name Manager. The quickest way to enter an unknown formula is to click the fx button and then follow the wizard to choose the appropriate one for your needs. Office Excel 2007 and 2010 users will also find a host of formulas conveniently organised into categories on the Formulas tab. When copying and pasting formulas from one cell to another, they're treated as relative, which means the cell references are based on where the cells are in relation to the cell containing the formula. Quickly create absolute formula references using the $ character, so cell A1 becomes $A$1, for example. Last, but not least, if you need to style your spreadsheet in Office Excel 2007 or 2010, make use of the Cell Styles function instead of manually highlighting or colouring cells. Select an already formatted cell, then click the Cell Styles button on the Home tab and choose New Style. Name it up and click OK - in future, click Cell Styles again to format your cells from the Custom section. Quick-fire charts The quickest and easiest way to create a chart in Office Excel isn't Chart Wizard - just select the cells you wish to include in your chart and then press F11. The Chart Wizard is bypassed and a chart instantly appears on the screen. Once that's done, just right-click on the various elements to customise the chart. Excel shortcuts Alt and Return: Start a new line in the current cell instead of moving to the next one. F11: Generate a chart from the currently selected data. Shift/Ctrl and Space: Select the current row/column. Alt and =: Total the selected cells. Ctrl and Shift and $: Format selected cells as currency with two decimal places. Ctrl and ;: Insert current date. Ctrl and Shift and ': Paste value from the cell above. Shift and F11: Insert a new worksheet. Ctrl and PageDown/PageUp: Move between worksheets. Ctrl and D/R: Fill cell with the contents of the cell either above (D) or to the left (R).

You are subscribed to email updates from TechRadar: All Applications feeds To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610

Software : Office for Mac 2011 with Lion features coming 'in months'

---

Office for Mac 2011 with Lion features coming 'in months' Posted: 29 Jul 2011 02:29 AM PDT Microsoft has revealed that Office for Mac 2011 will be updated to incorporate Mac OS X Lion features, with the upgrade arriving in a matter of months. Pat Fox, from Microsoft's Office team blogged that the software would be getting Auto Save, Versions and fullscreen mode support. He also explained that the wait for the new software will be "measured in months not days", meaning a release date is still a little way off; not brilliant news for users who have already upgraded to Lion. Word processing Meanwhile, he confirmed that Office for Mac 2004 "will not (ever) work on Lion", due to the absence of the Rosetta code needed to make the Lion OS compatible, adding that "Now would be a great time to upgrade to Office for Mac 2011 if you're upgrading to Lion!" Mac users getting frustrated with repeated crashes in Lion can download a new update for Communicator for Mac, however, which should solve some issues. The update should be pushed through on Microsoft AutoUpdate in the next few days.

You are subscribed to email updates from TechRadar: All Applications feeds To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610

Apple : iPhone 5 UK release date mid-September?

---

iPhone 5 UK release date mid-September? Posted: 28 Jul 2011 05:13 AM PDT The iPhone 5 UK launch may be the second week of September according to a new report from China Times, while the much-rumoured iPad 3 may follow in November. The paper cites sources at Chinese suppliers who claim that Apple has put in an initial order for 4 million new iPhone units, with suppliers already lining up 400,000 trial units. There have been myriad reports that the next iPhone will launch at what is traditionally Apple's iPod event this September; usually Jobs and co treat us to new phone hardware at WWDC in June, but the iPhone 5 was conspicuous in its absence at this year's conference. A September launch seems to be growing ever more likely, with 'fall' also pegged as the iOS 5 release date; however, this new report is the most specific yet and we're not completely convinced about the second week of September itself. Rumour mill Meanwhile, rumours that Apple will again break with tradition and launch a third iteration of the iPad towards the end of the year are also failing to die. China Times hasn't got a flawless track record on Apple rumours; it was only close-ish when it predicted an October 2009 launch for the first iPad (it debuted in April 2010) but the fact that the 2011 release date for the iPad 3 rumours prevail make us suspect there could be something in it.

You are subscribed to email updates from TechRadar: All Apple feeds To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610

Software : Google Maps adds London public transport directions

---

Google Maps adds London public transport directions Posted: 28 Jul 2011 02:41 AM PDT Google Maps has now included public transport directions for London travel on its website and mobile app. The directions on the web will help guide you from A to B in London with step by step directions, including which Underground station or bus stop to go and how long each step of your journey will take. Using the mobile app you are able to get directions from your current location using the GPS on your phone, meaning you can constantly stay on track in the British capital. Keep on moving Users of Android devices can also use Google's Transit Navigation to guide them in real-time, including instructions such as when to get off the bus. This is all possible because TfL has made all its timetable information available to the public online through a London Datastore website, so you can now find routes on Google using all Underground, bus, tram and Docklands Light Railway (DLR) lines. Support for London's Overground network and other public transport options will be added as soon as it is available. So it's true, the world, (well…London) really is your oyster.

BBM6 released with in-app chat capabilities Posted: 28 Jul 2011 01:09 AM PDT RIM has released BlackBerry Messenger (BBM) 6, an update to its much-loved messaging software that now allows users to chat from within connected apps and games. Available today, users with BlackBerry OS 4.5 or higher will be able to push messages to friends from within a select number of apps, including FourSquare and Wikitude. You can also expect to see BBM chat in some games, with achievements and trophies added to your BBM profile so your friends can see what games you're playing (and how terrible you are at them). Gamify Along with proof of your gaming prowess, you'll be able to add a status update to your profile. Conversation style text messaging support for BBM-less contacts has also been added, so you can do all your messaging from within the BBM app. We expect to see a host of newly BBM integrated apps pop up over the coming months as developers implement the system more widely, particularly in advance of iOS 5's autumn release, which brings iMessage with it - Apple's competing product for iPhone and iPad. This update to the popular messaging service could be the shiny new social thing that RIM was teasing earlier this week; sure, it's a nice update and all but… well… we were really hoping for some new hardware. Still, with a BlackBerry media event scheduled for next week, the wait for that might not be too much longer.

You are subscribed to email updates from TechRadar: All Applications feeds To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610

Apple : Survey: Over half of phone buyers already want iPhone 5

---

Survey: Over half of phone buyers already want iPhone 5 Posted: 27 Jul 2011 01:19 AM PDT A new survey of nearly 3,000 people claims that over half of consumers already want an iPhone 5, despite no official details on the phone having yet been released, with over a third planning on upgrading to iPhone 5 as soon as possible from their current handset. It is a clear reflection of the strength of Apple's iPhone brand, for so many phone buyers to have already made their next mobile purchasing decision, way before they even know what the iPhone 5 will look like or what snazzy new features Apple will be including in its new handset. And our survey says... The survey was carried out by Experian PriceGrabber and claimed that 35 per cent of those asked already planned to buy an iPhone 5 when it arrives on the market at some point later this year. Seven per cent plan to buy the iPhone 5 on its first week on the market, 14 per cent in the first month, and 51 per cent in the first year. "Our survey data confirms the strong following Apple has built around its iPhone, with more than one-third of consumers planning to upgrade to the latest model only a little over a year following the release of the iPhone 4," said PriceGrabber general manager Graham Jones. Pricegrabber's press release adds that: "Consumers' love for Apple products is clear. When asked which smartphone operating system they prefer, an overwhelming 48 percent of PriceGrabber survey respondents said Apple iOS. "Nineteen percent of respondents indicated that they prefer Android OS, 7 percent said Microsoft Windows, and 6 percent chose RIM BlackBerry. "Respondents also were asked which smartphone they would prefer to receive as a gift. An astonishing 69 percent of consumers indicated that they would most like to receive Apple's iPhone 5. Seven percent said they would like to receive Motorola's upcoming Droid Bionic, 4 percent would prefer to get the Samsung Galaxy S II, and 3 percent said the BlackBerry Curve."

Apple looking at 15-inch super-slim MacBook next? Posted: 26 Jul 2011 02:49 PM PDT Apple is working on a 15-inch ultra-portable notebook following the success of the refreshed MacBook Air series, according to reports. MacRumors claims it has learned that the new super-slim model is in the final stages of testing at Apple, but won't be launched in the immediate future. The report is unsure whether the laptop will be branded as an extension of the MacBook Air line, which has enjoyed a renaissance over the last year, or as a newly slimmed-down MacBook Pro model. 17-incher too? A further report from TUAW suggests it will be part of the high-end Pro series and that a 17-inch compatriot is also in the works. Apple has seen a renewed interest in the ultra-portable market since it revamped the MacBook Air line last year and gave it a new, much-more-reasonable price point of £849. The MacBook Air which was refreshed again last week with Sandy Bridge processors, a backlit keyboard and the Thunderbolt I/O tech. The release saw the original white MacBook disappear from general sale, meaning the 11-inch Air is now Apple's entry model notebook. via MacRumors and TUAW

You are subscribed to email updates from TechRadar: All Apple feeds To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610

Apple : Apple patents flat keyless keyboard

---

Apple patents flat keyless keyboard Posted: 26 Jul 2011 06:20 AM PDT Apple has patented a new flat keyless keyboard concept, which promises a future of computing in which we will never have to actually physically press a key ever again. Apple's new idea for a virtual, flat keyboard is clearly a development of the current keyboard design on the iPod touch, iPhone and iPad. Yet what will speedy touch-typers think of the promise of a future without hard keys? The latest patent filing from Cupertino shows the idea for a virtual, flat keyboard for Apple's Mac laptops and iMac desktop lines. Piezoelectric wizardry The patent details how the flat Apple keyboard will be constructed from metal, plastic and glass, using piezoelectrics, haptic feedback and acoustic pulse recognition. The new Apple keyboard will also feature an LED-lit display (for typing in the dark) and capacitive sensors for your fingers to enjoy Apple's various multi-touch functionality. Website Patently Apple was first with the info on Apple's new keyless keyboards, noting that the new flat surface keyboard might include a haptic or tactile feedback mechanism to let the user "feel" something on the tips of their fingers when they have hit a particular key, to take the place of old-style mechanical switches or buttons.

More than 3.7 billion ARM-based chips shipped in 2011 Posted: 26 Jul 2011 02:48 AM PDT British tech giant ARM has announced a 27 per cent quarterly profit, with a whopping 3.7 billion ARM-based chips shipped in the first half of 2011. ARM's designs are a common feature in thousands of devices globally, and the company's second quarterly report of 2011 showed revenue and profit up significantly on 2010's figures. As well as revenue up by 27 per cent to $190 million, profit was also up by a quarter to £54 million - with 29 licenses sold in the last three months. "In the first half of 2011, we have seen strong license revenues driven by an increase in design activity around ARM technology across a broad range of end applications," said CEO Warren East. The Commitments "Major semiconductor vendors and consumer electronics companies are making long-term commitments to using ARM technology in their future product developments, underpinning growth in ARM's long-term royalty revenues," he added. "As the addressable market for ARM technology grows, we continue to invest in the development of innovative technology, whilst simultaneously increasing revenues, profits and cash." The sheer amount of ARM-designed processors in tablets and mobile alone is huge - with 1.1 billion shipped in mobile phones and tablets between April and June.

You are subscribed to email updates from TechRadar: All Apple feeds To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610

Software : Android Market to surpass Apple App Store by 2012?

---

Android Market to surpass Apple App Store by 2012? Posted: 26 Jul 2011 03:12 AM PDT The Android Market is on course to sell more apps per quarter than its Apple rival by the end of 2012, according to a new report from Strategy Analytics. Third party app stores will really help the Android Market to boost sales with assistance from Amazon App Store, GetJar, Nook and other app distributors, according to the report. The market for apps is continuously growing and it is predicted that it will be worth around $2bn per quarter over 2012 through paid apps. Apple falling far from the tree? This week, Apple began enforcing its new policy that that forbids links that direct the user to an external store, meaning that all purchases suggested by an app must be made from within it so that Apple can take a cut.

You are subscribed to email updates from TechRadar: All Applications feeds To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610

Apple : Tutorial: How to install Mac memory

---

Tutorial: How to install Mac memory Posted: 25 Jul 2011 07:30 AM PDT Unless you put the maximum RAM in your Mac when you bought it, chances are you can add more, which is what we're going to help you do. Remember, new memory is an affordable way to get your Mac running faster. Depending on what Mac you've got, you may need to take out the existing RAM to put more in, so bear this in mind when you're buying. If your MacBook Pro already has two 1GB chips (one in each slot) and you want to upgrade to 4GB, you can't simply buy an additional 2GB. Check System Profiler for what you've got now. The best place to get memory from is Crucial, which has a simple guide to ensure you buy the right RAM for your Mac. To prevent static charge damaging your equipment, ground yourself before you begin by touching something metal. Unplug all power sources before you open things up. Get an anti-static wristband from an electronics shop for peace of mind. When handling RAM, hold it by the edges and don't touch the gold connectors. And remember that components may be hot if the Mac's been running recently! How to upgrade the RAM in your MacBook (late 2009 model and later) 1. Open up your MacBook Undo the eight screws on the underside of your MacBook and lift off the back case – gently pull free the clips at either end. Two RAM chips are in the middle on the right-hand side one above the other; remove one or both. 2. Take the chips out Find the clips at either end of the existing RAM stick and press these outwards with your thumbs. The chip will pop up so that you can grip it at either end. Gently slide the chip away in the direction it's pointing. 3. Pop in the new memory Line up the connectors of the new RAM with the RAM slot – it'll only fit one way round. Gently push it in at the angle you removed the old one. Press the upper end down to clip it into place. Then put the case back on and reboot! How to put more RAM in a MacBook Pro (2009 model and later) 1. Open your MacBook Pro With the screwdriver, take out the screws from the back plate – they're not all the same length, so note where each came from. The two RAM slots are located fairly centrally, one above the other. 2. Out with the old… At either end of the existing RAM, press the clips outwards with your thumbs. It should pop up at a slight angle. Grip it at either end and slide it out in the direction it's pointing. If it doesn't come away, check the clips are undone. 3. …In with the new Get your new RAM and line the gold connectors up with the slot. Press it in at the same angle the old sticks came out at, then push the upper edge down to clip it in place. When you're done, screw the case back on. How to max out a Mac mini (Mid 2010 model and later) 1. Open up your Mac mini Lay your Mac mini upside down and twist the circular black disc anti-clockwise a short distance. When the white dot on the disc aligns with the outlined circle on the casing, lift the disc off and lay it somewhere to the side. 2. Remove what's there At either end of the existing RAM, you'll see little clips. Use your thumbs to press these outwards and gently pull the stick out. Align your new memory's gold connectors and notch with the slot – it'll only fit in one way round. 3. Clip in your new memory Slide it into the slot at the same angle you removed the old chips, and when it's seated, you'll be able to press the top edge downwards to clip it in. Repeat for the second slot if necessary. Pop the black disc back on. How to add memory to your iMac (any aluminium model) 1. Operate on your iMac Lay a towel on your table, then lay the machine on its front with the bottom facing towards you. Lift up the stand to get at the panel on the bottom that covers the RAM slots. Undo the screw and take the panel off. 2. Pull out the RAM On the chips you're going to replace, untuck the tongue and pull it towards you, being careful not to slide your Mac off the table. Take the old RAM and lay it to one side, then unwrap your new memory, ready to put in. 3. Insert the new chips RAM will only go in one way round – the gold connectors go in first, with the notch closer to the right-hand end of the chip. Press the memory into the slots and tuck the tongues back in. Then screw back the cover plate. Done! How to boost your Mac Pro (Early 2009 model and later) 1. Get inside your Mac Pro Hold the side of the Mac Pro case and lift the latch on the back. The side will flip down; then lift it away. Now find the two latches on the horizontal bar towards the bottom. Push the outer ends slightly. 2. Remove processor tray With the latches' inner ends loosened, pull them out to release the tray carrying the memory. Slide it out and lay it on a towel on a desk. There may be four or eight slots. Check the manual for the order in which to fill them. 3. Pop in the RAM Press apart the clips at either end of the empty slots. Align the RAM with an empty slot, with the notch at the correct end. Press it down so the clips snap into place. Then slide the tray back, push the latches in and replace the panel.

In Depth: iPod touch 5th generation: 10 things we want to see Posted: 25 Jul 2011 03:22 AM PDT When Apple releases the iPod touch 5th generation or iPod touch 5G later this year – as tradition suggests it will – how does the company go about improving an already stellar media player-cum portable internet and gaming device? We gave the iPod touch 4th generation 4.5 stars last year, since it brought many of the iPhone 4's features to the market at a lower cost. In recent years, the annual September iPod announcements have been preceded by a new iPhone, which has tended to give a clue as to what the new iPod touch will bring – the Retina Display and A4 processor last year, for example. With the iPhone 5 (or will it be an iPhone 4S?) not expected to arrive until September, it looks like we may see both the iPhone and iPod touch updated at the same time, to coincide with the iOS 5 release date. Now 2010 saw the whole iPod range updated, except for the iPod classic, which is now nearly two years old. Its key selling point remains its 160GB capacity, but in other areas it's stood still while its siblings have surged forward – it still has a traditional hard drive where the iPod touch has flash memory, for example, and lacks a touch screen, which even the £131 iPod nano boasts. It seems unlikely the iPod classic will make it into the line-up of 2011 iPods, especially if Apple ups the capacity of the new iPod touch. Which brings us nicely onto our wishlist for the iPod touch 5th gen… 1. Capacity, capacity, capacity The iPod touch already comes in 8GB, 32GB and 64GB models, but in capacity terms, it's still a way behind the iPod classic, which gives you a whopping 160GB. We expect the entry-level iPod touch 5 to get a capacity bump to at least 16GB. At the top end, we hope Apple gives us at least a 128GB model. An even higher option would be nice, too… 2. Cheaper models Although the entry-level iPod touch isn't prohibitively expensive at under £200, the 32GB and 64GB models cost £254 and £336 respectively – hardly what you'd call cheap. Sure, a lot of that cost's down to the high price of the solid-state flash storage the iPod touch uses, but with memory costs coming down all the time, we really hope to see the prices slashed, especially at the top end. 3. A5 processor The 2011 iPod touch will, in all likelihood, have an A5 processor, just like the iPad 2. Although the 4th gen iPod touch is hardly sluggish, a new, faster chip will make it fly along, and be a big boost to gamers. 4. Better stills camera The iPhone 4's 5-megapixel camera, while not amazing, takes reasonable stills (see below). Not so the current iPod touch with its paltry 0.69 megapixels. While this is probably a lot to do with the cost and physical size of the camera itself, we'd like to see at least some improvement to the camera in the new iPod touch. Oh, and a variable-focus lens would be nice, too. iPhone 4 photo... See full-res image iPod touch 4G photo... See full-res image 5. Fingerprint-resistant screen coating Ever noticed how smeary the iPod touch screen gets? That's because it doesn't have the fingerprint-resistant oleophobic coating on it that the iPhone 3GS and 4 do. It may seem like a minor complaint, but we get pretty sick of constantly having to clean the screen on our 4th gen iPod touch. 6. A scratch-proof back Unless you keep your iPod touch wrapped in cotton wool, the shiny metal back invariably gets scratched up very quickly. So for the iPod touch 2011, let's have the back made of something a little more suited to the purpose it's designed for – a tougher, more scratch-resistant metal. 7. 3G for data only If you want a pocket-sized device with internet access wherever you are, your options at the moment are to buy an iPhone, or carry round a MiFi to get your iPod touch online. But rumour has it that the touch screen iPod will offer a 3G option for data, much like the iPad. This would make it arguably the perfect portable internet device. Do we like this idea? You bet we do – no more shelling out for all those minutes in an iPhone contract that go to waste every month. But if we do see a 3G option, don't expect it to come cheap, seeing as it's likely to cost Apple a fair few iPhone sales, especially in combination with iOS 5 and iMessage. 8. Better audio and video format support OK, this one's extremely unlikely, but that doesn't make it any less desirable. For a start, let's have support for OGG, FLAC audio, plus XVID and AVI video. Yes, you can convert them, or play these various formats in dedicated apps, such as AVPlayer (read Tap!'s review of the HD version here), but why make us jump through hoops? Anyway, back in the real world… 9. Include a remote again Apple quietly stopped including earphones with a remote with the 4th gen iPod touch. Sneaky. OK, so if you want good-quality audio, you're not going to use the Apple earphones, but this is Apple's premium iPod – they shouldn't be skimping on the headphones! Bring back the in-wire clicker remote, we say. 10. White model The iPhone comes in black and white editions. So does the iPad 2. So it's probably a reasonable assumption that there will be a white iPod touch 5th generation as well. We're not the only ones, it seems. ----------------------------------------------------------------------------------------------------

You are subscribed to email updates from TechRadar: All Apple feeds To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610

Software : Facebook iPad app leaks

---

Facebook iPad app leaks Posted: 25 Jul 2011 03:16 AM PDT Facebook appears to have hidden its upcoming iPad app in the code of the existing iPhone one, suggesting that the app's launch is not far off. Despite being eighteen months old, the iPad is yet to get an official Facebook app, with Apple tablet users settling for the web version or the scaled-up iPhone app. TechCrunch has posted a rather gushing hands on with the app, which points out the "great" navigation system, "great" use of overlay menus and the "great" looking photo viewer, which is similar to the iPad gallery app. Facebook feeds The look and feel of the app is certainly in keeping with the iPad's interface, with familiar icons and layout as standard. As well as access to the regular Facebook news feed, the app offers photo upload, Facebook chat, Places check-ins and the ability to toggle feed filters. It's not clear if iPad Facebook chat incorporates the newly launched, Skype-powered Facebook video calling, however. The app, which is built in HTML5, still appears to be being built, with a source noting that HTML changes are being rolled out on an hourly basis; but it's safe to say we're not far off a Facebook iPad app release.

You are subscribed to email updates from TechRadar: All Applications feeds To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610

Apple : In Depth: 10 top Pages tips and tricks

---

In Depth: 10 top Pages tips and tricks Posted: 24 Jul 2011 12:00 AM PDT Pages is Apple's word processing and page layout app, part of the iWork productivity suite for the Mac. It's extremely easy to use but is also very powerful - here's our list of useful tips and tricks to help you get more from Pages. 1. Tables of Contents (TOCs) Tables of Contents are useful for longer documents, and so easy to do. First, make sure you use defined paragraph styles for your headings. Now place the insertion point where you want it to be added, then use the Insert > Table of Contents command. This displays the TOC tab in the Document Inspector, and you check the box next to each heading style you want the TOC to include. If you check the 'Make page numbers links' box below, you can click on a page number in the TOC to go straight to that heading. This works both in Page and exported PDF version files. 2. Alignment guides and preferences The automatic Alignment Guides are really useful for lining up any objects you add to your documents and 'snapping' them into position. However, they can sometimes be distracting and get in the way, especially when you're trying to position an object very precisely. But they are easy to get rid of, all you have to do is hold down Command as you drag them and this will temporarily disable them, leaving you to get on with your work. 3. Paste while preserving formatting Sometimes you'll want to paste in text or numbers from a web page, an email or another document, but the original text formatting (font, size, colour and so on) will be used, which means you may then have to re-style the text. The solution is not to use the usual Command+V 'Paste' shortcut, but use Shift+Option+Command+V instead. This matches the new text to the existing style at the insertion point. 4. Option-click tab to bring up multiple inspectors While the Pages Inspector doesn't actually take up that much space on your screen, it does a huge amount of work, and so it can get really tiresome having to continually swap from one tab to another. But if you Option-click on a tab icon instead, you'll see that it opens up a brand new Inspector window. You'll soon find that having a couple of your most-used Inspectors open at the same time will save a lot of clicking. 5. Outline mode Outlines are really useful for planning and organising documents, and here's not one but three outlining mini-tips. First, you can save a lot of manual formatting by choosing a suitable Outline Template. Second, there's a button on the toolbar for reducing images to unobtrusive thumbnails. Third, there's another button that curtails long paragraphs into a single line. 6. Password protection There are lots of reasons why you might want to password-protect your documents, such as you are using a shared computer or you are working with sensitive information. If you take a look at the bottom of the Document Inspector you'll see a 'Require password to open' checkbox. You can choose your own password, or let Pages suggest one for you – and you can type in a hint in case you forget your own password. Duh! 7. Word counts If you're asked to write an essay, a report or a magazine article, you're probably going to be given a word count. So how do you know how many you've written? Take a look at the bottom of the window – the status bar shows you how many words there are in the document and, if you select some text, how many there are in the selection too. 8. Sections and Word Processing Sections are a great way to split up and logically organise long Word Processing documents and make them manageable. Each section can be moved around in the document by dragging its page thumbnail (outlined in yellow in the page thumbnail panel here). You can use different page numbering, headers and footers and column layouts for each section. 9. Tables can be spreadsheets The tables you add needn't just be boxes with words in. They can be used as mini-spreadsheets too, thanks to the functions in the Table Inspector. Format cells to contain dates or currency values, for example, and add a footer row to total up a column of figures. 10. Two Up page display When you're working on Page Layout documents, it can be useful to view facing pages side by side. But don't use the Two Up option on the pop-up page view menu at the bottom left of the screen. This is the wrong way to go about it because it will put the first (front) page of the document on the left and the first inside page on the right, and all the pages will be out of sync. Instead, click the 'Facing Pages' box in the Document Inspector. This will put the first page on the right and will display page thumbnails as 'spreads'.

You are subscribed to email updates from TechRadar: All Apple feeds To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610