Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Displaying a Set Column Range.
by Allen Wyatt
(last updated July 23, 2018)
Let's say that you want to display a specific number of columns on a worksheet in the available window space. You can manually figure out the necessary width of each column and do the adjustments, or you can write a macro that will figure out, proportionally, how the width of each column should be adjusted to get the desired results.
An easier method, however, is to just adjust the zoom factor for a desired number of columns. This can be done manually by selecting the columns and then choosing View | Zoom | Fit Selection.
If you want to do it programmatically, it is even easier. Right-click a worksheet tab (the one you want this macro to apply to) and then choose View Code from the resulting Context menu. Excel displays the Visual Basic Editor, and you should enter the following into the code window:
Private Sub Worksheet_Activate() Range("A1:L1").Select ActiveWindow.Zoom = True Range("A1").Select End Sub
This particular macro assumes that you want to view columns A through L in the window. It selects the range A1:L1, and then sets the zooming factor to display just that selection (the columns you want). Finally, it selects cell A1 and ends.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3117) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Displaying a Set Column Range.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
When you have a macro that processes a huge amount of data, it can seem like it takes forever to finish up. These ...Discover More
If your workbook contains links, you are normally given the opportunity to update those links when you open the workbook. ...Discover More
Do you have a macro that need to read and write files? If so, then there is a good chance you need to specify the default ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.