Office Mobile / iPad
Office for Mere Mortals
Office News Wire
Mobile | PDA
Microsoft Office Bookshop
Get the Office Watch newsletters!
since 1996 thousands of people receive the latest independent news and tips from us -- join them today - FREE!
A whole new look for Office-Watch.com has arrived. Check it out at new.office-watch.com.
We've moved all 2000+ past articles to the entirely new web site. Not just a different look but all the 'back office' has changed too, including a move from Windows to Linux hosting.
The same web site and look now applies across all devices from big screens to tiny phones. The site automatically adjusts to the screen size.
Searches will be faster and private to the web site.
The migration is still happening so some things will be on the old site - creatively called old.office-watch.com until they are moved.>... click here to read more at Office-Watch.com ...
Office-Watch.com reader Peter M. reminds us that choose the sort type is really important: Text, Number or Date.
“I just thought it worth pointing out that, for example 8, 70, 600 would sort in one order as Text and the reverse order as Number. Perhaps obvious, perhaps not.”
Sadly Word doesn’t always guess correctly, so you have to check.
Look at these two tables, both are sorted by the Part No. column:
The left table is sorted as if the Part Numbers are numbers from smallest to largest. The right table is sorted as Text. The one you or your company chooses is up to you, but you need to be aware that Word can’t distinguish numbers that are text labels from real numbers (it’s the same problem in Excel PivotTables).
In the Sort dialog for the above tables, Word defaults to Number for the first column
Change the type to ‘Text’ if you prefer.... click here to read more at Office-Watch.com ...
Microsoft has just released updates to their Office for iPad apps (Word, Excel and PowerPoint for iPad). What’s new and fixed for Office 365 customers?
Nothing …. If you’re already an Office 365 renter/subscriber there’s nothing new at all.
The entire 600MB of updates is to help Microsoft sell more Office 365 packages. If you have the choice, you can skip these updates and wait for some that improve the software for customers – not Microsoft alone.
Updating the apps, just for more Microsoft's revenue, is quite inconsiderate to their millions of existing customers. Not everyone has a free, fast connection like they do. Promotional changes should be part of some new or changed features in an update for all paying customers.
Office for iPad: The Complete Guide covers every menu, ribbon and feature in Word for iPad, Excel for iPad and PowerPoint for iPad.
Office for iPad now includes ‘in-app purchases’ for the monthly Office 365 payment option.... click here to read more at Office-Watch.com ...
The last man to walk on the moon, Captain Eugene Cernan, is a notable omission from the Microsoft Office dictionary.
We kept seeing a red squiggly line in the middle of the Word 2013 list …
Why is Cpt. Cernan not included in the dictionary? Does someone at Microsoft hate him?
No … It’s unlikely there’s been any deliberate omission of Cpt. Cernan’s name from the dictionary.
Many of the astronaut first and last names would be in the Word dictionary are in common use while some others like ‘Aldrin’ where probably added after analysis of user documents or a deliberate addition of a notable name.... click here to read more at Office-Watch.com ...
Dropbox has announced price decreases / storage increases to match offerings from Microsoft and Google.
The lowest level of paid Dropbox is ‘Pro’ for $9.99 a month or $99 per year. That did give you 100GB of storage and now you get 1Terabyte (1,000GB).
That sounds impressive until you realize that both Microsoft and Google offer a Terabyte for around the same price with document editing as well.
Microsoft Office 365 Personal costs $70 a year for the Office desktop and mobile applications plus a terabyte of OneDrive storage. Office 365 Home Premium is $99 a year for 5 people to use the Office programs and a terabyte each.
Google Drive is also $9.99 a month (no annual price) and integrates with Google Docs.
Dropbox did have an advantage being untied to a particular operating system (Windows, Android etc.) but that’s being somewhat eroded by the improvements in OneDrive apps.
All three major players are trying to ignore security and privacy issues in the hope that customers won’t notice or forget. Microsoft has been caught reading private emails for its self-interest. Dropbox has a former US National Security Advisor on their board which doesn’t help appearances. All the major players have no choice about supplying information from cloud storage to the US government even if it’s on a server outside the USA.... click here to read more at Office-Watch.com ...
Sometimes you want to sort a list in a way that isn’t apparent to the reader.
To continue our Apollo theme, here’s a list of the twelve men who walked on the moon with the order they stepped onto the surface.
To put that list into the order of stepping on the moon is simple but what if you want to place them in that order but without the ‘Order’ column showing?
The beauty of this method is that you can go back to the table, add or change rows then re-sort the table. Probably a good idea to add an unpublished comment to the document reminding you and others to the presence of the hidden column and the reason for it.
The first step is the hide the column from view, which we’ve covered in a separate article.
Then select the table and choose Table | Layout | Data | Sort. The hidden column still appears in the ‘Sort by’ list, only without the header text, just the Column number. Choose the Column to Sort by and other options as usual. As you can see, the list is now in the arrival order but without that order showing.... click here to read more at Office-Watch.com ...
Sometimes you want to hide a table column in a Word document but according to Microsoft you can’t do it. Here’s how to do it anyway.
It’s true that there’s no explicit ‘hide column’ option like in Excel but you can fake it in various ways. Here’s the example table we’ll use. We want to have the list in order of stepping on the moon but not display the order column.
You might think that the ‘Hidden’ formatting option (Font | Effects | Hidden) would do the trick but that only works for the contents of table cells, not the cells or column.
But the Hidden attribute gets you part way there. To finish the job, change the cell formatting to remove the vertical column border. Then narrow the columns and you have what looks like a single column table.
To prove we didn’t cheat, here’s the same table showing the column separator (in Word 2013) and the columns in the ruler.
Narrowing the column might require using a small font size.... click here to read more at Office-Watch.com ...
Following our look at different alphabetical orders, here’s a look at the sorting options in Word.
You can sort paragraphs, lists and tables in a Word document. Select the list or paragraphs then choose Home | Paragraph | Sort. For tables there’s similar sort options are at Table | Layout | Data | Sort:
The main sort dialog box lets you sort by up to three columns or entries. This is the sort dialog for paragraphs and lists.
For tables there’s the additional ‘Using’ option at each level.
Sort by - choose the paragraph or column. If you’ve chosen ‘Separate Fields at’ (see below) the fields will appear in this list.
Type – either Text, Numbers or Date. Word will guess the correct type from the data but you can override that choice. Choose 'Numbers' to sort by value and 'Date' to sort in date order (assuming that Word recognizes the values as dates).... click here to read more at Office-Watch.com ...
I thought that alphabetical order was, well, alphabetical order. That’s what I was taught at school and apparently I was taught wrong. There are at least three ways, two used by dictionaries, another by Microsoft and that’s for English alone!
Reading Sue Butler’s delightful book 'The Aitch Factor' I found that there's more than one alphabetical order! Naturally, that got me wondering which alphabetical order is used by Microsoft Word and Office when sorting.
Look at these two word lists, both have the same words and both are in alphabetical order.
Source: The Aitch Factor and the Macquarie Dictionary.... click here to read more at Office-Watch.com ...
There’s a new version of OneNote for Windows 8 out today with some ‘new’ features that help it catch up ‘real’ OneNote for PC or Mac
At this stage let’s be clear, we’re talking about the OneNote app for Windows 8 in Modern/Metro style that’s been such an underwhelming ‘success’ with customers. The OneNote Windows Store app is possibly the only reason for some people to try the Modern interface.
We like the OneNote app, especially the innovative radial menu that takes a little time but is worth getting used to. But the unquestioning hype about ‘new’ features is hard to stomach.
Yes, the idea of a Microsoft Office program being able to print is considered a big deal. Microsoft should really be apologizing that it’s taken them about two years to add this essential feature.
The Print option is on the right-hand Charms menu under Devices.
Or swipe up from the bottom of the page or right-click on the page and tap ‘Print Page’. The familiar Ctrl + P shortcut also works.... click here to read more at Office-Watch.com ...
|New & Popular
» New Office-Watch.com web site
» Two ways for sorting by Number
» Office for iPad, September updates
» Why is Gene Cernan ignored in Word?
» DropBox prices drop but is it enough?
» Sort by hidden column in Word