Zoom area in Excel: Here's how

In Excel you can zoom marked areas with a simple trick. We'll show you how it's done.

Zoom selected area in Excel with a click of the mouse

• Excel contains the "Fit to marker" option in the "View" -> "Zoom" menu. If you select this view type, the view is enlarged so much that the selected cell area fills the entire window.
• This very practical type of view can only be accessed with great difficulty via the menu. With the lower macro line you can easily call this function with a button.
• In the "View" -> "Toolbars" -> "Customize" submenu, select the "Custom" entry in the "Categories" area.
• Then drag any button to one of the toolbars and assign it the new macro listed below in the dialog box that appears.
• 
  Macro zoom :
  Sub Zoom ()
  Active Window.Zoom = True
  End sub

Read more practical tips on how macros work and how to activate them.