How to freeze top row in google sheets. To freeze the first row and column, open your Excel spreadsheet. Select cell B2. Then select the Layout tab from the toolbar at the top of the screen. Click on the Freeze Panes button and click on the Freeze Panes option in the popup menu. Now when you scroll, you should still continue to see row 1 and column A. To freeze the top row, open your Excel spreadsheet. Select the Layout tab from the toolbar at the top of the screen. Click on the Freeze Panes button and click on the Freeze Top Row option in the popup menu. Now when you scroll down, you should still continue to see the column headings. Can't Freeze Rows In Excel For Mac 2011 Good Morning! I've searched & followed every instruction I could find, yet I'm stumped about freezing rows in Excel For Mac 2011 on some spreadsheets. On others, I already froze rows long ago & they still work. I've also tried clicking different cells in the row below the rows I wish to freeze. How to freeze rows and columns in Excel (for Mac 2011) even if it is grayed out. The trick if it is grayed out: go to View, then choose “Normal” view (it does not work in Page Layout). Freezing panes in Excel for Mac will help with keeping things organized aka, keeping yourself sane while working through excel spreadsheets. Freeze the top row. On the View tab, click Freeze Top Row. When you do this, the border under row 1 is a little darker than other borders, meaning that the row above it is frozen. Freeze the first column. If you'd rather freeze the leftmost column instead, on the View tab, click Freeze First Column.

The instructor of this video shows you how to completely hide the ribbon, or the menu, in Excel. If you only want to partially hide the ribbon, you can use the shortcut control + F1. To completely hide the ribbon, though, go to the Visual Basic screen, hit Alt + F11.

Microsoft Office for Mac 2008 may be the best pick for business users, with major updates to Word, Excel, PowerPoint, and Entourage. After a, Microsoft plans to release Office for Mac 2008 to brick-and-mortar and online stores on January 15, making this the first update in nearly four years.

Office for Mac includes Word, Excel for spreadsheets, PowerPoint for presentations and Entourage for e-mail and time management. There's no Microsoft Access database application for the Mac, although Filemaker's upcoming release of offers Mac users a new choice. Unlike, the interface changes don't look radically foreign next to the 2004 edition.

That's good news for anyone who doesn't want to relearn the locations of common functions. The 2007 applications for Windows arrange functions within tabs, while the 2008 Mac software largely clusters functions within the same drop-down menus including File, Edit, and View. By and large, most of the changes focus on attempting to help users craft more attractive documents. For instance, Office for Mac features the same templates and Smart Art graphics as the Windows counterparts. These are premade templates with 3D and translucent designs.

There are more welcome and substantial changes as well. Now you can save to PDF, and Automator actions are supported. The new My Day widget for Entourage floats on the Mac desktop displaying calendar items and to-do lists. This is handy if you rely on Entourage but don't want to run it all the time. Office 2007 for Windows clusters functions within a contextual 'Ribbon' toolbar that displays different options. Office for Mac lacks the Ribbon, but some menu items appear only in step with the task at hand. We found the shape-shifting neither terribly distracting nor useful.

For simple tweaks such as changing fonts, you'll need to consult floating formatting boxes. Being accustomed to Office for Windows, we'd rather find all these options at the top of the screen. Office for Mac saves work in the same, new Open XML formats used by Office 2007 for Windows.

We're not thrilled about this being the default option, even though you can save your work in the older DOC, XLS and PPT formats. Won't be available until as long as 10 weeks from now, or 8 weeks after the applications are available in stores. That means for now, should you save work in a new OOXML format in a hurry, someone with the older software won't be able to open it. Although we're glad that Microsoft offers free converters, we find the forced extra steps annoying in Office 2007.

That said, the new document types are smaller and purportedly more secure than their predecessors. You'll need a Mac with 1.5GB free on the hard drive, running at least OS 10.4.9, with 512MB of RAM and a 500MHz Intel or PowerPC processor.

Installation took about 20 minutes on our MacBook running the. The least expensive option is the $150 Home and Student edition (formerly Student and Teacher), which lacks support for Exchange and Automator. At $400 or $240 to upgrade, the full Office for Mac that we reviewed feels pricey, even though it includes Exchange support. The $500 Special Media Edition handles Exchange and adds media-management software.