With the Freeze Panes option, you can freeze either, or both, the rows or the columns. In this situation, if you go beyond one screen of information, you generally lose the row or column headings so you may not know what the information you are looking at refers to. The Freeze Panes option is often used when you have several columns or rows grouped together. You will be moved to the file you specified.
To move to a different workbook:įrom the Window menu, select the name of the workbook. Using this option may result in multiple versions of the same file being opened. NOTE: Using the Recent Files option from the File menu is not recommended. If you have more than one workbook open, you can move between files using the Window menu. You will be moved to the range you specified.
#HOW TO FREEZE A COLUMN ON EXCEL MAC HOW TO#
The Go To command is also useful when moving between ranges, for a discussion of how to add a range, refer to Working with Range Names: Creating a Range Name. To move to a specific cell of the worksheet, you can use the Go To command.
You can use the Microsoft Excel Help through the Help menu to obtain a complete list of keyboard shortcuts by searching for the keywords keyboard shortcuts. The following table displays some common shortcuts and their keyboard combinations. There are several keyboard shortcuts available to help you move around your worksheets and workbook more efficiently. Learning keyboard shortcuts will save you time when working with your workbook. This document includes tips and shortcuts for navigating a large worksheet and multiple open workbooks in Excel 2008. This article is based on legacy software.Įfficiently navigating a workbook can be challenging when the workbook or worksheets are large.
#HOW TO FREEZE A COLUMN ON EXCEL MAC MAC#
(Archives) Microsoft Excel 2007: Navigating Your Large Workbook Mac
0 kommentar(er)
