This article is provided by MVP Raddini Rahayu. Microsoft is so thankful that MVP's who proactively share their professional experience with other users. The article would be posted on MVP's website or blog following MVP. Please click here to see another posts shared by MVP.
When you are finished working in Microsoft Excel, sometimes the command buttons on the ribbon are not needed anymore because we have finished setting the format and complete its formulas. Well, to make the Excel view more widely, we can shrink or hide the contents of the ribbon by double click on one of the tabs on the ribbon or right-click and select Minimize the Ribbon.
But apparently that was not enough, the Excel view need to be widely again to full screen view. Unfortunately on Microsoft Excel 2010 version, that feature is not available by default.
To outsmart it we can make it using Macro in Visual Basic Application. But before going into the coding step, so that the macro runs in any Excel file, we have to keep it in the Personal Macro Workbook.
Personal Macro Workbook is a workbook that contains the spcial Excel system named PERSONAL.XLSB. This workbook will be formed if the user create Macros by Recording, and save it in the Personal Macro Workbook.
Personal Macro Workbook is stored in a special folder, according to the user who is logged on. For example, the folder path on my computer is:
This workbook is opened automatically when Excel starts, It's just hidden so that it looks as if there is no open Excel files. How to display it, on the View tab Window category click Unhide then Unhide dialog box is displayed. select PERSONAL and click OK. If you do not find the Personal Macro Workbook in the folder path or by Unhide, maybe you have never created Macros by Recording. So before you going to the next step, you have to create Macros by Recording.
How To Do
After we know what the Personal Macro Workbook and storage location, the next step is coding.
The following are the steps to coding the macro :
On the Developer tab Code category select Visual Basic, so Visual Basic window is displayed.
On the Project taskpane click VBAProject (PERSONAL.XLSB), then on Insert menu select Module and write the following script:
End SubSub FScreen() If Not Application.DisplayFullScreen Then Application.DisplayFullScreen = True Else Application.WindowState = xlNormal Application.WindowState = xlMaximized End If End Sub
If it is completed, close the Visual Basic window and return to Excel. On the Developer tab Code category select Macros, so Macros dialog box is displayed.
Select the macro that we created earlier and then click the Options button. When you choose a character for the shortcut key make sure its not same with the default Excel shortcut key. For example I choose the key combination Ctrl + Q and then click OK.
Now let's try it, press Ctrl+Q on the keyboard, Excel display will change to full screen view, press Ctrl+Q again to return to the original view.
For more Excel solutions you can contact email@example.com or firstname.lastname@example.org
Community Solutions Content Disclaimer
MICROSOFT CORPORATION AND/OR ITS RESPECTIVE SUPPLIERS MAKE NO REPRESENTATIONS ABOUT THE SUITABILITY, RELIABILITY, OR ACCURACY OF THE INFORMATION AND RELATED GRAPHICS CONTAINED HEREIN. ALL SUCH INFORMATION AND RELATED GRAPHICS ARE PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT AND/OR ITS RESPECTIVE SUPPLIERS HEREBY DISCLAIM ALL WARRANTIES AND CONDITIONS WITH REGARD TO THIS INFORMATION AND RELATED GRAPHICS, INCLUDING ALL IMPLIED WARRANTIES AND CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, WORKMANLIKE EFFORT, TITLE AND NON-INFRINGEMENT. YOU SPECIFICALLY AGREE THAT IN NO EVENT SHALL MICROSOFT AND/OR ITS SUPPLIERS BE LIABLE FOR ANY DIRECT, INDIRECT, PUNITIVE, INCIDENTAL, SPECIAL, CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF USE, DATA OR PROFITS, ARISING OUT OF OR IN ANY WAY CONNECTED WITH THE USE OF OR INABILITY TO USE THE INFORMATION AND RELATED GRAPHICS CONTAINED HEREIN, WHETHER BASED ON CONTRACT, TORT, NEGLIGENCE, STRICT LIABILITY OR OTHERWISE, EVEN IF MICROSOFT OR ANY OF ITS SUPPLIERS HAS BEEN ADVISED OF THE POSSIBILITY OF DAMAGES.