Hi, I am another expert on this site and I interpret the question differently than the above expert. Your question is clearly about missing some of the 'gridlines' which has nothing to do with cell 'borders'. How to use excel on a mac Matt Shea. Unsubscribe from Matt Shea? Published on Sep 22, 2011. Very Helpful. Category Howto & Style; Show more Show less.

To me, this is the stronger measure of performance, as it's the one that will most affect the ability to get things done with Excel—not waiting on calculations in large worksheets will be a huge timesaver. I saw similar results with all the workbooks I tested; they scrolled better in prior versions of Excel, but Excel 2011 easily trounced its predecessors in speed of calculation. In addition to my tests, Macworld Lab ran a series of benchmark tests. Overall, Excel 2011 performed faster than Excel 2008 in the Lab tests. We'll have more benchmarks result in an upcoming lab report.

Your data should inform your decision; if there are too many columns to make things legible in portrait orientation, choose landscape. On the other hand, if your spreadsheet is comprised of lots and lots of rows with fewer columns, portrait may be the better option. Once you’ve made this decision, use the Margins dropdown to select the area of the page where your spreadsheet will appear. This will depend on the capabilities of your printer, but the Narrow Margins preset is a good way of getting as much as possible on the page, and it won’t cause problems for the majority of devices. If you want to make sure that your spreadsheet is as large and as legible as possible once printed, we can use Excel’s scaling tools to do so.

We opened a spreadsheet with 225,000 cells of data. We recalculated the file, scrolled through the spreadsheet, and performed a Save As.—Macworld Lab testing performed by James Galbraith Macworld’s buying advice Should you upgrade to Excel 2011 if you’re using an older version? I definitely think so. The new interface and improved functionality make short work of even large projects, while the protection and sharing features make it easier to work with others—both on the Mac and on that “other” platform. There are only a few negatives with Excel 2011. I feel scrolling has been overly slowed down, the live window resizing is jumpy, and the lack of support for Services is troubling, as that's an OS X feature that I rely on daily. However, these things are not big enough issues to really affect Excel's performance and features—the program just works, and has many new features and improvements that spreadsheet users have been asking for.

• Chart Layout: This Ribbon tab is where you fine-tune chart customization. Here you find a selection indicator and chooser, selection formatting options, analysis options, label options, and 3-D rotation options. • Format: More fine-tuning using the selection indicator and chooser, chart element styles, text styles, arrangement, and size tools. Selecting chart elements in Excel 2011 for Mac To select a chart element, you can either click the element or click the Current Selection pop-up menu found within the Chart Layout tab of the Ribbon. All the formatting options adjust automatically to activate only those options that are applicable to whatever is selected. When you select a chart series within a chart, the corresponding data series and data labels are selected in your data range.

• Draft Quality: Prints to a lower fidelity, draft output. • Comments: The Comments pop-up menu lets you choose from these options: • None: Don’t include comments. • At End of Sheet: Show all comments at the end of the printed sheet. • As Displayed on Sheet: Show comments as they appear on the worksheet. • Page Order: You get two options within this area: • Down, T hen O ver: Prints pages from your worksheet, from top to bottom leftwards, and then the same way from top to bottom subsequently. Think about printing pages as in a flipped N.

A while back, I showed you how to make graph paper using Excel—it's a neat trick. You can display gridlines in Word—but you can't print them. That's a pretty big limitation. However, Word's gridlines are meant to be guide rules, not printable borders.

Option 1: Microsoft Office 365 and Microsoft Office Mobile are available at no cost to SJSU students. Additional details are available on the SJSU Microsoft site for students. Note that you will need to use your SJSU student email address when signing up for Office 365 through the Student Advantage program. Welcome to the SJSU subreddit. This is for anything related to San Jose State University. Students, alumni, faculty, prospective students and locals are all welcome. Sjsu office for mac. Microsoft now offers many of their popular Office products to SJSU Faculty and Staff at no cost! Office 2013 Professional Plus Office 2011 for Mac (and new Office for Mac when it comes out next year). The Information Technology Division supports San Jose State University by working working with students, faculty, and staff to enhance teaching, learning, and facilitate outreach.

