Page break view on excel for mac 2011 full#

If you have a whole bunch, you may want to use a macro to generate the links automatically. This process is quite manual, but itвЂ™s okay if you have a relatively small number of worksheets. Lather, rinse, and repeat until you are through adding the links. Then, selectВ a cell with a sheet name, press Ctrl+K to open the Insert Hyperlink dialog box, click the Place in This Document button, and then link to the sheet. To do this, create a new worksheet and call it вЂњCover SheetвЂќ or something similar.В On this sheet, type the names of all the worksheets in your workbook.

In a nutshell, you add aВ new worksheet to your workbook, list all your worksheet names in a column, and then link each name to its corresponding worksheet, kind of like a table of contents. This second navigationВ technique is more involved, but itвЂ™s very effective.

Page break view on excel for mac 2011 full#

If your workbook has more than 15 sheets, click More Sheets and youвЂ™ll see the full list. You need toВ pretty much right-click ON the buttons themselves.

Now, if youВ donвЂ™t see the worksheetВ menu, you may be right-clicking just above or below the sheet navigation buttons. To make the menu appear, right-click anywhere in the sheet navigation area, outlined in red below: (I first learned of its existence from Jean Philippe, who is one of my favorite coworkers and a huge champion of Excel.) Get Excel Tip 1: Use a pop-up menuДid you know Excel has a pop-up menu that you can use for navigation? This menu is brilliant, yet itвЂ™s hard to discover unless someone tells you about it.