If you purchase a new Mac products. It comes with the latest version of iWork (Pages (Word processing),Numbers (Spreadsheet), and Keynote(Powerpoint) for free. Also, iWork supports Microsoft Office Formats and able to save your documents with microsoft formats. Free word processing for mac.

If you are working on a large spreadsheet, it can be useful to “freeze” certain rows or columns so that they stay on screen while you scroll through the rest of the sheet. As you’re scrolling through large sheets in Excel, you might want to keep some rows or columns—like headers, for example—in view. Excel lets you freeze things in one of three ways: • You can freeze the top row. • You can freeze the leftmost column. • You can freeze a pane that contains multiple rows or multiple columns—or even freeze a group of columns and a group of rows at the same time.

The top row in the visible portion of the worksheet will then be locked and remain visible as you scroll down through the data. To unfreeze the top row, choose Unfreeze Panes from the same menu. To freeze only the first visible column, select Freeze First Column from the menu. If you want to sort based on the content of more than one column just select any single cell in the list then use the Data> Sort command, the Sort button in the Data tab or the contextual menu mentioned above to choose Custom Sort.

So, let’s take a look at how to perform these actions. Freeze the Top Row Here’s the first spreadsheet we’ll be messing with.

It’s the Inventory List template that comes with Excel, in case you want to play along. The top row in our example sheet is a header that might be nice to keep in view as you scroll down. Switch to the “View” tab, click the “Freeze Panes” dropdown menu, and then click “Freeze Top Row.” Now, when you scroll down the sheet, that top row stays in view. To reverse that, you just have to unfreeze the panes.

On the “View” tab, hit the “Freeze Panes” dropdown again, and this time select “Unfreeze Panes.”. Freeze the Left Row Sometimes, the leftmost column contains the information you’ll want to keep on screen as you scroll to the right on your sheet. To do that, switch to the “View” tab, click the “Freeze Panes” dropdown menu, and then click “Freeze First Column.” Now, as you scroll to the right, that first column stays on screen. In our example, it lets us keep the inventory ID column visible while we scroll through the other columns of data. And again, to unfreeze the column, just head to View > Freeze Panes > Unfreeze Panes.

Make the most of your Mac - install Microsoft Office suites or run Windows. Buy online with fast, free shipping. Studio programs for mac. Logic Pro X turns your Mac into a professional recording studio able to handle even the most demanding projects. Capture your compositions and performances — from tracking a live band to a solo software-instrument session — and flow them into your songs. The open-source program gives users a wide range of options for recording and editing audio, all tied together with a simple interface, and everything Audacity has to offer is free of charge.

Freeze Your Own Group of Rows or Columns Sometimes, the information you need to freeze on screen isn’t in the top row or first column. In this case, you’ll need to freeze a group of rows or columns. As an example, take a look at the spreadsheet below. This one is the Employee Attendance template included with Excel, if you want to load it up. Notice that there are a bunch of rows at the top before the actual header we might want to freeze—the row with the days of the week listed.

One primary reason behind Excel contacts to vCard conversion is that Outlook and other application require accessing the address book, however xls/xlsx spreadsheets cannot be used directly in Outlook. Free xlsx converter for mac. The vCard file format is supported by many devices such as mobiles phones, PDA(Personal Digital Assistant), iPhones, tablet, and PCs.