| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Zoom Display for whole workbook
I have number of worksheets in the one workbook all currently sitting at zoom
127% - I want to konw if there is away I can changed the zoom display all on sheets at once to 75% |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Zoom Display for whole workbook
Hi,
Alt+F11 to open VB editor. Double click this workbook and past this in on the right:- Private Sub Workbook_SheetActivate(ByVal Sh As Object) ActiveWindow.Zoom = 75 End Sub Mike "Angie" wrote: I have number of worksheets in the one workbook all currently sitting at zoom 127% - I want to konw if there is away I can changed the zoom display all on sheets at once to 75% |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Zoom Display for whole workbook
Angie, another way
Hold down the Ctrl key and click all the sheet tabs to select them and then set your zoom. Mike "Angie" wrote: I have number of worksheets in the one workbook all currently sitting at zoom 127% - I want to konw if there is away I can changed the zoom display all on sheets at once to 75% |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Zoom Display for whole workbook
Select one sheet then right-click and "select all sheets".
Set the zoom on the active sheet and will be done to all. DO NOT FORGET to ungroup the sheets when done. Gord Dibben MS Excel MVP On Fri, 14 Sep 2007 01:12:02 -0700, Angie wrote: I have number of worksheets in the one workbook all currently sitting at zoom 127% - I want to konw if there is away I can changed the zoom display all on sheets at once to 75% |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display value from another workbook, if less than display a blank | Excel Worksheet Functions | |||
| Arial Font not fixed pitch on display zoom <79% | Excel Discussion (Misc queries) | |||
| How do I display a graph from one workbook to another | Excel Worksheet Functions | |||
| How to display as normal when workbook has been protected | Excel Worksheet Functions | |||
| Cannot display Workbook | Excel Discussion (Misc queries) | |||
Linear Mode