Specify the Page Setup settings to print lines in Excel If you forget to enable the Print Gridlines option in the Ribbon, you can do it just before getting a paper copy of your spreadsheet. Here are easy-to-follow steps to print gridlines in Excel keeping the Print Preview pane open. Note: Excel does not print gridlines around empty cells in a worksheet. If you want to include blank rows and columns into printing as well, just use the Print Area icon to set the range. Change the printed gridlines color By default, gridlines in Excel spreadsheets are light gray. If you're printing your sheet with grid on a color printer, you can change the lines color for something more attention-getting. • Click the FILE tab in the Ribbon.

So the idea is at different times you might want to change this part of a chart or another part. With the chart selected we're going to Add Chart Element. We can see some other choices here. Maybewe want some grid lines here.

When you're scrolling large spreadsheets (either by clicking and holding on a thumb scroller or by drag-scrolling), the sheet feels like it's moving quite slowly, even on current hardware. In back-to-back comparisons between Excel 2004, 2008, and 2011, the 2011 release was easily the slowest of the three—it took over six times as long to scroll through my test document as did Excel 2004. (Microsoft has told us they slowed the scrolling down due to user complaints about it being too fast.

If you want your data to be aligned with your brand, you could create a chart with your branded colors, then save that off as a template. So, let’s say you doing marketing for Toys R Us (which I’m not affiliated with in any way), and you want to use a pie chart in a presentation with your branded colors.

In addition, Microsoft says that cross-platform macro compatibility with the Windows version of Excel has been improved, although I was unable to test this. While many Mac users may never use macros, their return is good news for power users and those who work in cross-platform environments. Sharing and protecting spreadsheets If you share your Excel projects with others, Excel 2011 has more to offer than previous versions. In the past, you could protect a worksheet’s cells, contents, and scenarios, and lock or unlock a given cell for editing. Better protection: Excel 2011 offers greater flexibility in sheet protection.In Excel 2011, however, you can protect a cell’s contents while allowing changes to formatting. You can also allow or prevent insertion and deletion of rows and columns, use of filters and sorting, and more.

Let the data talk. • Pick your colors. Make you chart easy to understand.

If not, Have you ever struggled with importing or exporting data into a spreadsheet? This tutorial will help you master the art of moving data between Microsoft Excel, CSV, HTML, and other file formats. Into Excel and continue on to the next step. Convert Data to a Table Next, we’ll arrange our data as a table. You can skip this step if your data doesn’t lend itself to table formatting, but otherwise it’s an easy way to simplify the Printers have a reputation for being difficult to set up.

Apple Footer • This site contains user submitted content, comments and opinions and is for informational purposes only. Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the.

But we've got some other choices. And for every one of these, too, as we slide across the different choices, there's always an option at the bottom for More. For example More Trend Line Options. Outlook for mac import. We see some choices off to the right based on these examples here, and possibly we'll see some other data off to the right by way of those dialog boxes as we saw earlier with axes. And we can close that down if we no longer need to use them. So these are features you want to explore. You don't necessarily have to go to a lot of these.

Excel 2011 supports some new macro features, such as the ability to set watch points, and it handled all of my existing macro spreadsheets (including a complex model containing custom menus and input forms) just fine. In addition, Microsoft says that cross-platform macro compatibility with the Windows version of Excel has been improved, although I was unable to test this. While many Mac users may never use macros, their return is good news for power users and those who work in cross-platform environments. Sharing and protecting spreadsheets If you share your Excel projects with others, Excel 2011 has more to offer than previous versions.

Selection indicators display on the chart series elements in the chart. Deleting an Excel chart series A chart series represents the data found within a row or column To delete a chart series, select it and then press the Delete key. The corresponding row or column in the data source is not deleted. Formatting chart elements in Excel 2011 for Mac You have your choice of using the formatting tools on the three Ribbon tabs, or you can display a dialog by clicking the Format Selection button.

• Format your legend. If you don’t need it, get rid of it. • Choose your title. Keep it snappy. Tell your audience exactly what they’re looking at. While not the be-all and end-all of chart design, running through this quick checklist can help you spruce up your data, and make your chart Excel is killing it with its advanced data management features.

You now have two options: keep the Major Unit as 200, which is quite suitable for our chart, or reduce this to 100, which also works. I’m going with 100 as we have a number of data series with similar values between the two potential units. This will make it easier to discern between the similar values. Our bars are quite thin, too.

The best way to do this is to format the data in the table. If you do that, the chart will update automatically. Otherwise, you need to unlink it from the source in the Format Axis dialog. To add thousands separators, select the entire column and click the button with what looks like a comma in the Home tab in the Number category.