Display hidden values by using the standard number format. In the Format Cells popup window, in the Category list, do one of the following: To. On the Home tab, in Number, on the Number Format pop-up menu , click Custom. Select the cells that contain the hidden zero (0) values that you want to display.Clear the Empty cells as check box.When I reviewed Microsoft Office for Mac 2008, I said the then-new version of the suite was "kind of like getting a new Chevy." In other words, it was a solid upgrade, but nothing to really get excited about.If you are experienced with using Microsoft Excel, a VBA macro will help you display or hide status bar in Microsoft Excel easily. Delete any characters in the box. A blank cell in empty cells. Type the value that you want to display in empty cells.
![]() While the gallery did bring some commands to the surface, they usually were not the ones users needed most often.The new suite takes the idea further, adopting a Ribbon similar to the one in Windows Office. In 2008, the company added the Elements Gallery, a row of tabs beneath the Toolbars that that was supposed to make it easier for users to find hidden features. That may not sound like much, but in a world where studies show that people won't wait more than four seconds for a Web page to load, the difference is significant.The other change you'll notice right away is that Microsoft has tweaked the interface yet again. The Office 2008 apps, in contrast, take six or seven seconds each to start up.Similarly, Word 2011 loaded a 5,700-word document in three seconds compared to six for Word 2008. (I tested using a MacBook with a 2.16-GHz Core 2 Duo chip and 3GB of RAM.)Over several runs, for each component - Word, Excel and PowerPoint - it took only three or four seconds (with the Document Gallery turned off) to go from clicking the icon in the Dock to presenting a new blank document. Office 2011 Home & Business Edition replaces Entourage with Outlook, which handles the same tasks but offers more compatibility with Windows Outlook - a welcome development for Mac users working in Windows-dominated corporate environments. Each program gets some valuable new features, including some new image-editing tools, and the suite as a whole gets a brand-new component: Outlook.Office 2008 came with Entourage, an integrated e-mail client, contact manager and calendar application. It's an intelligent use of screen real estate - and if you don't like it, you can just hide the Ribbon entirely.It's not all speed and interface changes, though. For example, if you insert a table in Word, a new tab immediately appears in the Ribbon offering table formatting features. Unfortunately, you can't actually edit the commands that are available in each group, which will feel like a restriction to those of us who are used to customizing toolbars.However, the Ribbon is context-aware. For example, formatting features that were previously located in a floating palette are now at the top of the window, which makes them much easier to find and use.You can customize the Ribbon somewhat by deleting tabs or groups you don't want and reordering the rest. ![]() These choices can be combined to create custom arrangements - for example, you can group messages by one criterion, then sort the groups and the items within them in other ways. Doing a similar search in Apple Mail requires setting up a Smart Mailbox, a clunky way to quickly find that one message you're looking for.You can also choose to organize your messages in many different ways: by conversation, by account, by date received and so on. For example, in the e-mail module, you can concatenate search terms ("from:jetblue subject:itinerary") to locate messages by several criteria at once. It can do some useful things that the Apple Mail-Address Book-iCal tandem can't. Similarly, Google's tool for syncing its Calendar with Outlook (Google Calendar Sync) works only with Windows Outlook.Once you're more-or-less comfortably settled in with Outlook, though, it handles its tasks competently. OLM file, which means the compatibility really only works one way. Microsoft excel for mac is slowFor example, you can apply categories (and associated colors) to contacts in Outlook and then filter or search by category in Address Book, you can create groups of contacts (which you can also do in Outlook, via "folders"), but you can't tag individual names.In short, Outlook is not a particularly compelling option for the average Mac user. When I clicked on the same message in Outlook, it took two or three seconds to appear, even without downloading the images.That said, Outlook also offers some features that iCal and Address Book don't. The bulk of my e-mail comes through my IMAP Gmail account, and when I clicked on a message in Mail, it displayed immediately. In my testing, Outlook was much slower than Apple Mail at displaying messages. Click on a style name, and all occurrences of that style in the document are highlighted, making it easy to see if the various elements are properly tagged - if that bold Helvetica subhead really has the style "subhead," for example, or is just formatted to look like it.Search and replace works much the same way. But in Word 2011, that tab doesn't just display a WYSIWYG list of document's styles and let you create and apply them it can also show you where a style has already been used. Many of the new features are truly useful enhancements, not just gimcrackery.For example, that floating palette that used to hold most of the formatting controls still has a Styles tab. Excel Hide 0 Values Excel 2011 Full Screen ViewI've been trying to use that key combination to search in Word for years, forgetting that I'm not in a browser, and it finally works, making this my favorite new feature so far.Word also now offers a Full Screen view that shows just your document - no Toolbars or Ribbon, no menus, no desktop or other windows, just a white page against a black backdrop. But even better, hitting Command-G steps you through them, one after another. Clicking on one takes you to that place in your document.Just plain Find, on the other hand, now works like it does in a browser - there's a search bar at the top right of the window, and you can type in your search term there to highlight all instances of the term. Typing a term in the Find box highlights all the occurrences of the term in your document while the sidebar shows a list of the matches in context. If you're tracking sales figures by season, for example, you can embed a line chart at the end of each item's row to give a quick snapshot of the seasonal trend. Sparklines are basically graphs contained within a cell. But there is one new feature worthy of note. Click on that, and a dropdown menu presents the filtering criteria available: ascending or descending sort, display only cells of a certain color, hide rows that contain particular entries and so on.Perhaps most impressive of the new data-manipulation features is the Pivot Table Builder. Clicking the Filter icon in the toolbar puts a small triangle at the top of each column. Select some cells and click on the button, and a dropdown menu gives quick access to some common choices, such as the ability to highlight values above or below a certain amount.Filters are also easy to use. For example, the Home tab contains a Conditional Formatting button.
0 Comments
Leave a Reply. |
AuthorSabrina ArchivesCategories |